Unfortunately, a direct database version upgrade is not possible for technical reasons. If your application requires a newer version of the database software, follow the instructions below.
If you change the database password during the procedures below, the application connected to it will stop working.
In this article, you will learn:
- How to find out the current database version
- How to create a database with a newer MariaDB version
- How to migrate the data and set up the website
- Frequently asked questions
Current Database Version
If the software using the database does not tell you the version, you can check the:
Database Version in Customer Admin Panel
You can get the database version (and other information) in the database detail by following these steps:
- Log into the customer administration panel.
- In the navigation bar, select Web & Email Hosting Webhosting or WMS.
- Select the service you want to check.
- In the service detail, in the Database table, click on the name of the selected database.
- Check the database version in the detail under the Database Server item.
Database Version in phpMyAdmin
You can get the database version in the phpMyAdmin interface using the following procedure:
Create Database with New MariaDB
Each Webhosting has an assigned database server on which it operates existing and creates new databases. If there is a lower MariaDB version on this server than your application requires, creating a new database will not solve the problem. In this case, only customer support can create a database with a newer version of MariaDB.
To set up a database with a newer version of MariaDB, contact customer support after logging into the customer account where the service is located. Use the following template:
Please create a new database on a server with the current version of MariaDB for Webhosting (replace this with the Webhosting name).
New database name: (replace with an unused database name)
Send login information to: (replace with email to receive login info)
The name of the new database must be unique. If it matches an existing name, use a number to differentiate it.
Requests are handled by customer support.
Migrate Data and Set up Website
After receiving the email with login details for the new database, follow these steps:
- Export the current database and import it into the new database according to the instructions in the article Webhosting – Export/Import Database in phpMyAdmin.
- Change the database login information (server, database name, user and password) in the configuration file of your application. If you don’t know which file to edit, consult your application’s manual or support.
After making the changes, check that the application is really using the new database and that changing the MariaDB version does not cause any errors on the site.
FAQ
Question: How often do you update the database?
Answer: We update at the frequency and extent that the infrastructure allows. Unfortunately, this is already very extensive, and some updates therefore require long-term testing, so that they do not damage customer websites by deploying them. Regarding the current version of the databases and possibly a request to set up a database on a server with a newer version, contact support. Enter the Webhosting service name and the requested database version.
Question: Can I change the database type to MySQL or another?
Answer: You can only run a database other than MariaDB on your own server.
Question: If I import data from a significantly older database, will it work on the newer version?
Answer: It is possible, but not guaranteed. After the import, check thoroughly that the application uses the new database and everything works without errors or complications. If you encounter errors, make sure that the file was not damaged during export or import.