Systems Administration
      Back to home
      1. Support Portal
      2. Features
      3. Systems Administration

      Moving your Database from One Machine to Another

      Steps to move your database

      The software uses a MySQL database on all platforms which allows you to successfully move the software to another server with the same version. The Database (DB) is only compatible with the version the DB was exported from. 

      Moving Database to Another Server

      Before you can move the database, both servers need to be on the same version.  It is best to upgrade your current system with the latest version. Next, build your new server with the upgrade version and then export DB from the original server and import it to the new server. 

      If you need to update your software, please Submit A Ticket for the latest software.  

      Export your DB on current Server with a single backup command:

      1. Backup all databases:

      2. Open command line window and source Environment Variables.

        cmd> oware for Windows or . /etc/.dsienv for Linux

      3. Execute the following to command to export your DB.

        cmd> mysqldump -uroot -pdorado --single-transaction --all-databases --triggers --routines --events >all_databases.sql

      Build your new server with the same version.

      Import your Data to New Server:

      1. Shut down App and Web Server

      2. Copy the all_databases.sql file to the new Server

      3. CD to the directory you copied the all_databases.sql files

      4. Restore ALL databases command

        cmd> oware for Windows or . /etc/.dsienv for Linux
        cmd> mysql -u root --password=dorado < all_databases.sql

        cmd> dbpostinstall

      5. Startup App and web server