From NITRC Wiki

Backup and Restore

Data Locations

• MySql Databases
  • webMill
  • webMillWiki
• Wiki Files
  • .../webapps/jamwiki/upload/
    • All images and uploaded content for the wiki
  • .../webapps/jamwiki/WEB-INF/classes
    • Configuration settings for the wiki

Backup

• webapps : Archive the contents of the jamwiki and webmill directories in your webapps folder. Webmill could be deployed as "ROOT" if it is the default application.
  • tar -czvf webapps.tar.gz <path to webapps>
• WebMill Database
  • mysqldump -u [username] -p webMill > webMill_backupfile.sql
• Wiki Database
  • mysqldump -u [username] -p webMillWiki > webMillWiki_backupfile.sql

Restore

• With the three files from above:
  • webapps.tar.gz
  • webMill_backupfile.sql
  • webMillWiki_backupfile.sql
• Clean the existing database (assuming that you have mysql create permissions):

mysql -u root -p
mysql> drop database webMill
mysql> create database webMill;
mysql> drop database webMillWiki;
mysql> create database webMillWiki;

• IMPORTANT

NOTE: If you are restoring data to a system with different database users/passwords, be sure not to overwrite the WEB-INF folder of the jamwiki. 

• Clean the existing webapps (be sure not to REMOVE non-WebMill webapps)

rm -rf .../webapps/jamwiki
rm -rf .../webapps/<WebMill App>

• Restore the database data:

$ mysql -u root -p webMill < webMill_backupfile.sql
$ mysql -u root -p webMillWiki < webMillWiki_backupfile.sql

• Restore the webapps.tar.gz to your webapps directory
• Restore permissions

chmod -R tomcat6:tomcat6 .../webapps

• Restart the tomcat server

service tomcat6 restart