Re: MySQLDump - Melissa Dougherty - com.mysql.lists.win32

20 messages in com.mysql.lists.win32Re: MySQLDump

From	Sent On	Attachments
Melissa Dougherty	07 Sep 2006 09:37
Melissa Dougherty	07 Sep 2006 09:51
Michael Louie Loria	12 Sep 2006 18:54
Mikhail Berman	13 Sep 2006 06:41
Melissa Dougherty	13 Sep 2006 07:54
Mikhail Berman	13 Sep 2006 08:04
Jorge Bastos	13 Sep 2006 08:41
Jorge Bastos	13 Sep 2006 10:19
Melissa Dougherty	13 Sep 2006 10:20
Melissa Dougherty	13 Sep 2006 11:46
Jorge Bastos	13 Sep 2006 14:21
Urcid Pliego, Paulo	13 Sep 2006 14:40
Michael Louie Loria	13 Sep 2006 17:45
Melissa Dougherty	14 Sep 2006 11:35
dpgi...@mdanderson.org	14 Sep 2006 11:56
Melissa Dougherty	14 Sep 2006 12:47
dpgi...@mdanderson.org	14 Sep 2006 13:01
Mikhail Berman	14 Sep 2006 13:08
Melissa Dougherty	14 Sep 2006 18:29
Melissa Dougherty	19 Sep 2006 06:58

Subject:	Re: MySQLDump
From:	Melissa Dougherty (meli...@cse-corp.com)
Date:	09/13/2006 10:20:57 AM
List:	com.mysql.lists.win32

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" <mber...@ivesinc.com> To: "Melissa Dougherty" <meli...@cse-corp.com>; "Michael Louie Loria" <mllo...@lorztech.com>; <win...@lists.mysql.com> 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

The -p switch is for the password.

----- Original Message ----- From: "Mikhail Berman" <mber...@ivesinc.com> To: "Michael Louie Loria" <mllo...@lorztech.com>; <win...@lists.mysql.com> 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,

-----Original Message----- From: Michael Louie Loria [mailto:mllo...@lorztech.com] Sent: Tuesday, September 12, 2006 9:55 PM To: win...@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.