|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: backup from a slave
From: MAS! (urkapd
gmail.com)
Date: Tue May 05 2009 - 10:53:19 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> One way to do this would be to issue a 'stop slave;' on the slave
> you are taking a backup from just before the backup starts. Then
> issue a 'show slave status\G' to get the master log file and
> position. You can use this to setup the new slave properly.
>
ok, thanks, I was thinking it'd be a better solution.
btw, I have to get the Master_Log_File and Read_Master_Log_Pos or
Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave
correctly !?
(my slave is not always updated in 'realtime')
thank you in advance
MAS!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]