Re: Migrating 4.1 database to 5 on Godaddy
Hi James D,
Your best bet is going to be to create a backup of your 4.1 database using the Hosting Control Center (where you created the database from the get-go).
Hosting Control Center --> Databases --> MySQL --> Pencil Icon Next to Database --> Backup --> OK
This backup file will be stored in a /_db_backups directory on the corresponding hosting account and will be named after the name of your database, i.e. [databasename].sql
Once this is done (you can check on the status where it lists your database, it will say Pending Backup if it's still working), click the "Create Database" button to make your new 5.0 database. Make sure you select the 5.0 button.
When this new database is created, click the pencil icon to the right of it, just like you made the backup. This time, select the "Restore" option, and click the radio button for the backup file you made from your other database. Then click "Restore". This will import the backup you made into your new database.
Unfortunately, we don't have functionality in place to simple upgrade the version, as there are separate servers running 4.1 and 5.0 instances. As it stands, you will need to create a brand new 5.0 database and import the data from the older version using these directions.
Make sure, when you are done, that you go into the configuration file for your application and change the database connection information to reflect the new server, database name, username, and password. Usually a "config.php" file somewhere.
-Dan-
Legals:
The views expressed on this website/weblog are mine alone and do not necessarily reflect the views of GoDaddy.com, Inc. or its affiliates.