Mysqldump

Hello,

I am trying to dump the text file contents to mysql which was already
backup from mysql only..While trying to dump it is telling access denied
error

i am trying from here

d:\mysql\bin>mysqldump databasename txt.file name

Can anyone tell me how to go about with this ??

Regards,
Uma


------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread9870@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@lists.mysql.com instead.

RE: mysqldump

> I have just exported a database with all data into a .sql=20
> file and want to recreate this database in my local machine=20
> =20
> How can i do that using just the mysql tools ?
> Mysqldump?
> How is it done with mysqldump?


Try this:

MYSQL.EXE -e "source %SystemDrive%\mysqlfile.sql" --force

-Kevin

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: mysqldump

> i try MYSQL.EXE -e "source \mysqlfile.sql" --force;

> as i have the sql filke in the same directory as=20
> the mysql.exe but it did not work saying i have=20
> an error in my sql sintax! what could it be?

> can i ommit %SystemDrive%?
> %SystemDrive% if c can be just c:?

Oops, sorry, I copy and pasted that and didn't see the env variable.

Try:
MYSQL.EXE -e "source mysqlfile.sql" --force

-Kevin

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: mysqldump

--0-1556282293-1084465080=:38713
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi i am almost there!

How can i specify wich database to use?

Bexcause it run but i get the error: no database selected assuming that i just enter in the dos in the \mysql\zbin directory and type your command.

"PF: MySQL" wrote:


> i try MYSQL.EXE -e "source \mysqlfile.sql" --force;

> as i have the sql filke in the same directory as
> the mysql.exe but it did not work saying i have
> an error in my sql sintax! what could it be?

> can i ommit %SystemDrive%?
> %SystemDrive% if c can be just c:?

Oops, sorry, I copy and pasted that and didn't see the env variable.

Try:
MYSQL.EXE -e "source mysqlfile.sql" --force

-Kevin

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=angelomrigo@yahoo.com.br



---------------------------------
Yahoo! Messenger - Fale com seus amigos online. Instale agora!
--0-1556282293-1084465080=:38713--

RE: mysqldump

just try the name of the database at the end like this:
MYSQL.EXE -e "source \mysqlfile.sql" --force database

Rodrigo
> -----Mensaje original-----
> De: Ângelo M. Rigo [mailto:angelomrigo@yahoo.com.br]
> Enviado el: Jueves, 13 de Mayo de 2004 11:18 a.m.
> Para: PF: MySQL; win32@lists.mysql.com
> Asunto: RE: mysqldump
>
>
> Hi i am almost there!
>
> How can i specify wich database to use?
>
> Bexcause it run but i get the error: no database selected
> assuming that i just enter in the dos in the \mysql\zbin
> directory and type your command.
>
> "PF: MySQL" wrote:
>
>
> > i try MYSQL.EXE -e "source \mysqlfile.sql" --force;
>
> > as i have the sql filke in the same directory as
> > the mysql.exe but it did not work saying i have
> > an error in my sql sintax! what could it be?
>
> > can i ommit %SystemDrive%?
> > %SystemDrive% if c can be just c:?
>
> Oops, sorry, I copy and pasted that and didn't see the env variable.
>
> Try:
> MYSQL.EXE -e "source mysqlfile.sql" --force
>
> -Kevin
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=angelomrigo@yahoo.com.br



---------------------------------
Yahoo! Messenger - Fale com seus amigos online. Instale agora!


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: mysqldump

--0-1704976381-1084466420=:90389
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Great it works
the only error message was that some tables do not exist i supose --force would create any table ? and -e option ?

How can i grant rigths to a specific user?

Thanks in advance

Rodrigo Haces wrote:
just try the name of the database at the end like this:
MYSQL.EXE -e "source \mysqlfile.sql" --force database

Rodrigo
> -----Mensaje original-----
> De: Ângelo M. Rigo [mailto:angelomrigo@yahoo.com.br]
> Enviado el: Jueves, 13 de Mayo de 2004 11:18 a.m.
> Para: PF: MySQL; win32@lists.mysql.com
> Asunto: RE: mysqldump
>
>
> Hi i am almost there!
>
> How can i specify wich database to use?
>
> Bexcause it run but i get the error: no database selected
> assuming that i just enter in the dos in the \mysql\zbin
> directory and type your command.
>
> "PF: MySQL" wrote:
>
>
> > i try MYSQL.EXE -e "source \mysqlfile.sql" --force;
>
> > as i have the sql filke in the same directory as
> > the mysql.exe but it did not work saying i have
> > an error in my sql sintax! what could it be?
>
> > can i ommit %SystemDrive%?
> > %SystemDrive% if c can be just c:?
>
> Oops, sorry, I copy and pasted that and didn't see the env variable.
>
> Try:
> MYSQL.EXE -e "source mysqlfile.sql" --force
>
> -Kevin
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=angelomrigo@yahoo.com.br



---------------------------------
Yahoo! Messenger - Fale com seus amigos online. Instale agora!


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=angelomrigo@yahoo.com.br



---------------------------------
Yahoo! Messenger - Fale com seus amigos online. Instale agora!
--0-1704976381-1084466420=:90389--

RE: mysqldump

> Great it works=20
> the only error message was that some tables do not exist i=20
> supose --force would create any table ? and -e option ?

The -e option executes a command (the stuff in quotes) and the --force
option continues even when errors occur.

You may need to add table defs to your SQL.

See here:

