Child pages
  • Reset, Backup and Restore the Open-AudIT database

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Windows

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

 


Completely Delete Database and Recreate

...

Code Block
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

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

 


Backup the Database

Linux

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

Windows

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

 


Restore the Database

Linux

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

Windows

Code Block
c:\xampplitexampp\mysql\bin\mysql.exe -u openaudit -popenauditpassword openaudit < c:\temp\openaudit_mysql.sql

...