Wiki Spaces

Documentation
Projects
Resources

Get Help from Others

Q&A: Ask OpenMRS
Discussion: OpenMRS Talk
Real-Time: IRC Chat | Slack

Documentation

Page tree
Skip to end of metadata
Go to start of metadata

Home          Previous Page           Next Page

It is good practice to back up your server regularly. If you are using MySQL, the mysqldump command makes it very easy.

The typical command to back up your entire database is:

  • -uroot = use username of root
  • -p = ask for password
  • -e = extended inserts (makes the dump 10x smaller)
  • --single-transaction = run this in a single transaction (to prevent corruption)
  • -q = quick
  • -r = file location to store
  • openmrs = name of your database

If you want to automate it, you can provide the username and password for mysql in the command:

If you want to exclude a few of the extremely large tables, you can do that too

If you are on a linux variant, you can insert the date automatically into the backup sql filename:

If you are on windows, you can insert the date automatically too, its just a little uglier:

After creating the backup .sql file, you can zip it and store it for later use.  

Restoring From A Backup File

The now get the data out of an archived sql backup file and into a new database its merely three simple steps:

  1. Create your new database
    1. create database openmrsbackuprestoration default character set utf8;
  2. Tell mysql to work against that new database
    1. use openmrsbackuprestoration
  3. Run the sql file
    1. source backup.sql

Now wait for 1, 20, or 30 minutes and you'll have all your data back.

  • No labels

1 Comment

  1. It looks like the commands are failing to display on this page here is the commands to run on unix based platforms like ubuntu:

    to dump openmrs database use; 

    /opt/lampp/bin/./mysqldump -u root -p databaseNamelikeopenmrs > /home/userName/Desktop/wantedsqlfileName.sql 

    Change the paths to refer to the bin directory where mysql is and the path to where you want the .sql file to be respectively