http://dev.mysql.com/doc/mysql/en/mysqldump.html


-Kevin

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: mysqldump

The -e option tells mysql that you are sending a command to be executed, the
command is "source \mysqlfile.sql" and the --force doesn't create any table,
it just continues if mysql sends an error, what i mean is if you send an
insert in a non existing table, without the --force the hole process will
stop, but with the --force it continues with the next command.

You shoudl create manually the tables that doesn't exist, mysql is not
capable of doing it because it doesn't know the name of the fields, the type
and anything else, maybe you could also export the create tables from the
original database.

Rodrigo

> -----Mensaje original-----
> De: Ângelo M. Rigo [mailto:angelomrigo@yahoo.com.br]
> Enviado el: Jueves, 13 de Mayo de 2004 11:40 a.m.
> Para: Rodrigo Haces; win32@lists.mysql.com
> Asunto: RE: mysqldump
>
>
> Great it works
> the only error message was that some tables do not exist i supose
> --force would create any table ? and -e option ?
>
> How can i grant rigths to a specific user?
>
> Thanks in advance
>
> Rodrigo Haces wrote:
> just try the name of the database at the end like this:
> MYSQL.EXE -e "source \mysqlfile.sql" --force database
>
> Rodrigo
> > -----Mensaje original-----
> > De: Ângelo M. Rigo [mailto:angelomrigo@yahoo.com.br]
> > Enviado el: Jueves, 13 de Mayo de 2004 11:18 a.m.
> > Para: PF: MySQL; win32@lists.mysql.com
> > Asunto: RE: mysqldump
> >
> >
> > Hi i am almost there!
> >
> > How can i specify wich database to use?
> >
> > Bexcause it run but i get the error: no database selected
> > assuming that i just enter in the dos in the \mysql\zbin
> > directory and type your command.
> >
> > "PF: MySQL" wrote:
> >
> >
> > > i try MYSQL.EXE -e "source \mysqlfile.sql" --force;
> >
> > > as i have the sql filke in the same directory as
> > > the mysql.exe but it did not work saying i have
> > > an error in my sql sintax! what could it be?
> >
> > > can i ommit %SystemDrive%?
> > > %SystemDrive% if c can be just c:?
> >
> > Oops, sorry, I copy and pasted that and didn't see the env variable.
> >
> > Try:
> > MYSQL.EXE -e "source mysqlfile.sql" --force
> >
> > -Kevin
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> http://lists.mysql.com/win32?unsub=angelomrigo@yahoo.com.br
>
>
>
> ---------------------------------
> Yahoo! Messenger - Fale com seus amigos online. Instale agora!
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=angelomrigo@yahoo.com.br



---------------------------------
Yahoo! Messenger - Fale com seus amigos online. Instale agora!


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: mysqldump

--0-462820119-1084468352=:99879
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Thank´s a lot

I am trying to create two tables where there will be a foreign key bettwen the two tables .

this can be done in mysql?
How mysql handle this feature?
the table type must be innodb? or myisam?

Thank´s in advance



"PF: MySQL" wrote:
> Great it works
> the only error message was that some tables do not exist i
> supose --force would create any table ? and -e option ?

The -e option executes a command (the stuff in quotes) and the --force
option continues even when errors occur.

You may need to add table defs to your SQL.

See here:

http://dev.mysql.com/doc/mysql/en/mysqldump.html


-Kevin

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=angelomrigo@yahoo.com.br



---------------------------------
Yahoo! Messenger - Fale com seus amigos online. Instale agora!
--0-462820119-1084468352=:99879--

Re: mysqldump

angelo,

you can use mysql command tool to import the data. at the command prompt w=
rite:

mysql -u xyz -p db1 < dump.sql


thats all. where xyz is the username db1 is the name of your database and =
dump.sql is the name of the file that you exported.

make sure that the database exists before you try to import data. also, if=
you did not use the parameter --add-drop-table during export. drop the ol=
d tables manually before you start the import. otherwise, if the tables al=
ready exist in the database, the tables ill not be re-created.

regards,

uwe



"=C2ngelo M. Rigo" schrieb am 13.05.04 15:53:51:
>=20
> Hi=20
> I have just exported a database with all data into a .sql file and want =
to recreate this database in my local machine=20
> =20
> How can i do that using just the mysql tools =3F
> Mysqldump=3F
> How is it done with mysqldump=3F
> =20
> Than=B4k=B4s in advance
>=20
>=20
>=20
> ---------------------------------
> Yahoo! Messenger - Fale com seus amigos online. Instale agora!


____________________ ____________________ ____________________ __________=5F
.... and the winner is... WEB.DE FreeMail! - Deutschlands beste E-Mail
ist zum 39. Mal Testsieger (PC Praxis 03/04) http://f.web.de/=3Fmc=3D021191


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: mysqldump

mysqldump is an external tool.
I assume, you started it within the cmd-line client, which serves for =
nothing more (and nothing less) than sending sql-queries to the server =
and receiving back results.

simply start it from the shell /nt-cmd-line.

regards,
armin.

> -----Original Message-----
> From: Chris Barthel [mailto:cwbarthel@yahoo.com]=20
> Sent: Wednesday, June 02, 2004 8:13 PM
> To: Win32 MySQL
> Subject: mysqldump
>=20
> I am trying to do a mysqldump on my entire db and it keeps=20
> telling me I have an error in my syntax. I have tried=20
> everything I can think of....
> =20
> mysqldump db_name > file.sql;
> mysqldump db_name --all-databases > file.sql; mysqldump=20
> db_name db_table > file.sql;
> =20
> Any ideas?
>=20
> =09
> ---------------------------------
> Do you Yahoo!?
> Friends. Fun. Try the all-new Yahoo! Messenger
>=20

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: MySQLDump

