>From your description, I assume you already have data in an existing version 4 database that has existing table structures that are different from your 3.23 dump.
One method of preserving your existing 4.x data would be to create a new database in the 4.x version for importing your 3.23 data. When you have accomplished this you will need to run an alter table on your newly populated database to bring it up to speed with your existing 4.x database. Then create an output file from the existing database that will create update statements that can be run against your newly created database to bring it in sync with your existing database. Alternatively, if you don't need the data from the existing database drop it and recreate it. Then run your dump against it, followed by the necessary alter table statements. I hope this helps... Pat... Patrick Sherrill CocoNet Corporation ----- Original Message ----- From: "Ronan Lucio" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 06, 2004 4:50 PM Subject: mysqldump > Hi All, > > I have another question: > I have a .sql file from a mysqldump did in a mysql-3.23.x > > Is there a way to restore it in a mysql-4.0.17? > > I´m trying to do it but the mysql return some errors like: > > ---------------- > # mysql -u root -p < ./dump-database.sql > Enter password: > ERROR 1050 at line 192370: Table 'columns_priv' already exists > ---------------- > > So I cut the lines from the sql file that tried to create the existent table > and executed the command again. > > I happened for some tables (columns_priv, db). Now mysql is returning > the follow error: > > ---------------- > # mysql -u root --password=littlesohh < ./dump-database-bh.txt > ERROR 1136 at line 7: Column count doesn't match value count at row 1 > ---------------- > > It is happening in the db table. OK, the table (db) struct is different from > the > 3.23 version, but, how is the better way to do it? > > Thanks, > Ronan > > > > -- > 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]
