1
0
-1

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?

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      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

       

       

       

       

       

        CommentAdd your comment...