An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
0answers
10 views

Ubuntu with LAMP+Mediawiki suffering spikes

I'm sorry if this question is off topic, but I'll give it a shot: I have a VPS running Ubuntu 12.04, a LAMP stack, and Mediawiki. After installing Mediawiki I noticed that my wiki site was spiking, ...
1
vote
0answers
25 views

MySQL: Tab-completion not working [closed]

Tab completion in mysql is not working. I tried to start mysql with mysql --auto-rehash but it didn't work either. I also tried mysql> \# but autocompletion refuses to complete my commands. ...
1
vote
1answer
42 views

Mysqld_multi doesn't recognize groups

I am trying to configure a MySQL server to run multiple instances of the daemon (I wish to duplicate it onto different drives). I've been trying to use the mysqld_multi script. However the script is ...
1
vote
0answers
740 views

mysqld dead but pid file exists

Webserver was running fine for weeks then suddenly: I can access, but I am unable to log into Webmin I can access Magento, a php-based storefront application, but I am no longer able to log in and ...
1
vote
1answer
115 views

Modoboa 1.1.1 Deployment Errors

I try to install modoboa follow this steps: http://modoboa.readthedocs.org/en/latest/getting_started/install.html I installed modoboa with pip install modoboa Traceback (most recent call last): ...
1
vote
2answers
101 views

Allow remote MySQL to a specific IP - using CentOS 6.4

