| Note |
|---|
This page is outdated and no longer receives updates! |
It is good practice to back up your server regularly. If you are using MySQL, the mysqldump command makes it very easy.
...
| Panel |
|---|
mysqldump -u root -p -e --single-transaction -q -r"/home/ben/backup.sql" openmrs |
-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:
...
The now get the data out of an archived sql backup file and into a new database its merely three simple steps:
Create your new database
create database openmrsbackuprestoration default character set utf8;
Tell mysql to work against that new database
use openmrsbackuprestoration
Run the sql file
source backup.sql
Now wait for 1, 20, or 30 minutes and you'll have all your data back.