Project

General

Profile

Actions

Support #4388

closed

loading mysql dump to db

Added by Arne Moeller over 8 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
-
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

Also available in: Atom PDF