<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle" type="text/css">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
</head>
<body>
<div style="direction:ltr; font-family:Times New Roman; color:#000000; font-size:12pt">
Hi,<br>
<br>
I'm having a problem using mysqldump to backup my EPrints 3.2.3 database.<br>
<br>
I'm using command:<br>
mysqldump --opt --user=root --password=mypassword --skip-lock-tables eprints > /backups/eprints/mysql-eprints323.sql<br>
<br>
It's complaining about cache tables:<br>
<br>
Error: Couldn't read status information for table cache1812586 ()<br>
mysqldump: Couldn't execute 'show create table `cache1812586`': Table 'eprints.cache1812586' doesn't exist (1146)<br>
<br>
When I check I find I have 858 cache tables.<br>
I'm thinking I might have to stop apache to deny access while I do my backup. But, it was ok a few weeks ago. Has anyone got any ideas?<br>
<br>
Thanks,<br>
Malcolm.<br>
</div>
<div align="center">
<p><font color="black" size="0.9em" face="Arial, Helvetica, sans-serif">The University of Westminster is a charity and a company limited by guarantee. Registration number: 977818 England. Registered Office: 309 Regent Street, London W1B 2UW.</p>
</font></div>
</body>
</html>