I'm trying to synchronize two mySQL databases - more specifically, copy the contents of one to another.
I have been using the myPHPAdmin Synchronize function but the target database does seems to have rows missing from it.
The data is in english, with some numeric fields too. As a result there special characters such as commas, apostophries, ampersands etc.
Could that be the reason and if so, how do I get round it?
Any help would be warmly welcomed.