MySQL Forums
Forum List  »  Other Migration

Permenant lock tables?
Posted by: Bryan Field
Date: January 11, 2009 07:33AM

Given a mysql server with many databases:

If I want to move a software system (and it's database) to a new server.

What is the best way to stop the data in the database from changing before I start the transfer?

- I could use a lock tables technique, but that would require that I keep a MySQL connection open until the transfer is complete. I could do that if I needed to.
- Rename database does not work in newer versions of MySQL.
- I could rename the directory, but that seems like a dangerous way to interrupt MySQL.
- I would like for the existing connections to close before the move. That way I will not interrupt a running application. If I used that idea, I would want a timeout.
- The existing databases must to continue operate through the whole thing.

Any ideas?

Options: ReplyQuote


Subject
Views
Written By
Posted
Permenant lock tables?
4336
January 11, 2009 07:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.