Database Backup and Restore
This is procedure to backup Open Enventory database and restore it later on the same server or migrating to a different server
For traditional LAMP stack
This guide is for Linux environment with Apache2, PHP and MariaDB (MySQL) (LAMP) stack:
Save or Backup Database(s)
For chemicals and lab journal databases:
1. In Terminal window, type the following command:
2. Type in password for the user above and then Enter (nothing will show when you are typing the password)
For users info:
1. In Terminal window, type the following command:
2. Type in password for the user above and then Enter (nothing will show when you are typing the password)
Restore
Step 1: transfer both files (database and users, if you want to keep the same users and passwords) to the new system/server
Step 2: create the database from OE web login if you have not done so.
Step 3 (optional):
If you have compressed the SQL file as instruction above, you will need to decompress the file first.
This is for compressed file with .xz
extension:
-v
: verbose, give more infok
: to keep the compressed file, this will generated the uncompressed file .sql
Step 4: use ssh and terminal, login as terminal root and run:
Step 5: go to OE on web browser and login with mysql root
account.
If the mysql root
user in the old database has password different than the current mysql root
user, after step 3 above, the root
user password will be changed to the old password.If you don't know the old mysql root
password, follow this tutorial to reset mysql root password.
Step 6: go to Settings
and then click on Recreate users
. That should reactivate all users and their passwords.
Again, if you have migrate from MariaDB < 10.4 to MariaDB 10.4+, it might not work and we have to change the command in step 3 above. The reason is because the mysql.user table is deprecated in MariaDB 10.4. You can read more about it here.
For XAMPP users
While the general steps are similar, the exact paths to the executable command are different for Mac OS and Windows using XAMPP, please follow the corresponding guides below:
Save or Backup Database
For chemicals and lab journal databases:
1. In Terminal window, type the following command:
2. Type in password for the user above and then Enter (nothing will show when you are typing the password)
For users info:
1. In Terminal window, type the following command:
2. Type in password for the user above and then Enter (nothing will show when you are typing the password)
Restore
Step 1: transfer both files (database and users, if you want to keep the same users and passwords) to the new system/server
Step 2: create the database from OE web login if you have not done so.
Step 3: use ssh and terminal, login as terminal root and run:
Step 4: go to OE on web browser and login with mysql root
account.
If the mysql root
user in the old database has password different than the current mysql root
user, after step 3 above, the root
user password will be changed to the old password.
If you don't know the old mysql root
password, follow this tutorial to reset mysql root password.
Step 5: go to Settings
and then click on Recreate users
. That should reactivate all users and their passwords.
Again, if you have migrate from MariaDB < 10.4 to MariaDB 10.4+, it might not work and we have to change the command in step 3 above. The reason is because the mysql.user table is deprecated in MariaDB 10.4. You can read more about it here.
Last updated
Was this helpful?