Hello
I need to move my databases from on server to an other.
As lots of data are in production I cannot just stop mysql for 1/2 an
hour and reopen it on the new server.
What I expect to do is while backuping and restoring to the new server,
I wish to set the original server in "read only" mode so that nobody can
write in the databases while transfering to the new one.
I've seen the LOCK table and flush commands, but I'am not sure if this
is the right method, and how to use them.
Lock table just locks tables as it's name implies and not a whole
database ? is there a kind of "lock all databases" ?
thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
