Syncing Dev and Live mySql dbs
Posted: Tue Apr 13, 2004 10:39 pm
I am using mySql on a mac/unix on the dev server, and a remote Free BSD mySql on the live server. I am using phpMyAdmin to deal with both of them.
What is the simplest / best way to regularly update the live server with records I have added to the dev server?
For example, say I add 20 extensive records on the dev server, and later want to move them to the live server. When I used ASP/SQL/Access I would just cut and paste the records via Access - but I am not sure how to do a similar thing with phpMyAdmin.
All I know how to do is export the dev data to a sql file, then truncate the table on the live server, then run the sql export on the live server - but that seems kinda dicey to me (am I right?) - and leaves a bit of a window wherein data is incomplete and generally screwed up.
HELP ME SPOCK!
What is the simplest / best way to regularly update the live server with records I have added to the dev server?
For example, say I add 20 extensive records on the dev server, and later want to move them to the live server. When I used ASP/SQL/Access I would just cut and paste the records via Access - but I am not sure how to do a similar thing with phpMyAdmin.
All I know how to do is export the dev data to a sql file, then truncate the table on the live server, then run the sql export on the live server - but that seems kinda dicey to me (am I right?) - and leaves a bit of a window wherein data is incomplete and generally screwed up.
HELP ME SPOCK!