You are Here: FAQ ->Applications->MySQL Administration->Article #10


How can I change my database from MySQL 4 to MySQL 5?


We recommend that you take the following steps to create a new database in
MySQL 5 using the data from your MySQL 4 database.

Please Note; This is only available for shared Linux-based hosting.

1. Export your data from your existing MySQL 4 database.

If you have an extra database in your package, it is best to set up the new
database successfully, before deleting your current database. Otherwise,
please make a backup of your data before starting.

2. Create a new database in the 1&1 Control Panel and select MySQL 5 as the version.

3. Import the data (Restore) from your MySQL database.

Please note: In MySQL version 5, the field type varchar binary is no longer
available. You can find out more about this here MySQL Bug


Find out more...
How can I export a backup of my database using phpMyAdmin?
How can I restore a file exported with phpMyAdmin?

SA1B1303


Print Article
How useful was this article?
(From 5 = Very Useful to 1 = Not useful at all):
1 2 3 4 5


 © 2008 1&1 Internet Inc - About 1&1 Internet