Actions
Support #4388
closedloading mysql dump to db
Start date:
08/16/2016
Due date:
% Done:
0%
Estimated time:
Affected Version:
Appion/Leginon 3.2
Description
After a massive disk failure we are trying to recover our database using a mysql dump that we had generated as backup.
When we load it via mysql -h your_host -u your_db_username -p leginondb < your_mysqldump
we are getting errors that are not very informative to us like:
Error 1054 (42S22) at line 3585: Unkown column ‘REF|ApXmippCtfParamsData|xmipp_ctf_params’ in 'field list’
Sargis had suggested to setup the db and than load everything through phpmyadmin.
When we try this we do not get this error message but an error "too big to be loaded"
Any idea how we can get the calibrations and possibly the projects back into the db?
many thanks for your help
Arne
Actions