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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org