Re: MySQLDump

Michael Louie Loria <[email protected]> Wed, 13 Sep 2006 17:46:12 -0700

Newsgroups	gmane.comp.db.mysql.windows
Message-ID	<[email protected]>

Melissa Dougherty wrote:
> 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

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=(your own query)" name_of_database
name_of_table > name_of_dumpfile.sql

signature.asc (application/pgp-signature, 627 B)

-----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/rQmDdHRf4xRD1eyMhFH1Sfr3SIFN
pDRObeX8nJRaBTLJunE0ocR6XHmKHv9RHUwisSwKMc6okCQp5jfyWEEe4fX9s3hN
I0+n4pyeGR+mhnQf8+idDAlH5Xk3bRKCIH5kiM64QcxdFQAe6af/XfzNIqwBSiv5
U1pmNifKmnDysLwgSanEtfVMxBB89ZofjxNGE1FlI7xk8S0y4jiDClgkuNcYHpzz
UZRgd7DAhhNUle2yRzIzKc6uQHlRl1wI7u5n2ojdX7x/W3hObzO1CsGEiC2riSKu
drXVcoVGBpJTpRj2IcsUScxSOvrNmr1GIpAKOd/SfmgYL+EhhARYXA==
=Y/5+
-----END PGP SIGNATURE-----