1
vote
2answers
204 views

How do I silence mysqlcheck?

If I use for example: mysqlcheck syscp --silent --auto-repair I still get the note: syscp.panel_sessions note : The storage engine for the table doesn't support check this is strange, ...
0
votes
1answer
89 views

Why does the mysql backup grow if a table is crashed?

I use this backup script on my debian squeeze server to create a backup of all mysqltables: #!/bin/sh BACKUP_DIR=/var/backups/mysql/ DATE=$(date +%Y-%m-%d) for i in /var/lib/mysql/*/; do ...
-1
votes
2answers
120 views

Why did mySQL stop working after I entered some iptables commands? [closed]

I entered the following commands into a Debian Linux terminal: sysctl net.ipv4.ip_forward=1 iptables -t nat -A PREROUTING -p tcp --dport Port2 -j DNAT --to-destination yyy.yyy.yyy.yyy:Port1 iptables ...
0
votes
1answer
237 views

Why Monit does not work with my MySQL configuration file?

I'm using a custom configuration file for mysql in /etc/mysql/conf.d/myfile.cnf The contents of the file [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket ...
0
votes
1answer
201 views

Services decide to shutdown from time to time

I've a debian squeeze server with nginx, php5-fpm and mysql. All this services from some point started to shutdown at random time. And they not seem to crash or something, syslog: Feb 14 14:02:14 xxx ...
1
vote
3answers
119 views

How to determine which SSL library MySQL is using?

My Debian squeeze server is running mysqld version 5.1. How do I determine if the SSL libraries it is using are OpenSSL or yaSSL? (I am pretty sure this MySQL supports SSL as the User table has the ...
1
vote
1answer
73 views

Debian server, Workbench client or server side?

We have a server running Debian squeeze with mysql and until now we manage the db through phpMyAdmin. In this question I was told that Workbench represents a better choice than PMA in terms of ...
0
votes
1answer
166 views

why installing mysql-server wants to remove sysvinit

I want to install mysql-server-5.5 in a new Debian Squeeze installation, but when I start to install it I get a warning that I don't see as being a requirement: WARNING: The following essential ...
0
votes
1answer
784 views

Logging MySQL events to file in addition to syslog on Debian

By default, Debian uses rsyslog to handle MySQL error logging. I like this behavior and do not want to change it. However, I would like rsyslog to write MySQL events to /var/log/mysqld.log in ...
4
votes
3answers
1k views

Is there a safer way to stop mysql(d)?

I'm running very hard php script on my cheap virtual machine, which has about half million page views a week so it's a bit problematic. I restart my mysql twice a day. That wouldn't be problem, but ...
1
vote
2answers
306 views

Weird MySQL Errors After Distrib Upgrade (SQL 5.0 > 5.1)

Just updated Debian from Lenny to Squeeze on one of my servers. It hosts a MySQL server. Upgrade went fine, but afterwords, when MySQL starts up, it checks the databases to make sure they are okay. I ...
1
vote
2answers
573 views

Compile MySQL 5.5.15 from source using autorun.sh and cmake, unable to start MySQL after

I was trying to compile MySQL 5.5.15 from source in Debian 6 and was using the "old-fashioned" way of doing it: i.e., run autorun.sh in BUILD and then run ./configure with quite a few options, and ...
1
vote
1answer
8k views

MySQL on Debian: “Checking for corrupt, not cleanly closed and upgrade needing tables..”

I'm an old hand at Linux but am new to Debian. On Debian 6, I apt-got mysql and then started it. I mucked around with the my.cnf and messed it up...apparently in debian-land, they really want to ...