[prog] mysqldump- is there a better way

Nicki Handy nicki at virtualnicki.com
Wed Sep 21 00:53:19 EST 2005


Now that I solved that problem, I'm running into a problem where in the 
old database, the first auto_increment value for a column is 0 rather 
than 1 but the new database doesn't want to put a 0 in - it errors 
everytime that there's a duplicate value 1 b/c it's already put the 1 
in the first insert.

This leads me to believe that I might not be doing this right to begin 
with. Is there a better way to get one database from one server to 
another, which is an upgraded version of mysql? Is mysqldump too error 
prone.

Thanks
Nicki




More information about the Programming mailing list