It is recommended that you upgrade to 4.0.x first from 3.23.xx, because of any changes to the grant tables in the mysql database, make sure you read the upgrade notes before upggrading, here's a good link to upgrade,
http://dev.mysql.com/doc/mysql/en/upgrade.html I find it very simple to zip all the databases to be dumped from the old server, and unzip them into the new box instead of a mysqlimport etc.... and hopefully it should work, # zip -r backup.zip database1 database2 ... .... ..... the go to data dir and #unzip backup.zip Kishore On 6/14/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > different box, different versions, use export/import (backup table or LOAD > DATA) > > Mathias > > > > Selon Kory Wheatley <[EMAIL PROTECTED]>: > > > I want to backup our entire Mysql database structure > > for > > mysql 3.23.58 and dump it in the newly installed > > mysql 4.1.10 > > > > What is the best command to do a backup and dump > > everything into the new MYSQL version on a different box? > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]