Re: Restarting slave after interruption
- Date: Fri, 23 May 2008 16:45:04 -0400
- From: François Beausoleil <fbeausoleil@xxxxxxxx>
- Subject: Re: Restarting slave after interruption
Thanks Mike!
Le 2008-05-22 à 17:13, Mike a écrit :
If your taking a dump of the master open two windows. Don't close
either
In the first lock all tables with FLUSH ALL TABLES WITH READ LOCK; &
master status;
Then in the second window procedure with mysqldump.
The exact syntax was FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS;
Bye !
François
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx