Your MySQL script was running great, but then you started getting errors – If you get this warning when dumping the mysql database, it’s not a bug – MySQL did this on purpose because they wanted people to know that they weren’t dumping the event table. Previous versions did not give the warning.
|
1 |
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. |
Do you care about the mysql.event table? It’s for scheduled events (introduced in 5.1.6). More information about it can be found on the MySQL Event Scheduler page.
If you DO want to dump it, change:
|
1 |
mysqldump -uroot mysql > /tmp/mysql.sql |
to:
|
1 |
mysqldump -uroot --events mysql > /tmp/mysql.sql |
If you DON’T want to dump it, change:
|
1 |
mysqldump -uroot mysql > /tmp/mysql.sql |
to:
|
1 |
mysqldump -uroot --events --ignore-table=mysql.event mysql > /tmp/mysql.sql |
Also – if you’re interested, we have created a nice script to dump all of your MySQL databases nightly!
Related posts from Linux Brigade!
Move MySQL tmp directory You’ll eventually run into a client who has a crashed table in their database – this table will be pretty large – maybe even larger than the system’s default temporary directory (usually […]- Import MySQL database from command line You’ll need to import a database via command line from time to time – I’ll normally opt for this anyway. After seeing how easy it is, you’ll probably end up using the command line instead […]
- Check, repair, optimize all databases with one command My server had some tables marked as ‘crashed’ in one of the databases.. the server had recently gone down pretty harshly so I wanted to go through and check, repair and optimize all of the […]
- Back up all of your mysql databases nightly Have you ever wanted to make your own MySQL database backups? You can use this script I wrote to make a backup of all databases, then save each one in a dated backup directory. It will […]
Install nrpe on XenServer If you are using nagios in your hosting environment and need to install nrpe on your XenServer servers, here’s a good way to do it.
I’m using XenServer 6.1 (latest version).First, […]
