Webhosting – Database Version

  Web Hosting

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:

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:

  1. Log into the customer administration panel.
  2. In the navigation bar, select Web & Email Hosting Webhosting or WMS.
  3. Select the service you want to check.
  4. In the service detail, in the Database table, click on the name of the selected database.
  5. Check the database version in the detail under the Database Server item.
WEDOS Database server details
Database server details

Database Version in phpMyAdmin

You can get the database version in the phpMyAdmin interface using the following procedure:

  1. Lon into phpMyAdmin.
  2. Find the Software version in the Database Server section.
WEDOS Database version in phpMyAdmin
Database version in phpMyAdmin

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:

  1. Export the current database and import it into the new database according to the instructions in the article Webhosting – Export/Import Database in phpMyAdmin.
  2. 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.

Děkujeme za zpětnou vazbu!