6.0

Mysql Server 6.0 online backup script

Got some good news there sport fans (actually MySQL fans, but who really reads this anyway), the script got updated for the 3rd and probably final time (lie).

It can perform backups for earlier versions of Mysql (5.*, 4.*) using the mysqldump utility, it will auto-detect the backup type it performed and select the appropriate way of restore "on the fly". Of course you can use mysqldump on version 6.0 but why would you want to do that! :)
Another option was added in the config_file so be sure to check it out, when upgrading. (BTW upgrading using the install will replace your config-file)

Mysql Server 6.0 will be a great database when it reaches GA level, unlike it's earlier version (5.1, 5.0, 4.*) Mysql 6.0 has a lot of new features.
The one that stands out IMO is the possibility of performing a hot database backup ( AKA online).

You can simply connect to the server with the mysql client and: BACKUP DATABASE database TO 'path/to/backup/backup.bkp'; and that's it, you just backed up your database.
When restoring it's enough to issue this command RESTORE from 'path/to/backup/backup.bkp'; and you're done.