Re: Newbie - Synchronisation possible?
Posted by:
Arie Nagel
Date: August 22, 2005 06:46AM
If you dump your local database using mysqldump it creates a file containing the instructions for re-creating the dumped database. If you open this file in your favorite text editor you will probably see statements such as: DROP TABLE IF EXSISTS...
If you use such a dump to transfer the data to your server it will effectively delete the existing (database), tables, create new ones and fill the new tables with data. Any data that was in the database on the server will be lost.
So if you're looking to synchronise the two databases this is probably not the way to go.
You might have better luck posting this question in the replication forum.
Good luck.
Subject
Written By
Posted
Re: Newbie - Synchronisation possible?
August 22, 2005 06:46AM
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.