Project

General

Profile

Actions

Feature #13281

closed

combine all import/export scripts for refreshing database

Added by Anchi Cheng over 2 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
Start date:
08/12/2022
Due date:
% Done:

0%

Estimated time:
Deliverable:

Description

There are a number of scripts in dbschema/tools for exporting various metadata needed to populate fresh leginon/project/appion databases. This feature gives two scripts to combine what are done in all of them.


Related issues 1 (0 open1 closed)

Related to Leginon - Feature #11770: Export essentials for refresh leginon database in one scriptClosedAnchi Cheng12/28/2021

Actions
Actions #1

Updated by Anchi Cheng over 2 years ago

Note: Application and settings import do not include all applications nor for all users. Please edit the file if you want to change what it transfers.
Note: The exported settings come from the session used the application most recently. They will become the default settings in the new database upon import.

Export Requirements:

  1. sinedon.cfg pointing to the old databases to be exported.

The results are saved in subfolder of where you run the script.

Import Requirements:

  1. new project and leginon database need to be created. It can be empty with no tables.
  2. sinedon.cfg pointing to the new database.
  3. run import_all.py at the same directory you ran export_all.py
Actions #2

Updated by Anchi Cheng about 2 years ago

  • Status changed from Assigned to Closed

Tested and used in the recent memc migration

Actions #3

Updated by Anchi Cheng about 2 years ago

  • Related to Feature #11770: Export essentials for refresh leginon database in one script added
Actions

Also available in: Atom PDF