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]
