You are Here: FAQ ->Scripting and Programming Languages->MySQL Database->Article #10


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


For Linux packages only!Linux Packages Only!
      This includes:
          arrow 1&1 Beginner (Linux)
          arrow 1&1 Home (Linux)
          arrow 1&1 Business (Linux)
          arrow 1&1 Developer (Linux)
          arrow 1&1 Dedicated Website Servers (formerly called managed servers)





If you still have old remaining MySQL4 databases, we recommend that you take the following steps to create a new database in MySQL 5 using the data from your MySQL 4 database.

Step 1:

Create a new database in the 1&1 Control Panel. All newly created databases should be MySQL5.

For help creating a new database, reference - How do I create a new MySQL database?
Step 2:

Export your data from your existing MySQL 4 database. Exporting data can be done two ways:

How can I export a backup of my database using phpMyAdmin?
How can I backup my MySQL database using SSH?
Step 3:

Import the data from your MySQL4 database into the newly created MySQL5 database. Importing data can be done two ways:

How do I import a MySQL database using phpMyAdmin?
How do I import a MySQL database using SSH?


Please note: In MySQL version 5, the field type varchar binary is no longer available. More information regarding changes from MySQL4 to MySQL5 can be found at MySQL :: MySQL 5.0 Reference Manual :: Upgrading from MySQL 4.1 to 5.0


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