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) ...
Straight to answer your questions : Can I stop, pause, or cancel the backup after it has started if it is taking too long or slowing things down too much? You cannot pause a backup - either running using Tsql or using sql agent job. You can stop it or kill it using the kill spid command. you have to be cautious as if you kill a job that is already ...
Only top voted, non community-wiki answers of a minimum length are eligible