Fw: MySQLDump
am 13.09.2006 23:22:20 von Jorge Bastoshum, theres no info about that error :(
server:~# perror 2013
Illegal error code: 2013
----- Original Message -----
From: "Melissa Dougherty"
To: "Jorge Bastos"
Sent: Wednesday, September 13, 2006 7:47 PM
Subject: 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"
>>
>> 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"
>>>
>>> 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=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