I've spent a day now trying to find out how to allow remote MySQL to work for my other virtual server. This is proving very difficult so I'm hoping you guys could help me out ;( I've used the ...
1
vote
0answers
31 views

Restore deleted Mysql Directory in linux [duplicate]

My MySQL directory has been deleted from directory /root/var/ by mistake, we need to restore it, Is it possible ?
1
vote
0answers
42 views

Mysql user privileges : Only CREATE table

I am trying to create a user who will be able to manage all databases without the right to CREATE and DROP databases. I have been using the following link : ...
1
vote
1answer
325 views

ERROR: could not find driver after changing from mysql to mariadb

mysql was working fine but I wanted to give mariadb a try on a new server I have going. However I am having an issue where all my php websites seem to have issues communicating with mariadb. Webmin ...
1
vote
1answer
75 views

Can anybody help me with MYSQL not starting

Here is a my error log file [localhost:local/mysql-5.5.15-osx10.6-x86_64/data] root# sudo localhost.err localhost1.err 130911 14:16:24 mysqld_safe Starting mysqld daemon with databases from ...
1
vote
1answer
63 views

MySQL 3.23 on Centos 6?

Don't ask why, just is it possible to install old mysql 3.23 on new CentOS 6.4 i386 or x64 version (same to me)?
1
vote
1answer
650 views

How can I install mysql on an angstrom distribution?

I tried using a different distribution (debian) but the rest of my application did not work. I've tried opkg install mysql-client and opkg install mysql-server however I get the error Unknown package ...
1
vote
1answer
118 views

mysql database dump script adding fuctionality to skip dumped database

I'm using the following script to dump my database. it works great. I want to add functionality that it first checks if a database table is already dumped or not, if a dump exists then it should be ...
1
vote
0answers
99 views

Data loss prevention ( or recovery) in a MySql db in embedded systems

I have a little ( big ) problem with a MySql application that write on a SD card or a Compact Flash. After a data loss ( a power failure , for example) , if I try to retrieve the data of my db , it ...
1
vote
0answers
287 views

Amazon EC2 MySQL Failed to Start

I'm having issues starting MySQL after it randomly stopped working a few minutes ago. I'm getting this error while trying to connect: Connect failed: Can't connect to local MySQL server through ...
1
vote
1answer
284 views

gcc not found when installing mysqldb for django 1.4

I am trying to install the python module mysqldb which is the python interface for mysql. I need this module because I am creating a Django development server (Django 1.4, OpenSUSE) and the database ...
1
vote
2answers
425 views

Import single rows from SQLite to MySQL?

I need to do some kind of incremental import again and again from a SQLite 3 database to a MySQL database. Column names are the same in both databases. Is there a good way to do this by a script ...
1
vote
0answers
210 views

Force mysqldump encoding

I have two mysql servers, viewed from the same mysql client, right_server is rendering the french characters correctly, wrong_server is not. Encoding is the same : $ mysql -h right_server -NBe "SHOW ...
1
vote
0answers
957 views

Fedora Failed to get D-Bus connection

I have a VPS with fedora 16 installed. I have setup mysql and it was working a couple of days ago. Now suddenly when I try to start mysql I get the error: Failed to get D-Bus connection: Failed to ...
1
vote
0answers
474 views

Can't make a copy of /var/lib/mysql/ibdata1

I have a RedHat Linux server and I'm trying to make a copy of /var/lib/mysql/ibdata1, but I'm receiving an error saying permission denied and the file cannot be opened. I'm logged in as root user and ...
1
vote
1answer
319 views

postfix: save all incoming Mails in MySQL DB and have all addresses Verified for big servers

I am new to all that server based stuff. New to Postfix and new to Ubuntu. I have an Ubuntu v-server with Postfix, PHP and MySQL installed. Also I have an own domain. So far, I managed to receive any ...
0
votes
3answers
209 views

Brand new to Linux - running a web server/database server, need to connect to my servers- how?

I am brand new to Linux. I have a database server and web server both running CentOS. My database server will host MySQL and my web server will host Apache. I am very familiar with Windows and ...
0
votes
2answers
379 views

How do I install software on Fedora 13?

I installed Fedora 13, but it doesn't come with a lot of software I want -- office tools, productivity, GUI environments, MySQL, and Kamailio. How do I get all this stuff onto my Fedora install?
0
votes
1answer
126 views

How do I make a tmpfs mountpoint persistent across reboots?

If I create a ram disk on cent os using tmpfs will it go away on restart? I know the data will go away (I would assume), but will it still survive a reboot? I am going to allocate a ram disk for use ...
0
votes
3answers
55 views

How do you view a sql.gz file as plain text SQL from the command line?

How do you view a sql.gz file as plain text SQL from the command line? I want to read the SQL statements stored in a .sql.gz file, from the command line on the server. I've tried tar -xzvf, but get ...
0
votes
1answer
162 views

Where does MySQL store its databases on Debian?

Our system crashed and we're trying to recover our data. The disc is fine, but the OS is gone, so I'm trying to get at the actual MySQL database files. Does anybody know where to look for them in a ...
0
votes
1answer
579 views

How to reduce buffers\cache

A monitoring system keeps alerting that my machine is reaching\breaking through it's RAM utilization threshold which is 15 GBs. I've done some reading and understood that the apparent RAM utilization ...
0
votes
1answer
50 views

how to ignore a MySql error and go on to the next query?

I have created a shell script to connect to a DateBase and INSERT IPs and MACs from dhcpd.log file by connecting to the DB only once: #/!bin/bash dhcpLogFile="/var/log/dhcpd.log" NumberOfLines=$(awk ...
0
votes
2answers
42 views

Yum- upgrading packages that are running

Is Yum designed in such a way (or is the underlying system) that you can safely upgrade a binary while it's running? For example, you have MySQL 5.5 and you run yum -y install mysql56-server to ...
0
votes
3answers
82 views

How to know list of applications installed in my server? [closed]

I got one LINUX server in which Oracle LINUX 5 is installed. I have installed MySQL 5.1.73-community version. Now, I have to configure the variables. When I checked available memory through cat ...
0
votes
1answer
207 views

Wordpress won't recognize the MySQL database

I want to install Wordpress on Archlinux but I have this error: Your PHP installation appears to be missing the MySQL extension which is required by WordPress. I un-commented this line in ...
0
votes
2answers
421 views

How to view a list of previously run mysql queries in a live feed format?

How do i view the last run queries in mysql in a live feed format? I want to leave my terminal window open and just have mysql queries pop up on the screen whenever something is run. I know I can do ...
0
votes
3answers
248 views

Why “Linux Generic” use RPM extension in MySQL download page?

I need to install MySQL 5.5 from source in Ubuntu 10.04. So I'm trying to find tar.gz source from here. But when choosing "Linux Generic" from the drop down menu, it is showing an RPM extension I ...
0
votes
2answers
469 views

Need to install MySQL Client libaries but RPM not installing them

I'm trying install the MySQL Client libraries for the Perl Mod of the same name but when I run sudo rpm --install -v --allfiles MySQL-client-5.5.16-1.linux2.6.i386.rpm and querying the rpm ...
0
votes
1answer
44 views

Linux iptables DNAT 53306 to 127.0.0.1 3306

mysql real port is 3306。 I want public network using 53306 to visit mysql, and 3306 is not allowed access from public network. How to write the iptables rules DNAT 53306 to 127.0.0.1 3306?
0
votes
1answer
71 views

Creating operating system (OS) user in Oracle LINUX

I am a user with sudo access. To install MySQL, I have to create an operating system (OS) user called MySQL. Can I create a user which also has sudo access on this machine?
0
votes
3answers
64 views

Where Is MySQL installed on My Machine?

What is going on, everybody? Recently I have installed MySQL server on my Debian machine using Advanced Packaging Tool, and I am curious where it is installed and how I can find all the source files ...
0
votes
2answers
28 views

mysql USER unclear about what can be dropped?

When show databases there is the information_schema below it listing my created databases but what is 'USER' and 'mysql' listed in there? I don't know if ages ago I made a mistake and created them ...
0
votes
1answer
486 views

Create multiple databases in one command line?

Can this command be scripted? $ mysqladmin -u username -p create databasename I'd like to do it for multiple names all at once? Also I'd like to then set permissions for all of them at once as ...
0
votes
2answers
48 views

MySQL exact path

I am using whereis mysql in my terminal to get exact location of my MySQL installation, but it's showing too many locations: mysql: /usr/bin/mysql /etc/mysql /usr/lib/mysql /usr/bin/X11/mysql ...
0
votes
1answer
174 views

Catch all emails and save them in MySQL

I want to do something like Facebook has with it message system. When you reply to email sent from Facebook User, it automatically gets in his message box. This is done, because you reply to ...
0
votes
2answers
880 views

How to install MySql on Red Hat 6.1?

I am trying to install MySQL-server-5.6.12-1.el6.i686.rpm on a Red Hat Enterprise 6.1 server. I receive the following error: rpm -Uvh MySQL-server-5.6.12-1.el6.i686.rpm error: Failed dependencies: ...
0
votes
2answers
111 views

Is it not possible to store my local websites in my Dropbox folder?

I have a bunch of web sites that I develop, and I run an Apache server locally to do debugging and design. The web sites use Apache, PHP, and MySQL. To be clear, my Apache server is not serving these ...
0
votes
1answer
176 views

Use an existing wampserver from a windows partition on linux mint

I dual boot Windows 7 and Linux Mint 14. I have wampserver installed on Win 7 and have a couple of websites already set up there. Is it possible to use that same installation apache/mysql/php ...
0
votes
2answers
1k views

Cron job not running / not successful?

I have a couple of cron jobs set up to maintain a local copy of a remote database. The first one downloads the latest version of the database from the remote machine, which runs every day and is ...
0
votes
1answer
126 views

from a laptop with CentOS 6.3 what is the command line to talk mysql server on my pc?

I have CentOS 6.3 running on my laptop which is already connected to the net. What is the command line to talk to MySQL server on my PC? Both devices are connected via my router and they can talk ...
0
votes
3answers
825 views

How to create an interactive bash script to collect arguments for a command in linux?

I'm trying to create an interactive bash script where I can collect user input variables to be used as arguments in another command. Can someone provide me an example of this? Currently i want to do: ...
0
votes
2answers
139 views

phpmyadmin is listing my server version and client version as being different

In a continuation of this question, I have purged the 5.1 client via sudo apt-get purge mysql-client-core-5.1. I have reinstalled the 5.5 client - sudo apt-get --reinstall install mysql-client-5.5 ...
0
votes
1answer
292 views

Force users to change email password every six months

I'm going to build an experimental mail server with Postfix + Dovecot and Mysql for user accounts. The server will offer SMTP + POP3 + IMAP. Is there a way to force users to change their mail account ...
0
votes
1answer
368 views

Installing glibc 2.3 for mysql server

I need to install mysql server and client for a project of mine so I downloaded the MySQL-client-5.1.61-1.glibc23.i386.rpm for the client and MySQL-server-5.1.61-1.glibc23.i386.rpm for the server. I ...