Re: MySQLDump
"Melissa Dougherty" <[email protected]> Wed, 13 Sep 2006 14:47:18 -0400
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <003201c6d765$09e37c50$3c0a0a0a@denterprise1> |
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" <[email protected]> To: <[email protected]> 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" <[email protected]> > To: "Mikhail Berman" <[email protected]>; "Michael Louie Loria" > <[email protected]>; <[email protected]> > 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" <[email protected]> >> To: "Melissa Dougherty" <[email protected]>; "Michael Louie Loria" >> <[email protected]>; <[email protected]> >> 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:[email protected]] >> Sent: Wednesday, September 13, 2006 10:55 AM >> To: Mikhail Berman; Michael Louie Loria; [email protected] >> Subject: 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] >> >> > > > -- > 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]