An open-source, relational database management system.
4
votes
3answers
886 views
Selinux is denying access to mysqld
I have a script that dumps a mysql database. It then compresses the file and this gets stored in my home folder by using cron. The problem is I seem to be getting an error message.
mysqldump: ...
1
vote
2answers
278 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 ...
0
votes
2answers
59 views
Open source MySQL performance tool
Are there any open source MySQL performance tools to help optimize SQL queries?
2
votes
1answer
100 views
How to copy the whole MySQL DB between two servers?
There is a very good connection between the two machines (MySQL 5.5.28):
mysqldump -u root -p'password' --all-databases | ssh root@SERVERNAME mysql -u root -p'password' --all-databases
So AFAIK ...
0
votes
1answer
522 views
Error compiling OSSEC HIDS with Mysql support
I work with OSSEC HIDS In Ubuntu 11.10 from the instructions on the OSSEC wiki.
When I install with mysql support, I get this error
/tmp/ccuS4FYw.o: In function mysql_osdb_connect': ...
-2
votes
1answer
75 views
How to set System Variable for mySQL in RHEL 6.2?
I am currently working on mySQL 5.6.10 server and RHEL 6.2. I need to set the system variable PATH for mySQL on RHEL 6.2 Terminal. How do I set it?
I also want to run a .sql file on Linux. I am using ...
6
votes
0answers
432 views
FreeBSD: “Too many open files” but should be able to open another 160,000 files
I have a FreeBSD 8 system running ZFS, with a MySQL 5.5 server which is about 355GB and projected to grow to be a couple of Terabytes.
MySQL is triggering errors about "Too many open files" on ...
3
votes
0answers
177 views
MySQL stop/waiting issues; “can't connect … through socket”
So this was my first time putting up a LAMP stack on a Bodhi machine (previously experience with WAMP, and LAMP on 10.04); I got Apache going, and a Drupal install begun, then I go to create a new ...
2
votes
0answers
60 views
No communication services enabled following startup
I recently installed Parsix (Debian) on my system, and I've been struggling to figure out how to autostart my services. Of the list of services that don't run and should run are:
ssh
apache
mysql
...
2
votes
0answers
674 views
MySQL socket and PHP (and other languages)
Background info
I'm currently running CentOS (or Red Hat?).
uname -a gives (I edited out my domain name)
Linux XXXXXXXXX.com 2.6.32-71.29.1.el6.x86_64 #1 SMP Mon Jun 27 19:49:27 BST 2011 x86_64 ...
1
vote
0answers
33 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
0answers
120 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
689 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
306 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 ...
0
votes
0answers
167 views
What caused my CentOS 6.4 box to reboot itself?
I noticed that the MySQL daemon running on my CentOS 6.4 machine was suddenly not running anymore. I checked the MySQL log, but didn't see anything relevant:
121229 22:17:45 mysqld_safe mysqld from ...
0
votes
0answers
245 views
dependency problems prevent configuration of mysql-server
This question has been asked verbatim about a dozen times on this forum, and yet none of the solutions have worked for me.
I'm trying to install mysql and everytime I try to install I get this ...
0
votes
0answers
74 views
Failure to install MySQL
I attempted to install MySQL using Synaptic but it failed to start on update with the following output:
Selecting previously unselected package mysql-client.
(Reading database ... 131143 files and ...
0
votes
0answers
60 views
proftpd mod mysql
I've setuped a proftpd server on a distant host. I made it work in some simple way, actif mod, with unix user, blocking user in /var/www. It was working nice, but now I need the mod sql (package ...