Both.... Windows, Yes.


----- Original Message -----
From: "Peet Smit [NuBtech]"
To: "Melissa Dougherty"
Sent: Thursday, September 07, 2006 12:47 PM
Subject: RE: MySQLDump


> Hi Melissa,
>
> The data export, it is for back-up purposes or to import the data
> into another application? Running under windows?
>
> Regards
> Peet
>
>
> -----Original Message-----
> From: Melissa Dougherty [mailto:melissa@cse-corp.com]
> Sent: 07 September 2006 06:38 PM
> To: win32@lists.mysql.com
> Subject: MySQLDump
>
>
> Does anyone use MySQLdump to export data from their db? I'm having an
> issue
> dumping a table that's about 320M. I get connection lost errors and have
> never successfully dumped the table.
>
> My goal was to have an another method of recovery if there was data
> failure.... do you user/developer error. I'm an Oracle DBA and was trying
> to find something like the Oracle export.
>
> Any suggestions?
>
>
> Melissa
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: MySQLDump

--------------enig70525BA549C2560C457D6083
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

> Subject: MySQLDump
> From: "Melissa Dougherty"=20
> Date: Thu, 7 Sep 2006 12:37:46 -0400
>=20
> Does anyone use MySQLdump to export data from their db? I'm having an =
issue dumping a table that's about 320M. I get connection lost errors an=
d have never successfully dumped the table.
>=20
> My goal was to have an another method of recovery if there was data fai=
lure.... do you user/developer error. I'm an Oracle DBA and was trying t=
o find something like the Oracle export.
>=20
> Any suggestions?
>=20
>=20
> Melissa=20

I use mysqldump to export data but not with that size. I don't know if
there is a limitation to the size mysqldump can export. You could check
the documentation.


Here's my command.
$mysqldump -u user test > test.sql -p


try mysqldump with no other users connecting to the database. if it
succeeds, probably locking issues.

you could also try mysqldump from the localhost. if it succeeds,
probably network congestion or others.


--------------enig70525BA549C2560C457D6083
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key: https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key: http://www.lorztech.com/GPG.txt
Comment: Google, Skype, Yahoo ID: michaellouieloria

iQEVAwUBRQdk4LXBHi2y3jwfAQo2OAf8DoW+YyxFh6pXRaNpNJZL/AS/L35M /Z6E
CUk3iclUIUOrQ6UJ1oo0ojhbJ2iTzJcJ49Xz9GX4X0Oe8dTzC/prbT7p/yJz xxSw
ZSd37RXmMN8zT8c9xEvbMgFdspxeVYx41tEKIDfOs8C4Z4IHdQdSRCa5coCe EpBo
F0YDg9m1nJ8NK4yuVsNNH0qQLT901T7Gr99pqBMF32Mo+Ix3lDzbqWUcLgKz JpBX
zKN/N1Fv7wMuzlffi1tAXL9oEcc0dVobcA241Kn3XJ0ihPqi5Ci+SSoiAy3L p8Q2
oJiIVfXHRDYy1yeeB0a6BINLeDlUf39sLSV1hpl1Dkx6Xa6fp38nQw==
=XbiT
-----END PGP SIGNATURE-----

--------------enig70525BA549C2560C457D6083--

RE: MySQLDump

Hi Melissa,

Could you tell me, what is the meaning of the "- p" switch at the end of
your command?

I am dumping tables larger than 320MB. I have a range of tables up to
613MB and I am able to dump them, only difference I can see is that we
are in Unix you seems to be running Windows.

Best,

Mikhail Berman

-----Original Message-----
From: Michael Louie Loria [mailto:mlloria@lorztech.com]=20
Sent: Tuesday, September 12, 2006 9:55 PM
To: win32@lists.mysql.com
Subject: Re: MySQLDump

> Subject: MySQLDump
> From: "Melissa Dougherty"=20
> Date: Thu, 7 Sep 2006 12:37:46 -0400
>=20
> Does anyone use MySQLdump to export data from their db? I'm having an
issue dumping a table that's about 320M. I get connection lost errors
and have never successfully dumped the table.
>=20
> My goal was to have an another method of recovery if there was data
failure.... do you user/developer error. I'm an Oracle DBA and was
trying to find something like the Oracle export.
>=20
> Any suggestions?
>=20
>=20
> Melissa

I use mysqldump to export data but not with that size. I don't know if
there is a limitation to the size mysqldump can export. You could check
the documentation.


Here's my command.
$mysqldump -u user test > test.sql -p


try mysqldump with no other users connecting to the database. if it
succeeds, probably locking issues.

you could also try mysqldump from the localhost. if it succeeds,
probably network congestion or others.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: MySQLDump

The -p switch is for the password.


----- Original Message -----
From: "Mikhail Berman"
To: "Michael Louie Loria" ;
Sent: Wednesday, September 13, 2006 9:42 AM
Subject: RE: MySQLDump


Hi Melissa,

Could you tell me, what is the meaning of the "- p" switch at the end of
your command?

