1and1 Help Centre Categories

print article

MySQL 4 Phaseout

Linux Hosting packages with MySQL 4 databases

MySQL 4 is being phased out and therefore any data held within a MySQL 4 database must be migrated into a new MySQL 5 database. Please find a list of frequently asked questions regarding the phaseout and migration below.

Does the migration involve any cost?
This migration will not result in any additional costs for your or your package.
Will there be any changes to my contract term or my package?
Your contract term and other package services will remain unaffected.
What is MySQL?
MySQL is a widely used database system used to store website text or data separately from the style or layout of a website. In combination with the PHP scripting language, MySQL has been a current standard for creating dynamic web pages for years.
Have you built your site using NetObjects Fusion, Adobe Dreamweaver or Frontpage?
Then it is highly unlikely that your website is affected by this MySQL 4 phaseout.
Have you built your site using 1&1 MyWebsite or 1&1 WebsiteBuilder?
Then your website is not affected by this MySQL 4 phaseout.
Why is the migration not done automatically?
The migration cannot be carried out automatically because some features of MySQL 4 are not supported in MySQL 5 and in order to minimise the amount of transmission and handling of your private data. Because of this we are allowing customers to carry out the migration on their own, at their leisure.
How do I know if my databases are affected?
Any database created in the 1&1 Control Panel that says MySQL 4 as the version, will need to be migrated to a newly created MySQL 5 database. You can check what version of MySQL your databases are by logging into your 1&1 Control Panel and clicking on MySQL Database from the Hosting section.
Please note:
The following points require advanced knowledge in the field of script programming and administration of MySQL databases. If your web presence is supervised by a service provider, please forward the following information to him/her.
How can I import the data from my old MySQL 4 database into the new MySQL 5 database?
In order to complete the migration, you will need to create a new database to replace every MySQL 4 database you have. All newly created databases will already be MySQL 5. Then you simply export the data from the existing MySQL 4 database, and then import the data into the newly created MySQL 5 database.
Will my site still function after the migration?
You will need to update the database connection info for site, since you want to have the site connect to the new MySQL 5 database from now on. Until you make this change, the site will continue to function just as it was, because the site is still configured to use the older MySQL 4 database. This is not an exhaustive list though, so you may have to get help from the CMS provider to find out how to change the database information, or contact your web developer if you commissioned the creation of your custom site.

Once you update your database connection info to use the new MySQL 5 database, that is when you may encounter some problems. If so, you can edit the database connection info again to revert the changes and connect to the older MySQL 4 database until the issue can be investigated. But it is suggested to look into the differences between MySQL 4 and MySQL 5 in order to make any changes necessary to avoid complications before the switch.