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