1 of 1

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:

Replace [italic_text] (including the square bracket) with specific info:

[user]: in most cases, use root (recommended)

If you want to compress the SQL backup files, you can use this command instead:

| xz was added for compressing SQL file to .xz file

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:

Replace [italic_text] (including the square bracket) with specific info:

[user]: in most cases, use root (recommended)

While this approach might work well in case of same MySQL or MariaDB version, if you migrate or upgrade SQL, you want to follow the instruction here for better users backup:

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

Step 4: use ssh and terminal, login as terminal root and run:

Replace [italic_text] (including the square bracket) with specific info:

[database-name]: use the name of the database that you want to backup

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 .

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 .

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:

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:

Replace [italic_text] (including the square bracket) with specific info:

[user]: in most cases, use root (recommended)

If you want to compress the SQL backup files, you can use this command instead:

| xz was added for compressing SQL file to .xz file

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:

Replace [italic_text] (including the square bracket) with specific info:

[user]: in most cases, use root (recommended)

While this approach might work well in case of same MySQL or MariaDB version, if you migrate or upgrade SQL, you want to follow the instruction here for better users backup:

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

Step 4: use ssh and terminal, login as terminal root and run:

Replace [italic_text] (including the square bracket) with specific info:

[database-name]: use the name of the database that you want to backup

Step 5: go to OE on web browser and login with mysql root account.

Step 6: go to Settings and then click on Recreate users. That should reactivate all users and their passwords.

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:

Save or Backup Database

For chemicals and lab journal databases:

1. Open a Window Powershell window, type the following command:

Replace [italic_text] (including the square bracket) with specific info.

[user]: in most cases, use root (recommended).

In the command above, this part is for the default XAMPP set up. If some error happens, you should find the executable file inside XAMPP folder in your system. You can try to follow this .

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:

Replace [italic_text] (including the square bracket) with specific info:

[user]: in most cases, use root (recommended).

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: if you have not done so.

Step 3: use ssh and terminal, login as terminal root and run:

Replace [italic_text] (including the square bracket) with specific info:

[database-name]: use the name of the database that you want to backup

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 .

Step 5: go to Settings and then click on Recreate users. That should reactivate all users and their passwords.

Database Backup and Restore

hashtagFor traditional LAMP stack

hashtagSave or Backup Database(s)

hashtag For chemicals and lab journal databases:

hashtag For users info:

hashtagRestore

hashtagFor XAMPP users

hashtagSave or Backup Database

hashtag For chemicals and lab journal databases:

Database Backup and Restore

hashtagFor traditional LAMP stack

hashtagSave or Backup Database(s)

hashtag For chemicals and lab journal databases:

hashtag For users info:

hashtagRestore

hashtagFor XAMPP users

hashtagSave or Backup Database

hashtag For chemicals and lab journal databases:

hashtag For users info:

hashtagRestore

hashtagSave or Backup Database

hashtag For chemicals and lab journal databases:

hashtag For users info:

hashtagRestore

hashtag

For traditional LAMP stack

Save or Backup Database(s)

For chemicals and lab journal databases:

For users info:

Restore

For XAMPP users

Save or Backup Database

For chemicals and lab journal databases:

For traditional LAMP stack

Save or Backup Database(s)

For chemicals and lab journal databases:

For users info:

Restore

For XAMPP users

Save or Backup Database

For chemicals and lab journal databases:

For users info:

Restore

Save or Backup Database

For chemicals and lab journal databases:

For users info:

Restore