We currently host mysql on a dedicated server and would like to have the Open-AudIT database located there as well. Is there a way to move the database after the fact?
In short, yes.
Edit the file /usr/local/open-audit/code_igniter/application/config/database.php
Backup your existing database with:
mysql -u openaudit -popenauditpassword openaudit > openaudit_backup.sql
Make a database and user on the new server, then restore the data.
mysql -u root -p -e "create database openaudit"
mysql -u root -p -e "CREATE USER openaudit@% IDENTIFIED BY 'openauditpassword'"
mysql -u root -p -e "GRANT ALL PRIVILEGES ON openaudit.* TO openaudit@% IDENTIFIED BY 'openauditpassword'; FLUSH PRIVILEGES;"
mysql -u root -p openaudit < openaudit_backup.sql
Powered by a free Atlassian Confluence Open Source Project License granted to Opmantek. Evaluate Confluence today.