<div>
Can you check the .err log file for any messages? &nbsp;You may have a similar case as <a href="http://bugs.mysql.com/bug.php?id=10424" rel="ugc">http://bugs.mysql.com/bug.php?id=10424</a>, where the machine was low in memory.
</div>


Can you check the .err log file for any messages?  You may have a similar case as http://bugs.mysql.com/bug.php?id=10424 [http://bugs.mysql.com/bug.php?id=10424], where the machine was low in memory.

<div>
Thanks for the link. On further investigation it appears that one of the tables in the database is marked as &quot;Crashed&quot; /I have repaired the table, started up the slave sql and am now re-running the backup. <br />
<br />
I will post the results shortly.<br />
<br />
Phil
</div>


Thanks for the link. On further investigation it appears that one of the tables in the database is marked as "Crashed" /I have repaired the table, started up the slave sql and am now re-running the backup.

I will post the results shortly.

Phil

<div>
<div class="content wysiwyg-content">
I am having trouble working out what is causing this issue.<br />
<br />
We have a slave server that runs a backup each night. The backup dumps two data bases.<br />
<br />
A few minutes into the backup we get an error as below:<br />
<br />
<i>mysqldump: Error 1030: Got error 127 from storage engine when dumping table </i><br />
<br />
Then after looking at the slave status we see the below:<br />
<br />
<br />
&nbsp; &nbsp;Slave_IO_Running: Yes<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Slave_SQL_Running: No<br />
<br />
<br />
I then manage to get the Slave_SQL_Running to a YES status and re run the backup, this then errors again and the Slave_SQL_Running goes back to a status of NO.<br />
<br />
Any help on getting this working again would be great.<br />
<br />
Thanks <br />
<br />
Phil
</div>
</div>


I am having trouble working out what is causing this issue.

We have a slave server that runs a backup each night. The backup dumps two data bases.

A few minutes into the backup we get an error as below:

mysqldump: Error 1030: Got error 127 from storage engine when dumping table 

Then after looking at the slave status we see the below:


   Slave_IO_Running: Yes
          Slave_SQL_Running: No


I then manage to get the Slave_SQL_Running to a YES status and re run the backup, this then errors again and the Slave_SQL_Running goes back to a status of NO.

Any help on getting this working again would be great.

Thanks 

Phil

mysqldump: Error 1030: Got error 127 from storage engine when dumping table

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.