Saturday, July 3rd, 2010 109 views
If you want to migrate all MySQL databases from one server to another. This was a one time only operation, so setting up replication wasn’t an option. And restoring a backup on the new server involved more downtime than strictly necessary. I figured the most ideal way would be to dump the active MySQL directly [...]
Posted in Knowledge, MYSQL, PHP script | No Comments »
Saturday, June 26th, 2010 196 views
SqlSync lets you compare two databases to see which tuples have been added, removed, and changed. You can also use SqlSync to make one database a clone of another and maintain its contents to be that way. One benefit of using SqlSync to perform synchronization is that you can perform heterogeneous syncs — for example, [...]
Posted in Apache server, How to, Knowledge, Linux system | No Comments »
