MySQL backup error

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  linux 

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]
mysql 

Bugfix in Mysqlbackup

Harry Sappe reported a bug in Mysqlbackup.

When only dumping one database the program gives an unbound variable.

I repaired id an a new version is now online. It’s in the Files section or on Github.

mysql 

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]
mysql 

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]
mysql