{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"This page is outdated and no longer receives updates!","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"paragraph","content":[{"text":"Home","type":"text","marks":[{"type":"link","attrs":{"href":"https://openmrs.atlassian.net/wiki/spaces/Archives/pages/25520569"}}]},{"text":" ","type":"text"},{"text":"Previous Page","type":"text","marks":[{"type":"link","attrs":{"href":"https://openmrs.atlassian.net/wiki/spaces/Archives/pages/25520570"}}]},{"text":" ","type":"text"},{"text":"Next Page","type":"text","marks":[{"type":"link","attrs":{"href":"https://openmrs.atlassian.net/wiki/spaces/Archives/pages/25520572"}}]}]},{"type":"paragraph","content":[{"text":"It is good practice to back up your server regularly. If you are using MySQL, the ","type":"text"},{"text":"mysqldump","type":"text","marks":[{"type":"em"}]},{"text":" command makes it very easy.","type":"text"}]},{"type":"paragraph","content":[{"text":"The typical command to back up your entire database is:","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"html","parameters":{"macroParams":{"__bodyContent":{"value":"

 mysqldump -uroot -p -e --single-transaction -q -r\"/home/ben/backup.sql\" openmrs

"}},"macroMetadata":{"macroId":{"value":"0bfa0f78-d29d-406a-92f3-3cad88ef4503"},"schemaVersion":{"value":"1"},"title":"html"}},"localId":"802eb057-01b8-4fe3-99d5-91d1189e35c4"}},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"-uroot = use username of root","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"-p = ask for password","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"-e = extended inserts (makes the dump 10x smaller)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"--single-transaction = run this in a single transaction (to prevent corruption)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"-q = quick","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"-r = file location to store","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"openmrs = name of your database","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"If you want to automate it, you can provide the username and password for mysql in the command:","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"html","parameters":{"macroParams":{"__bodyContent":{"value":"

 mysqldump -uroot -pPA$$W0rd -e --single-transaction -q -r\"/home/ben/backup.sql\" openmrs

"}},"macroMetadata":{"macroId":{"value":"d6ab4be7-90e7-4978-bca5-ef78f3e3b2f8"},"schemaVersion":{"value":"1"},"title":"html"}},"localId":"a51e3cf0-1b1f-415d-9f60-d8ab227c2a24"}},{"type":"paragraph","content":[{"text":"If you want to exclude a few of the extremely large tables, you can do that too","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"html","parameters":{"macroParams":{"__bodyContent":{"value":"

 mysqldump -uroot -p -e --single-transaction -q -r\"/home/ben/backup.sql\" --ignore-table=hl7_in_archive --ignore-table=formentry_archive openmrs

"}},"macroMetadata":{"macroId":{"value":"0094b13c-c7e9-4924-8586-a4a96bf1e227"},"schemaVersion":{"value":"1"},"title":"html"}},"localId":"63c98929-2653-424b-abbc-1ca6fac29bf7"}},{"type":"paragraph","content":[{"text":"If you are on a linux variant, you can insert the date automatically into the backup sql filename:","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"html","parameters":{"macroParams":{"__bodyContent":{"value":"

 mysqldump -uroot -p -e --single-transaction -q -r\"/home/ben/backup`date +%Y%m%d`.sql\" openmrs

"}},"macroMetadata":{"macroId":{"value":"cc3775ae-54d3-43df-b55e-ff9744f132e3"},"schemaVersion":{"value":"1"},"title":"html"}},"localId":"aa71028c-9aad-457b-ad73-0a0a634d72e6"}},{"type":"paragraph","content":[{"text":"If you are on windows, you can insert the date automatically too, its just a little uglier:","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"html","parameters":{"macroParams":{"__bodyContent":{"value":"

 mysqldump -uroot -p -e --single-transaction -q -r\"C:\\backup%date:~10,4%%date:~4,2%%date:~7,2%\" openmrs

"}},"macroMetadata":{"macroId":{"value":"7f102a8a-c154-43df-98a9-27e8bf6ac1ed"},"schemaVersion":{"value":"1"},"title":"html"}},"localId":"0d785235-154b-4d6a-9c28-01a823ce02cc"}},{"type":"paragraph","content":[{"text":"After creating the backup .sql file, you can zip it and store it for later use. ","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Restoring From A Backup File","type":"text"}]},{"type":"paragraph","content":[{"text":"The now get the data out of an archived sql backup file and into a new database its merely three simple steps:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create your new database\n\t","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"create database openmrsbackuprestoration default character set utf8;","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Tell mysql to work against that new database\n\t","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"use openmrsbackuprestoration","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Run the sql file\n\t","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"source backup.sql","type":"text"}]}]}]}]}]},{"type":"paragraph","content":[{"text":"Now wait for 1, 20, or 30 minutes and you'll have all your data back.","type":"text"}]}],"version":1}

Browser not supported