Mysql dump script
Due to some problems we needed to restore the backup of 1 mysql database. I’ve got my mysql dump script installed on that system so that won’t be any problem.
Think again… There are 37 mysql database, with a total of almost 300Meg data. This is stored in one single gziped file of 30Meg. It isn’t easy to find the correct database.
Let’s fix this… We want 1 .tar.gz file containing the dumps of all database, every database is stored in a seperate file.
With the command mysqlshow you get a list of all database in mysql. The command mysqldump with the databasename as an argument will dump only that database.
Put this all together and you have version 0.4 of my mysqldump script.