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?
Thanks in advance...
Nunzio
