In addition to my recent post, I just had to go into using the –use-tts for specific tables and selective backup sets.
As all my schemas were employeesn, I thought it would be a good idea to run:
mysqlbackup -uroot --socket=/tmp/mysql.sock --backup-dir=/home/mysql/MEB/restore \ --with-timestamp --use-tts --include=employees* backup
as I want all the tables. If I only wanted a specific table, say ‘salaries’ I could have done:
mysqlbackup -uroot --socket=/tmp/mysql.sock --backup-dir=/home/mysql/MEB/restore \ --with-timestamp --use-tts --include=employees*\.*salaries backup
and backup just the ‘salaries’ tables but from all the employeesn databases.
then.. be a mean little dba:
drop database employees; drop database employees10; drop database employees11; .. .. drop database employees2; drop database employees20; drop database …[Read more]