Today I tried to move one of my websites to a new domain. I ftped the data to the new hosting account without a problem, however creating a new MySQL database was a bit tricky. Remember opening phpMyAdmin on a fresh hosting account will not give you the option of creating a new database, because you have not created any database on that account as yet and also have not created a user for the database. Here is how the phpMyAdmin will look like in a freshly created hosting account:

You see the “create new database” option gives a warning “No Priviliges” under it. Now what you do, your “Create new MySQL database using phpMyAdmin” doesn’t give you any clue here! Well you go to your control panel home page and under “Databases” you will see the option of “MySQL Databases”, click on that and create a new database.

The database you just created will be displayed in the left hand column of phpMyAdmin now. Click on the DB you just created. On top menu select import, browse for your Database backup file and hit “Go” . Here you go, you old DB is imported to your new hosting account.

This entry was posted on Friday, November 6th, 2009 at 7:07 am and is filed under Website Help. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.