After upgrading my MySQL database server from version 5.0.95 to 5.1.61 I suddenly got these errors in the backup logging.
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `EVENTS`': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577) dbdump gave errorcode 2 for database 'information_schema' 2012-08-09 09:07:53 -> Finished MySQL backup on host 'xxx.tonkersten.com' Hmm, no idea what has happened. I hope I didn’t do something stupid.
[Read More]
MySQL database replication
This week I was asked to setup a system with a single MySQL master server and a couple of slave servers. I have done that before, so there is no problem. The problem is that I do not do that on a daily basis, so I need to check the commands every time I set it up. So, as a note to myself I describe how to setup a single MySQL master with multiple slaves.
[Read More]
Bugfix in Mysqlbackup
New MySQL backup
It’s been a while, but now there is a new version of the MySQLBackup script.
This version (1.42) has a few enhancements and some configuration options were added.
The main new feature is that it now supports multiple dumps per day and database checks. The old backups will be removed, of course, but only when they are over a day old.
An added configuration option is that it’s now possible to choose whether you want the databases locked during the backup.
[Read More]
New MySQLBackup
It’s been a while, but now there is a new version of the MySQLBackup script.
This version (1.42) has a few enhancements and some configuration options were added.
The main new feature is that it now supports multiple dumps per day and database checks. The old backups will be removed, of course, but only when they are over a day old.
An added configuration option is that it’s now possible to choose whether you want the databases locked during the backup.
[Read More]