[prog] mysqldump- is there a better way

[Nicki Handy]

Thanks, I'll try this. The servers are on different machines so I'm not 
sure how that will work, but I have some ideas. I will check out the 
docs again- I also saw a migration tool so thought of giving that a 
shot. I'm just worried that in the 4.1, they decided there should be no 
sequencing starting on 0 and have disallowed it, but we'll see.
Thanks

On Sep 20, 2005, at 5:42 PM, Rachel McConnell wrote:

> For a one-time move, I can think of two options:
>
> 1. As you are doing, dump contents of the earlier version db and 
> restore into the more recent version.  With this option, you actually 
> have several sub-options based on the versions of the mysql client 
> programs you have.  I am guessing that you've been using mysqldump v. 
> 3.x to make the dump, and mysql version 4.x to restore?  See if you 
> can make a dump using the 4.x version of mysqldump, pointing at the 
> 3.x server.  This may not work due to the version mismatch, but if it 
> does there's a high liklihood that the restore will go smoothly.
>
> 2. Upgrade the installation directly.  For safety & testing, of 
> course, copy the original database to a new installation of the same 
> version, and upgrade that.  There is a lot of info on upgrading a 
> MySQL installation on the MySQL website, and the upgrade from 3.23 to 
> 4.0 page is here: 
> http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html
>
>
> Good luck!
> Rachel
>
> Nicki Handy wrote:
>> 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
>> _______________________________________________
>> Programming mailing list
>> Programming at linuxchix.org
>> http://mailman.linuxchix.org/mailman/listinfo/programming
> _______________________________________________
> Programming mailing list
> Programming at linuxchix.org
> http://mailman.linuxchix.org/mailman/listinfo/programming
>