Hot answers tagged backup
You literally do not need a third party tool. STEP 01 Find out the path to the data by running mysql> SHOW GLOBAL VARIABLES LIKE 'datadir'; For this example, let's suppose it is C:\Program Files\MySQL\MySQL 5.6\data STEP 02 Pick a destination folder to copy the data directory For this example, let's pick D:\MySQLBackup STEP 03 Create batch file ...
If you do not have any backups that contains the deleted table, you can't restore the database to it's original form.
Basically, you need the following paradigm Session #1 (MySQL) Lock all tables Read Lock Sleep for a Long Time Session #2 (Windows) : This you are already doing Copy the .frm, .MYD, .MYI files for every MyISAM table Session #3 (After Session #2 is Complete) Look for Sleeping Connection of Session #1 Kill the SLEEP Query (Session #1 Will Terminate) ...
This is related to a bug with new installs of mysql on debian wheezy whereby the error.log file is owned by root.root, as per this: http://tipstricks.itmatrix.eu/?p=1352 I fixed it with chown mysql.adm /var/log/mysql/error.log
Only top voted, non community-wiki answers of a minimum length are eligible