[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] mysqldump problem with cachetables
- Subject: [EP-tech] mysqldump problem with cachetables
- From: M.Bodger at westminster.ac.uk (Malcolm Bodger)
- Date: Fri, 19 Apr 2013 10:08:46 +0000
Hi,
I'm having a problem using mysqldump to backup my EPrints 3.2.3 database.
I'm using command:
mysqldump --opt --user=root --password=mypassword --skip-lock-tables eprints > /backups/eprints/mysql-eprints323.sql
It's complaining about cache tables:
Error: Couldn't read status information for table cache1812586 ()
mysqldump: Couldn't execute 'show create table `cache1812586`': Table 'eprints.cache1812586' doesn't exist (1146)
When I check I find I have 858 cache tables.
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?
Thanks,
Malcolm.
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20130419/fb35a711/attachment-0001.html