Thanks Paul, I guess then all I need to do is remove the root entries at the
begining of the insert statement and then just insert the rest into 5.X since
the column names are there it should just import with no problems right?
Thanks again :-)
From: Paul DuBois <paul.dubois@stripped>
To: Nunzio Daveri <nunziodaveri@stripped>
Sent: Tue, August 3, 2010 12:09:05 AM
Subject: Re: Importing User credentials from mysql.sql file???
On Aug 2, 2010, at 3:57 PM, Nunzio Daveri wrote:
> Hello Gurus, I just upgraded several MySQL 4.1 to 5.1 versions and also wanted
> to know how to extract the user name, password and credentials from the
> mysql.sql file (around 22 of them per server - have 8 servers total)? The
> contract admin emailed me a sql file which is a dump of the default mysql
> database from the 4.1 version and I am trying to see if I can just grep out of
> the mysql.sql file the INSERT INTO... from the .sql file and import that into
> the 5.1.
> When I tried it on our test box it keeps on saying:
> ERROR 1136 - Column count doesn't match value count at row 2?
> Can someone please tell me how I can extract the data out of the 4.1 mysql.sql
> file and inject it into the 5.1 version please?
Ask the admin to re-dump the data, this time using mysqldump --complete-insert
so that the INSERT statements include the column names.
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA