3
votes
1answer
1k views

How to avoid mysqldump warning “Skipping the data of table mysql.event”

After a recent Debian upgrade on my LAMP webserver to Wheezy, mysqldump is throwing a warning: -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. Events ...
1
vote
2answers
648 views

mysqldump isn't able to export a specific database, phpMyAdmin crashes

I'm experiencing problems with a database on my server (Note: All other databases work fine). Once I try to export it with mysqldump I get this error: # mysqldump -u root -pXXXXXXXXX databasename ...
1
vote
0answers
201 views

mysqldump not working/running via cron job [duplicate]

I have a crontask which runs at 1am every morning and dumps all databases. 0 1 * * * /var/backups/dumpit.sh 2>&1>> /var/backups/dumpit.log The dumpit.sh source: #!/bin/bash ...
6
votes
1answer
803 views

System Upgrade introduced an unusual mysql privilege error

After a box running mysql was upgraded a backup script is returning an error for databases with Innodb tables. A system running Debian 5 (Lenny) has been upgraded to Debian 6 (Squeeze), and the ...
0
votes
3answers
1k views

Mysqldump Lock Table error while running script

I have written a shell script to backup mysql all databases. The script works without any issues except this error "mysqldump: Got error: 1017: Can't find file: 'drupal_install_test' (errno: 2) when ...