MySQL backup error
Posted on August 9, 2012
(Last modified on August 22, 2024)
| 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.
MySQL database replication
Posted on January 20, 2012
(Last modified on August 22, 2024)
| 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.
Bugfix in Mysqlbackup
Posted on October 14, 2010
(Last modified on August 22, 2024)
| 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.
New MySQL backup
Posted on July 26, 2010
(Last modified on August 22, 2024)
| 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.
New MySQLBackup
Posted on July 21, 2010
(Last modified on August 22, 2024)
| 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.