Page History

...

cd c:\xampplitexampp\mysql\bin

mysqldump -u openaudit -popenauditpassword --extended-insert=FALSE --routines openaudit > openaudit_backup.sql

...

mysqldump -u openaudit -popenauditpassword --extended-insert=FALSE --routines openaudit > openaudit_backup.sql

...

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 directory 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.

...

copy openaudit_backup.sql c:\xampplitexampp\mysql\bin\

cd c:\xampplitexampp\mysql\bin

mysql -u openaudit -popenauditpassword openaudit < openaudit_backup.sql

...

You can also just copy the backed up files back to their original location, over writing 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 over write overwrite the other (program) files, you will effectively reverse the upgrade you have performed.