MySQL backup error

 Posted on August 9, 2012  |  1 minutes  |  188 words  |  Ton Kersten

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

 Posted on January 20, 2012  |  2 minutes  |  388 words  |  Ton Kersten

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

 Posted on October 14, 2010  |  1 minutes  |  36 words  |  Ton Kersten

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

 Posted on July 26, 2010  |  1 minutes  |  112 words  |  Ton Kersten

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

 Posted on July 21, 2010  |  1 minutes  |  90 words  |  Ton Kersten

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