I am dumping tables larger than 320MB. I have a range of tables up to
613MB and I am able to dump them, only difference I can see is that we
are in Unix you seems to be running Windows.

Best,

Mikhail Berman

-----Original Message-----
From: Michael Louie Loria [mailto:mlloria@lorztech.com]
Sent: Tuesday, September 12, 2006 9:55 PM
To: win32@lists.mysql.com
Subject: Re: MySQLDump

> Subject: MySQLDump
> From: "Melissa Dougherty"
> Date: Thu, 7 Sep 2006 12:37:46 -0400
>
> Does anyone use MySQLdump to export data from their db? I'm having an
issue dumping a table that's about 320M. I get connection lost errors
and have never successfully dumped the table.
>
> My goal was to have an another method of recovery if there was data
failure.... do you user/developer error. I'm an Oracle DBA and was
trying to find something like the Oracle export.
>
> Any suggestions?
>
>
> Melissa

I use mysqldump to export data but not with that size. I don't know if
there is a limitation to the size mysqldump can export. You could check
the documentation.


Here's my command.
$mysqldump -u user test > test.sql -p


try mysqldump with no other users connecting to the database. if it
succeeds, probably locking issues.

you could also try mysqldump from the localhost. if it succeeds,
probably network congestion or others.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=melissa@cse-corp.com



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: MySQLDump

Well,

I would think that would be the problem.

The proper command would be

$mysqldump -u user -pyourpwd test > test.sql, where

"-u user" is you user name
"-pyoupwd" is you password. This is not a mistake MySQL requires when
one use "-p" not "--password" to have password entered in the format
presented, meaning no spaces between "-p" and actual password.
"test" - would be a database name


Mikhail Berman

-----Original Message-----
From: Melissa Dougherty [mailto:melissa@cse-corp.com]=20
Sent: Wednesday, September 13, 2006 10:55 AM
To: Mikhail Berman; Michael Louie Loria; win32@lists.mysql.com
Subject: Re: MySQLDump

The -p switch is for the password. =20


----- Original Message -----
From: "Mikhail Berman"
To: "Michael Louie Loria" ;

Sent: Wednesday, September 13, 2006 9:42 AM
Subject: RE: MySQLDump


Hi Melissa,

Could you tell me, what is the meaning of the "- p" switch at the end of
your command?

I am dumping tables larger than 320MB. I have a range of tables up to
613MB and I am able to dump them, only difference I can see is that we
are in Unix you seems to be running Windows.

Best,

Mikhail Berman

-----Original Message-----
From: Michael Louie Loria [mailto:mlloria@lorztech.com]=20
Sent: Tuesday, September 12, 2006 9:55 PM
To: win32@lists.mysql.com
Subject: Re: MySQLDump

> Subject: MySQLDump
> From: "Melissa Dougherty"=20
> Date: Thu, 7 Sep 2006 12:37:46 -0400
>=20
> Does anyone use MySQLdump to export data from their db? I'm having an
issue dumping a table that's about 320M. I get connection lost errors
and have never successfully dumped the table.
>=20
> My goal was to have an another method of recovery if there was data
failure.... do you user/developer error. I'm an Oracle DBA and was
trying to find something like the Oracle export.
>=20
> Any suggestions?
>=20
>=20
> Melissa

I use mysqldump to export data but not with that size. I don't know if
there is a limitation to the size mysqldump can export. You could check
the documentation.


Here's my command.
$mysqldump -u user test > test.sql -p


try mysqldump with no other users connecting to the database. if it
succeeds, probably locking issues.

you could also try mysqldump from the localhost. if it succeeds,
probably network congestion or others.


--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=3Dmelissa@cse-corp.com



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: MySQLDump

My script is setup that way.... Here is what's in my script.

mysqldump --opt --all-databases --flush-logs --verbose -u
root -psapwd --result-file=c:\dump.sql

All tables dump successfully except the table with the longtext column.

Melissa


----- Original Message -----
From: "Mikhail Berman"
To: "Melissa Dougherty" ; "Michael Louie Loria"
;
Sent: Wednesday, September 13, 2006 11:05 AM
Subject: RE: MySQLDump


Well,

I would think that would be the problem.

The proper command would be

$mysqldump -u user -pyourpwd test > test.sql, where

"-u user" is you user name
"-pyoupwd" is you password. This is not a mistake MySQL requires when
one use "-p" not "--password" to have password entered in the format
presented, meaning no spaces between "-p" and actual password.
"test" - would be a database name


Mikhail Berman

-----Original Message-----
From: Melissa Dougherty [mailto:melissa@cse-corp.com]
Sent: Wednesday, September 13, 2006 10:55 AM
To: Mikhail Berman; Michael Louie Loria; win32@lists.mysql.com
Subject: Re: MySQLDump

The -p switch is for the password.


----- Original Message -----
From: "Mikhail Berman"
To: "Michael Louie Loria" ;

Sent: Wednesday, September 13, 2006 9:42 AM
Subject: RE: MySQLDump


Hi Melissa,

Could you tell me, what is the meaning of the "- p" switch at the end of
your command?

I am dumping tables larger than 320MB. I have a range of tables up to
613MB and I am able to dump them, only difference I can see is that we
are in Unix you seems to be running Windows.

Best,

Mikhail Berman

-----Original Message-----
From: Michael Louie Loria [mailto:mlloria@lorztech.com]
Sent: Tuesday, September 12, 2006 9:55 PM
To: win32@lists.mysql.com
Subject: Re: MySQLDump

