Re: MySQLDump

The -p switch is for the password.  


----- Original Message ----- 
From: "Mikhail Berman" <[email protected]>
To: "Michael Louie Loria" <[email protected]>; <[email protected]>
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:[email protected]] 
Sent: Tuesday, September 12, 2006 9:55 PM
To: [email protected]
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/[email protected]



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]