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.

-----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/yJzxxSw
ZSd37RXmMN8zT8c9xEvbMgFdspxeVYx41tEKIDfOs8C4Z4IHdQdSRCa5coCeEpBo
F0YDg9m1nJ8NK4yuVsNNH0qQLT901T7Gr99pqBMF32Mo+Ix3lDzbqWUcLgKzJpBX
zKN/N1Fv7wMuzlffi1tAXL9oEcc0dVobcA241Kn3XJ0ihPqi5Ci+SSoiAy3Lp8Q2
oJiIVfXHRDYy1yeeB0a6BINLeDlUf39sLSV1hpl1Dkx6Xa6fp38nQw==
=XbiT
-----END PGP SIGNATURE-----