From: Jorge Bastos Date: September 13 2006 9:22pm Subject: Fw: MySQLDump List-Archive: http://lists.mysql.com/win32/18502 Message-Id: <003901c6d77b$da9a91b0$0101a8c0@pcjorge> MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit hum, 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" ; "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@stripped] >>> Sent: Wednesday, September 13, 2006 10:55 AM >>> To: Mikhail Berman; Michael Louie Loria; win32@stripped >>> 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@stripped] >>> Sent: Tuesday, September 12, 2006 9:55 PM >>> To: win32@stripped >>> 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@stripped >>> >>> >>> >>> >>> -- >>> MySQL Windows Mailing List >>> For list archives: http://lists.mysql.com/win32 >>> To unsubscribe: >>> http://lists.mysql.com/win32?unsub=mysql.jorge@stripped >>> >>> >> >> >> -- >> MySQL Windows Mailing List >> For list archives: http://lists.mysql.com/win32 >> To unsubscribe: >> http://lists.mysql.com/win32?unsub=melissa@stripped >> >> > > > -- > MySQL Windows Mailing List > For list archives: http://lists.mysql.com/win32 > To unsubscribe: > http://lists.mysql.com/win32?unsub=mysql.jorge@stripped > >