Tag Info

Hot answers tagged

1

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 ...


1

If you do not have any backups that contains the deleted table, you can't restore the database to it's original form.


1

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) ...


1

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