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.
--
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
