[EP-tech] Re: mysqldump problem with cachetables

[Malcolm Bodger]

Hi Paolo,

I run the cleanup_cachemaps, but it only removed one orphaned table, leaving me with 942.
Would you know why I have so many cache tables?

Thanks.
Regards,
Malcolm.
________________________________________
From: Paolo Tealdi [paolo.tealdi at polito.it]
Sent: 19 April 2013 13:38
To: eprints-tech at ecs.soton.ac.uk
Cc: Malcolm Bodger
Subject: Re: [EP-tech]  mysqldump problem with cachetables

Il 19/04/2013 12:08, Malcolm Bodger ha scritto:
> 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.
>
>

Hi Malcom,

you might use --force to "force" mysqldump to continue the backup.

Before starting the backup, you might use "epadmin cleanup_cachemaps *repository_id*" command to drop orphaned cache

Best regards,
Paolo Tealdi





--
Ing. Paolo Tealdi         Area IT - Politecnico Torino
Telefono/Phone : +39-011-0906714 , FAX : +39-011-0906799
Indirizzo/Address : C.so Duca degli Abruzzi,  24 - 10129 Torino - ITALY
Skype : tealdi.paolo
Please consider your environmental responsibility before printing this e-mail

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.