Importing User credentials from mysql.sql file???

--0-879457619-1280782641=:97555
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hello Gurus, I just upgraded several MySQL 4.1 to 5.1 versions and also wan=
ted =0Ato know how to extract the user name, password and credentials from =
the =0Amysql.sql file (around 22 of them per server - have 8 servers total)=
?=A0 The =0Acontract admin emailed me a sql file which is a dump of the def=
ault mysql =0Adatabase from the 4.1 version and I am trying to see if I can=
just grep out of =0Athe mysql.sql file the=A0INSERT INTO... from the .sql =
file and import that into =0Athe 5.1. When I tried it on our test box =
it keeps on saying: ERROR 1136 - Column count doesn't match value coun=
t at row 2? Can someone please tell me how I can extract the data out =
of the 4.1 mysql.sql =0Afile and inject it into the 5.1 version please?=0A=
=0AThanks in advance... Nunzio =0A
--0-879457619-1280782641=:97555--

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=20
> to know how to extract the user name, password and credentials from =
the=20
> mysql.sql file (around 22 of them per server - have 8 servers total)? =
The=20
> contract admin emailed me a sql file which is a dump of the default =
mysql=20
> database from the 4.1 version and I am trying to see if I can just =
grep out of=20
> the mysql.sql file the INSERT INTO... from the .sql file and import =
that into=20
> the 5.1.
>=20
> When I tried it on our test box it keeps on saying:
>=20
> ERROR 1136 - Column count doesn't match value count at row 2?
>=20
> Can someone please tell me how I can extract the data out of the 4.1 =
mysql.sql=20
> 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.

--=20
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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Importing User credentials from mysql.sql file???

--0-2031289798-1280854167=:23086
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Thanks Paul, I guess then all I need to do is remove the root entries at th=
e =0Abegining of the insert statement and then just insert the rest into 5.=
X since =0Athe column names are there it should just import with no problem=
s right? Thanks again :-) Nunzio =0A__________________=
______________=0AFrom: Paul DuBois =0ATo: Nunzio Da=
veri =0ACc: mysql@lists.mysql.com=0ASent: Tue, Augu=
st 3, 2010 12:09:05 AM=0ASubject: Re: Importing User credentials from mysql=
..sql file??? =0AOn 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 w=
anted > to know how to extract the user name, password and credential=
s from the =0A> mysql.sql file (around 22 of them per server - have 8 serve=
rs total)?=A0 The =0A> contract admin emailed me a sql file which is a dump=
of the default mysql =0A> 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 =0A> the 5.1.=0A> =0A> When I tri=
ed it on our test box it keeps on saying:=0A> =0A> ERROR 1136 - Column coun=
t doesn't match value count at row 2?=0A> =0A> Can someone please tell me h=
ow 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, thi=
s time using mysqldump --complete-insert=0Aso that the INSERT statements in=
clude the column names. -- =0APaul DuBois=0AOracle Corporation / MySQL=
Documentation Team=0AMadison, Wisconsin, USA=0Awww.mysql.com =0A =

--0-2031289798-1280854167=:23086--