MySQL Forums :: Database Administration & Monitoring :: MySqlDump Error 2013, what is it?


Advanced Search

MySqlDump Error 2013, what is it?
Posted by: jeff perreault ()
Date: December 15, 2008 12:12PM

I am backing up a database using MySQLDump and am having troubles.

The database is a wikidatabase, not huge and is a mixture of InnoDB and MyIsam tables. The table in 'text' is 40,000 records and is InnoDB.

$ mysqldump -q -e wikidatabase >> backup.sql
$ mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `text` at row: 4584

I have tried using the --quick option and I get the same error.

I have tried exporting other tables, and they work. When I try to export the 'text' table on it's own, I get the same error.

$ mysqldump -q -e wikidatabase text >> backup.sql
$ mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `text` at row: 4584

What does this error mean?
Do I have a corrupt table? A corrupt row? I'm thinking about deleting the row in question (of course I can't create a backup)



Edited 1 time(s). Last edit at 12/15/2008 12:46PM by jeff perreault.

Options: ReplyQuote


Subject Written By Posted
MySqlDump Error 2013, what is it? jeff perreault 12/15/2008 12:12PM
Re: MySqlDump Error 2013, what is it? John Daisley 12/16/2008 10:12AM
Re: MySqlDump Error 2013, what is it? jeff perreault 12/16/2008 11:38AM
Re: MySqlDump Error 2013, what is it? Umesh Shastry 12/22/2008 05:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.