Child pages
  • Reset, Backup and Restore the Open-AudIT database
Skip to end of metadata
Go to start of metadata

Open-AudIT ships with a .sql file used to build the database schema. It is a simple matter to use this and reset the database.

NOTE - If you have changed the credentials used by Open-AudIT to access MySQL you will need to adjust the below commands.

Recreate Database

Linux

mysql -u openaudit -popenauditpassword openaudit < /usr/local/open-audit/other/openaudit_mysql.sql

Windows

c:\xampplite\mysql\bin\mysql.exe -u openaudit -popenauditpassword openaudit < c:\xampplite\open-audit\other\openaudit_mysql.sql

 

Completely Delete Database and Recreate

If you would like to completely drop the database, run the below commands.

Linux

mysql -u root -popenauditrootuserpassword -e "drop database openaudit; create database openaudit;"
mysql -u openaudit -popenauditpassword openaudit < /usr/local/open-audit/other/openaudit_mysql.sql

Windows

c:\xampplite\mysql\bin\mysql.exe -u root -popenauditrootuserpassword -e "drop database openaudit; create database openaudit;"
c:\xampplite\mysql\bin\mysql.exe -u openaudit -popenauditpassword openaudit < c:\xampplite\open-audit\other\openaudit_mysql.sql

 

Backup the Database

Linux

mysqldump -u openaudit -popenauditpassword --routines --extended-insert=FALSE openaudit > /tmp/openaudit_mysql.sql

Windows

c:\xampplite\mysql\bin\mysqldump.exe -u openaudit -popenauditpassword --routines openaudit > c:\temp\openaudit_mysql.sql

 

Restore the Database

Linux

mysql -u openaudit -popenauditpassword openaudit < /tmp/openaudit_mysql.sql

Windows

c:\xampplite\mysql\bin\mysql.exe -u openaudit -popenauditpassword openaudit < c:\temp\openaudit_mysql.sql