You may wish to backup your Open-AudIT data before upgrading or on a regular schedule. There are two main items to backup. The database and the files.
Database backup on Windows
cd c:\xampp\mysql\bin mysqldump -u openaudit -popenauditpassword --extended-insert=FALSE --routines openaudit > openaudit_backup.sql
Database Backup on Linux
mysqldump -u openaudit -popenauditpassword --extended-insert=FALSE --routines openaudit > openaudit_backup.sql
File Backup on Windows
You can either stop the MySQL and Apache services and then backup the entire c:\xampplite directory or only backup the c:\xampplite\open-audit directory. You don't really need all of the XAMPPLite directories as you can simply use the reinstall at a later stage. If you backup your open-audit directory you will have the config files as well as any uploaded attachments.
File Backup on Linux
Just copy the folder /usr/local/open-audit and you're done.
On both Windows and Linux you might wish to compress (zip or tar.gz) the resulting database and directory files.
Restoring on Windows
Run the install program to install and setup Open-AudIT. You can then copy your backup file and restore the database with:
copy openaudit_backup.sql c:\xampp\mysql\bin\ cd c:\xampp\mysql\bin mysql -u openaudit -popenauditpassword openaudit < openaudit_backup.sql
Restoring on Linux
Is almost the same as Windows. Copy the database backup to /tmp and import it into MySQL.
cp openaudit_backup.sql /tmp/ mysql -u openaudit -popenauditpassword openaudit < /tmp/openaudit_backup.sql
Once the database has been restored, you may need to go into the web application and run the Admin -> Upgrade routine (if you have not restored to the same version of the program as the backups version).
You can also just copy the backed up files back to their original location, overwriting any existing files.
NOTE - If you have upgraded versions in between backup and restore, ONLY restore the config directory (open-audit/code_igniter/application/config) and the attachments directory (open-audit/code_igniter/application/attachments). If you overwrite the other (program) files, you will effectively reverse the upgrade you have performed.