Project

General

Profile

Actions
Copy link

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:
Arne Moeller
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
Copy link
 #1

Updated by Anchi Cheng over 8 years ago

Could you upload or send me the original sqldump ? I'd like to take a look. It has never failed like this before.

Actions
Copy link
 #2

Updated by Anchi Cheng over 8 years ago

  • Status changed from New to Assigned
  • Assignee set to Arne Moeller
Actions
Copy link
 #3

Updated by Anchi Cheng almost 7 years ago

  • Status changed from Assigned to Closed

For future reference: A group of export/import tools in dbschema/tools will allow getting calibrations and settings back in 3.3 and above. Project restoration probably best handled by mysqldump and loading since that is small.

Actions
Copy link

Also available in: Atom PDF