Page 1 of 1

sinc two mysql database

Posted: Sat Jul 25, 2009 6:36 am
by srdva59
hi,
i have my server on real world and my a bd on my pc of work
and i need something to sinc the two bd.
there is some internal function that to that or a script?
i don“t have time to build a script for this
the objetive is to have the to bd equal in new records and edit and deleted
any values.
thanks for your help
:)

Re: sinc two mysql database

Posted: Sat Jul 25, 2009 8:28 am
by Eric!
I had a bit of trouble understanding "bd" so here's a general answer.

If your local copy is just a copy of the remote live one, you can just do a dump of the remote database using LOAD DATA INFILE then putting it back into your local copy.

Examples of backing up here:
http://www.php-mysql-tutorial.com/wikis ... bases.aspx

If you are trying to compare and actually synchronize two databases, you'll have to sort through all the entries based on a critera of priority to UPDATE either the remote or the local database.

I've seen freeware tools for mysql synchronization, but I don't think there are any built in commands for it.
http://www.sourcecodeonline.com/details ... ation.html