Hi, I'm moving very sensitive production servers to a new environment and am looking at ways to copy their databases without down time.
We have one MySQL database and one PostgresQL database. For MySQL I found the following instructions which were exactly what I imagined I should use - i.e. turn on replication between the old and the new databases then switch over. The only worry I had was that I never used MySQL replication before so having specific instructions (and an option to test them in our test environment) helps reduce the stress levels (we use MySQL 5.0.45 which comes with CentOS 5): http://www.softwareprojects.com/resources/programming/t-how-to-move-copy-a-live-mysql-database-and-what-1257.html For PostgresQL, it's less of a problem because it's a mostly "read only" database which only our stuff updates, so a simple dump/restore is enough but I was curios whether there is a simple way to do the same "one-off" replication as described in the above instructions for MySQL. Is there? Thanks, --Amos ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