> Subject: MySQLDump
> From: "Melissa Dougherty"
> Date: Thu, 7 Sep 2006 12:37:46 -0400
>
> Does anyone use MySQLdump to export data from their db? I'm having an
issue dumping a table that's about 320M. I get connection lost errors
and have never successfully dumped the table.
>
> My goal was to have an another method of recovery if there was data
failure.... do you user/developer error. I'm an Oracle DBA and was
trying to find something like the Oracle export.
>
> Any suggestions?
>
>
> Melissa

I use mysqldump to export data but not with that size. I don't know if
there is a limitation to the size mysqldump can export. You could check
the documentation.


Here's my command.
$mysqldump -u user test > test.sql -p


try mysqldump with no other users connecting to the database. if it
succeeds, probably locking issues.

you could also try mysqldump from the localhost. if it succeeds,
probably network congestion or others.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=melissa@cse-corp.com




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: MySQLDump

Just a thought...I've had problems in the past while dumping tables =
with
large content. I also had that same error "Lost connection to MySQL =
server
during query...". The problem was that the max_allowed_packet variable
wasn't large enough and we had blob columns with 2 or 3 MB of data. The
solution was to increase the value of this variable in the my.cnf file =
or
using the SET command to set the new value on the fly. Maybe this has
nothing to do with your problem but it wouldn't hurt to check it out.

Good luck!

Paulo Urcid Pliego
E-Labor Producci=F3n DM e IM
Preserie y Construcci=F3n de Equipos
=20
Volkswagen de M=E9xico S.A. de C.V.
Tel=E9fono +52 (222) 2 30 9961
Fax +52 (222) 2 30 6082
mailto:urcid@vw.com.mx
http://www.vw.com.mx
-----Mensaje original-----
De: Jorge Bastos [mailto:mysql.jorge@decimal.pt]=20
Enviado el: Mi=E9rcoles, 13 de Septiembre de 2006 04:22 p.m.
Para: win32@lists.mysql.com
Asunto: Fw: MySQLDump

