Warning: WP_Syntax::substituteToken(): Argument #1 ($match) must be passed by reference, value given in /membri/maips21/wp-content/plugins/wp-syntax/wp-syntax.php on line 380
Warning: WP_Syntax::substituteToken(): Argument #1 ($match) must be passed by reference, value given in /membri/maips21/wp-content/plugins/wp-syntax/wp-syntax.php on line 380
In a recovery procedure for a productive environment I faced a MySQL subtask. My need was to restore a productive DB from a backup virtual machine.
So, I had 2 MySQL db server:
- DB Live (ip: 192.168.0.1, schema: webapp)
- DB Recovery (ip: 192.168.0.2, schema: webapp)
The first step was to delete all the tables from the productive schema. MySQL does not provide any command like “DROP ALL TABLES” but I found a good Unix script:
mysql --host='192.168.0.1' --user=root --password=pass -BNe "show tables" webapp | awk '{print "drop table " $1 ";"}' | mysql --host='192.168.0.1' --user=root --password=pass webapp |
The second step was to bring all recovery data into live production server. For different reasons, I had to do this operation in one single step, without having any dump .sql file to export / restore. Again, a good unix command help me:
mysqldump --host='192.168.0.2' --user=root --password=pass --single-transaction --flush-logs --hex-blob --max_allowed_packet=512MÂ webapp | mysql --host='192.168.0.1' --user=root --password=pass webapp |
And the game is done.
Be First to Comment