Database Migration

Whether you want to upgrade your database to a newer version or switch from an external database to a local instance, this guide will walk you through the entire process. We’ll show you step by step how to create a new database, migrate your existing data, and modify your application configuration to use the new database.

Instructions:

Create new database

1. Log into NetConfig.

2. Go to MySQL Databases

In this example, we’ll migrate a database from version 5.7.41 to 8.0.37. Let’s start by creating a new database. To do so, click “Add New MySQL Database“.

3. Now enter the desired information:

• Password: Choose a secure password and confirm it.
• Comment: Add a description to make the database easier to identify.
• Database server: Select the target server, in this case db8.netzone.ch with MySQL 8.0.37.

Finally, click on “Create new database“.

4. After successful creation, your new database should appear in the overview.

Perform database migration

Follow the steps below:

1. Select source database (the old database from which the data is to be copied).
2. Select target database (the newly created database).
3. Enter Passwords for the source and target database.
4. Double-check your entries as incorrect settings may result in overwriting the wrong database.
5. Click on “Start Copying/Migration“.

Adjust database connection settings

After the migration, you need to adapt your application or scripts to connect to the new database. The relevant parameters are:

• Hostname
• Databasename
• Username
• Password

Depending on the software used, the configuration file may vary.

WordPress

In WordPress edit the wp-config.php file and adjust the appropriate values:

Joomla

In Joomla, the adjustment is done in the file configuration.php:

Once the configuration files are updated, your application should work without problems with the new database.