hum, theres no info about that error :(

server:~# perror 2013
Illegal error code: 2013




----- Original Message -----=20
From: "Melissa Dougherty"
To: "Jorge Bastos" ;
Sent: Wednesday, September 13, 2006 7:47 PM
Subject: Re: MySQLDump


> mysqldump: Error 2013: Lost connection to MySQL server during query =
when=20
> dumping table `content_resource_body_binary` at row: 18
>
>
> ----- Original Message -----=20
> From: "Jorge Bastos"
> To:
> Sent: Wednesday, September 13, 2006 1:20 PM
> Subject: Fw: MySQLDump
>
>
>> what's the error number?
>> with that we can see what's the problem, if that number os listed
>>
>>
>>
>> ----- Original Message -----=20
>> From: "Melissa Dougherty"
>> To: "Mikhail Berman" ; "Michael Louie Loria"=20
>> ;
>> Sent: Wednesday, September 13, 2006 6:21 PM
>> Subject: Re: MySQLDump
>>
>>
>>> My script is setup that way.... Here is what's in my script.
>>>
>>> mysqldump --opt --all-databases --flush-logs --verbose -u=20
>>> root -psapwd --result-file=3Dc:\dump.sql
>>>
>>> All tables dump successfully except the table with the longtext =
column.
>>>
>>> Melissa
>>>
>>>
>>> ----- Original Message -----=20
>>> From: "Mikhail Berman"
>>> To: "Melissa Dougherty" ; "Michael Louie =
Loria"=20
>>> ;
>>> Sent: Wednesday, September 13, 2006 11:05 AM
>>> Subject: RE: MySQLDump
>>>
>>>
>>> Well,
>>>
>>> I would think that would be the problem.
>>>
>>> The proper command would be
>>>
>>> $mysqldump -u user -pyourpwd test > test.sql, where
>>>
>>> "-u user" is you user name
>>> "-pyoupwd" is you password. This is not a mistake MySQL requires =
when
>>> one use "-p" not "--password" to have password entered in the =
format
>>> presented, meaning no spaces between "-p" and actual password.
>>> "test" - would be a database name
>>>
>>>
>>> Mikhail Berman
>>>
>>> -----Original Message-----
>>> From: Melissa Dougherty [mailto:melissa@cse-corp.com]
>>> Sent: Wednesday, September 13, 2006 10:55 AM
>>> To: Mikhail Berman; Michael Louie Loria; win32@lists.mysql.com
>>> Subject: Re: MySQLDump
>>>
>>> The -p switch is for the password.
>>>
>>>
>>> ----- Original Message -----
>>> From: "Mikhail Berman"
>>> To: "Michael Louie Loria" ;
>>>
>>> Sent: Wednesday, September 13, 2006 9:42 AM
>>> Subject: RE: MySQLDump
>>>
>>>
>>> Hi Melissa,
>>>
>>> Could you tell me, what is the meaning of the "- p" switch at the =
end of
>>> your command?
>>>
>>> I am dumping tables larger than 320MB. I have a range of tables up =
to
>>> 613MB and I am able to dump them, only difference I can see is that =
we
>>> are in Unix you seems to be running Windows.
>>>
>>> Best,
>>>
>>> Mikhail Berman
>>>
>>> -----Original Message-----
>>> From: Michael Louie Loria [mailto:mlloria@lorztech.com]
>>> Sent: Tuesday, September 12, 2006 9:55 PM
>>> To: win32@lists.mysql.com
>>> Subject: Re: MySQLDump
>>>
>>>> Subject: MySQLDump
>>>> From: "Melissa Dougherty"
>>>> Date: Thu, 7 Sep 2006 12:37:46 -0400
>>>>
>>>> Does anyone use MySQLdump to export data from their db? I'm =
having an
>>> issue dumping a table that's about 320M. I get connection lost =
errors
>>> and have never successfully dumped the table.
>>>>
>>>> My goal was to have an another method of recovery if there was =
data
>>> failure.... do you user/developer error. I'm an Oracle DBA and was
>>> trying to find something like the Oracle export.
>>>>
>>>> Any suggestions?
>>>>
>>>>
>>>> Melissa
>>>
>>> I use mysqldump to export data but not with that size. I don't know =
if
>>> there is a limitation to the size mysqldump can export. You could =
check
>>> the documentation.
>>>
>>>
>>> Here's my command.
>>> $mysqldump -u user test > test.sql -p
>>>
>>>
>>> try mysqldump with no other users connecting to the database. if it
>>> succeeds, probably locking issues.
>>>
>>> you could also try mysqldump from the localhost. if it succeeds,
>>> probably network congestion or others.
>>>
>>>
>>> --=20
>>> MySQL Windows Mailing List
>>> For list archives: http://lists.mysql.com/win32
>>> To unsubscribe:
>>> http://lists.mysql.com/win32?unsub=3Dmelissa@cse-corp.com
>>>
>>>
>>>
>>>
>>> --=20
>>> MySQL Windows Mailing List
>>> For list archives: http://lists.mysql.com/win32
>>> To unsubscribe:=20
>>> http://lists.mysql.com/win32?unsub=3Dmysql.jorge@decimal.pt
>>>
>>>
>>
>>
>> --=20
>> MySQL Windows Mailing List
>> For list archives: http://lists.mysql.com/win32
>> To unsubscribe:=20
>> http://lists.mysql.com/win32?unsub=3Dmelissa@cse-corp.com
>>
>>
>
>
> --=20
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:=20
> http://lists.mysql.com/win32?unsub=3Dmysql.jorge@decimal.pt
>
>=20


--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Durcid@vw.com.mx

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: MySQLDump

--------------enig6C1946CEFE474F3B5C7DF99D
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Melissa Dougherty wrote:
> My script is setup that way.... Here is what's in my script.
>=20
> mysqldump --opt --all-databases --flush-logs --verbose -u root -psapwd
> --result-file=3Dc:\dump.sql
>=20
> All tables dump successfully except the table with the longtext column.=

>=20
> Melissa

Try changing the longtext to mediumtext, then dump.

Try also isolating the database because you are dumping all the
databases (--all-databases). Upon isolation, try dumping with different
queries like dumping a single row from the table.

$mysqldump -u root -p "--where=3D(your own query)" name_of_database
name_of_table > name_of_dumpfile.sql


--------------enig6C1946CEFE474F3B5C7DF99D
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key: https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key: http://www.lorztech.com/GPG.txt
Comment: Google, Skype, Yahoo ID: michaellouieloria

iQEVAwUBRQimVLXBHi2y3jwfAQpIOAf8CoJ/rQmDdHRf4xRD1eyMhFH1Sfr3 SIFN
pDRObeX8nJRaBTLJunE0ocR6XHmKHv9RHUwisSwKMc6okCQp5jfyWEEe4fX9 s3hN
I0+n4pyeGR+mhnQf8+idDAlH5Xk3bRKCIH5kiM64QcxdFQAe6af/XfzNIqwB Siv5
U1pmNifKmnDysLwgSanEtfVMxBB89ZofjxNGE1FlI7xk8S0y4jiDClgkuNcY Hpzz
UZRgd7DAhhNUle2yRzIzKc6uQHlRl1wI7u5n2ojdX7x/W3hObzO1CsGEiC2r iSKu
drXVcoVGBpJTpRj2IcsUScxSOvrNmr1GIpAKOd/SfmgYL+EhhARYXA==
=Y/5+
-----END PGP SIGNATURE-----

--------------enig6C1946CEFE474F3B5C7DF99D--

Re: MySQLDump

I increased the max_allowed_packet variable to 72m from 64m and also upped
the connect_timeout. But the dump still error the same way.

Melissa
----- Original Message -----
From: "Urcid Pliego, Paulo"
To:
Sent: Wednesday, September 13, 2006 5:40 PM
Subject: RE: MySQLDump


Just a thought...I've had problems in the past while dumping tables with
large content. I also had that same error "Lost connection to MySQL server
during query...". The problem was that the max_allowed_packet variable
wasn't large enough and we had blob columns with 2 or 3 MB of data. The
solution was to increase the value of this variable in the my.cnf file or
using the SET command to set the new value on the fly. Maybe this has
nothing to do with your problem but it wouldn't hurt to check it out.

Good luck!

Paulo Urcid Pliego
E-Labor Producción DM e IM
Preserie y Construcción de Equipos

Volkswagen de México S.A. de C.V.
Teléfono +52 (222) 2 30 9961
Fax +52 (222) 2 30 6082
mailto:urcid@vw.com.mx
http://www.vw.com.mx
-----Mensaje original-----
De: Jorge Bastos [mailto:mysql.jorge@decimal.pt]
Enviado el: Miércoles, 13 de Septiembre de 2006 04:22 p.m.
Para: win32@lists.mysql.com
Asunto: Fw: MySQLDump

hum, theres no info about that error :(

server:~# perror 2013
Illegal error code: 2013




----- Original Message -----
From: "Melissa Dougherty"
To: "Jorge Bastos" ;
Sent: Wednesday, September 13, 2006 7:47 PM
Subject: Re: MySQLDump


> mysqldump: Error 2013: Lost connection to MySQL server during query when
> dumping table `content_resource_body_binary` at row: 18
>
>
> ----- Original Message -----
> From: "Jorge Bastos"
> To:
> Sent: Wednesday, September 13, 2006 1:20 PM
> Subject: Fw: MySQLDump
>
>
>> what's the error number?
>> with that we can see what's the problem, if that number os listed
>>
>>
>>
>> ----- Original Message -----
>> From: "Melissa Dougherty"
>> To: "Mikhail Berman" ; "Michael Louie Loria"
>> ;
>> Sent: Wednesday, September 13, 2006 6:21 PM
>> Subject: Re: MySQLDump
>>
>>
>>> My script is setup that way.... Here is what's in my script.
>>>
>>> mysqldump --opt --all-databases --flush-logs --verbose -u
>>> root -psapwd --result-file=c:\dump.sql
>>>
>>> All tables dump successfully except the table with the longtext column.
>>>
>>> Melissa
>>>
>>>
>>> ----- Original Message -----
>>> From: "Mikhail Berman"
>>> To: "Melissa Dougherty" ; "Michael Louie Loria"
>>> ;
>>> Sent: Wednesday, September 13, 2006 11:05 AM
>>> Subject: RE: MySQLDump
>>>
>>>
>>> Well,
>>>
>>> I would think that would be the problem.
>>>
>>> The proper command would be
>>>
>>> $mysqldump -u user -pyourpwd test > test.sql, where
>>>
>>> "-u user" is you user name
>>> "-pyoupwd" is you password. This is not a mistake MySQL requires when
>>> one use "-p" not "--password" to have password entered in the format
>>> presented, meaning no spaces between "-p" and actual password.
>>> "test" - would be a database name
>>>
>>>
>>> Mikhail Berman
>>>
>>> -----Original Message-----
>>> From: Melissa Dougherty [mailto:melissa@cse-corp.com]
>>> Sent: Wednesday, September 13, 2006 10:55 AM
>>> To: Mikhail Berman; Michael Louie Loria; win32@lists.mysql.com
>>> Subject: Re: MySQLDump
>>>
>>> The -p switch is for the password.
>>>
>>>
>>> ----- Original Message -----
>>> From: "Mikhail Berman"
>>> To: "Michael Louie Loria" ;
>>>
>>> Sent: Wednesday, September 13, 2006 9:42 AM
>>> Subject: RE: MySQLDump
>>>
>>>
>>> Hi Melissa,
>>>
>>> Could you tell me, what is the meaning of the "- p" switch at the end of
>>> your command?
>>>
>>> I am dumping tables larger than 320MB. I have a range of tables up to
>>> 613MB and I am able to dump them, only difference I can see is that we
>>> are in Unix you seems to be running Windows.
>>>
>>> Best,
>>>
>>> Mikhail Berman
>>>
>>> -----Original Message-----
>>> From: Michael Louie Loria [mailto:mlloria@lorztech.com]
>>> Sent: Tuesday, September 12, 2006 9:55 PM
>>> To: win32@lists.mysql.com
>>> Subject: Re: MySQLDump
>>>
>>>> Subject: MySQLDump
>>>> From: "Melissa Dougherty"
>>>> Date: Thu, 7 Sep 2006 12:37:46 -0400
>>>>
>>>> Does anyone use MySQLdump to export data from their db? I'm having an
>>> issue dumping a table that's about 320M. I get connection lost errors
>>> and have never successfully dumped the table.
>>>>
>>>> My goal was to have an another method of recovery if there was data
>>> failure.... do you user/developer error. I'm an Oracle DBA and was
>>> trying to find something like the Oracle export.
>>>>
>>>> Any suggestions?
>>>>
>>>>
>>>> Melissa
>>>
>>> I use mysqldump to export data but not with that size. I don't know if
>>> there is a limitation to the size mysqldump can export. You could check
>>> the documentation.
>>>
>>>
>>> Here's my command.
>>> $mysqldump -u user test > test.sql -p
>>>
>>>
>>> try mysqldump with no other users connecting to the database. if it
>>> succeeds, probably locking issues.
>>>
>>> you could also try mysqldump from the localhost. if it succeeds,
>>> probably network congestion or others.
>>>
>>>
>>> --
>>> MySQL Windows Mailing List
>>> For list archives: http://lists.mysql.com/win32
>>> To unsubscribe:
>>> http://lists.mysql.com/win32?unsub=melissa@cse-corp.com
>>>
>>>
>>>
>>>
>>> --
>>> MySQL Windows Mailing List
>>> For list archives: http://lists.mysql.com/win32
>>> To unsubscribe:
>>> http://lists.mysql.com/win32?unsub=mysql.jorge@decimal.pt
>>>
>>>
>>
>>
>> --
>> MySQL Windows Mailing List
>> For list archives: http://lists.mysql.com/win32
>> To unsubscribe:
>> http://lists.mysql.com/win32?unsub=melissa@cse-corp.com
>>
>>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=mysql.jorge@decimal.pt
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=urcid@vw.com.mx

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=melissa@cse-corp.com



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: MySQLDump

> I increased the max_allowed_packet variable to 72m from 64m and also
upped
> the connect_timeout. But the dump still error the same way.
>
> Melissa

The manual says:

The protocol limits for max_allowed_packet is 16M in MySQL 3.23 and
1G in MySQL 4.0.

Perhaps I've not been following this thread closely enough, but why not
make it a gigabyte, just as a test??

-- David



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: MySQLDump

I increased the limit to 1gb... but got the same error. Do you think if I
turned on the general query log it would give anymore info?

Melissa
----- Original Message -----
From:
To: "Melissa Dougherty"
Cc:
Sent: Thursday, September 14, 2006 2:57 PM
Subject: Re: MySQLDump


>
>> I increased the max_allowed_packet variable to 72m from 64m and also
> upped
>> the connect_timeout. But the dump still error the same way.
>>
>> Melissa
>
> The manual says:
>
> The protocol limits for max_allowed_packet is 16M in MySQL 3.23 and
> 1G in MySQL 4.0.
>
> Perhaps I've not been following this thread closely enough, but why not
> make it a gigabyte, just as a test??
>
> -- David
>
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: MySQLDump

>>> I increased the max_allowed_packet variable to 72m from 64m and also
>> upped
>>> the connect_timeout. But the dump still error the same way.
>>>
>>> Melissa
>>
>> The manual says:
>>
>> The protocol limits for max_allowed_packet is 16M in MySQL 3.23 and
>> 1G in MySQL 4.0.
>>
>> Perhaps I've not been following this thread closely enough, but why not
>> make it a gigabyte, just as a test??
>>
>> -- David.
> I increased the limit to 1gb... but got the same error. Do you think if
I
> turned on the general query log it would give anymore info?

> Melissa

Couldn't hurt - give it a try.

-- David.



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: MySQLDump

In my.cnf there are two sections where max_allowed_packet value can be
set.

One in [mysql] and one in [mysqldump]

Please check where you setting your value, you need [mysqldump] section.

Hoping this helps

Mikhail Berman

-----Original Message-----
From: Melissa Dougherty [mailto:melissa@cse-corp.com]=20
Sent: Thursday, September 14, 2006 3:48 PM
To: dpgirago@mdanderson.org
Cc: win32@lists.mysql.com
Subject: Re: MySQLDump

I increased the limit to 1gb... but got the same error. Do you think if
I turned on the general query log it would give anymore info?

Melissa
----- Original Message -----
From:
To: "Melissa Dougherty"
Cc:
Sent: Thursday, September 14, 2006 2:57 PM
Subject: Re: MySQLDump


>
>> I increased the max_allowed_packet variable to 72m from 64m and also
> upped
>> the connect_timeout. But the dump still error the same way.
>>
>> Melissa
>
> The manual says:
>
> The protocol limits for max_allowed_packet is 16M in MySQL 3.23
and
> 1G in MySQL 4.0.
>
> Perhaps I've not been following this thread closely enough, but why
not
> make it a gigabyte, just as a test??
>
> -- David
>
>
>=20


--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=3Dmberman@ivesinc.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: MySQLDump

I put it in both....


----- Original Message -----
From: "Mikhail Berman"
To: "Melissa Dougherty" ;
Cc:
Sent: Thursday, September 14, 2006 4:09 PM
Subject: RE: MySQLDump


In my.cnf there are two sections where max_allowed_packet value can be
set.

One in [mysql] and one in [mysqldump]

Please check where you setting your value, you need [mysqldump] section.

Hoping this helps

Mikhail Berman

-----Original Message-----
From: Melissa Dougherty [mailto:melissa@cse-corp.com]
Sent: Thursday, September 14, 2006 3:48 PM
To: dpgirago@mdanderson.org
Cc: win32@lists.mysql.com
Subject: Re: MySQLDump

I increased the limit to 1gb... but got the same error. Do you think if
I turned on the general query log it would give anymore info?

Melissa
----- Original Message -----
From:
To: "Melissa Dougherty"
Cc:
Sent: Thursday, September 14, 2006 2:57 PM
Subject: Re: MySQLDump


>
>> I increased the max_allowed_packet variable to 72m from 64m and also
> upped
>> the connect_timeout. But the dump still error the same way.
>>
>> Melissa
>
> The manual says:
>
> The protocol limits for max_allowed_packet is 16M in MySQL 3.23
and
> 1G in MySQL 4.0.
>
> Perhaps I've not been following this thread closely enough, but why
not
> make it a gigabyte, just as a test??
>
> -- David
>
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=mberman@ivesinc.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=melissa@cse-corp.com



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: MySQLDump

I enabled the general query log and nothing was captured when running the
MySQLDump command.... I'm at a loss to the issue. Below is the output from
SHOW TABLE STATUS...

'content_resource_body_binary', 'InnoDB', 'Dynamic', 1053, 368958,
388513792, , 0, 0, , '', '', '', '', 'InnoDB free: 15360 kB'

Melissa


----- Original Message -----
From:
To: "Melissa Dougherty"
Sent: Friday, September 15, 2006 9:50 AM
Subject: Re: MySQLDump


>
> Melissa,
>
> Did you enable general logging? Anything in there?
>
>
> David P. Giragosian, Psy.D.
> Database and Software Developer
> MD Anderson Cancer Center
> Houston, TX
> 713-792-7898
>
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org