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=gcdmw-win32@m.gmane.org

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=gcdmw-win32@m.gmane.org