Website Transfer(Part-4, Creating new mysql database)

If you read my previous posts, Now you know how to make a website files and database back and learned about files and folder upload. Here I will show you the final step "Backup Database upload and Configure."

To Upload your old database to your new hosting for your website your have to create a new database first.

• Log in to your cPanel and go for the "MySQL® Database Wizard" Button on the "Database" Section of your cPanel.
• In "MySQL® Database Wizard" You have to provide a name of your new database. Remember if you have more than one website and database its better to give your database your website related name. So that in future your will not get confused with your database.

MySQL® Database Wizard

 

• After naming your database "ontest" you have to go to the next window. There your have to provide a username and password for your database. (Password can be created automatically). Just follow the below picture....

MySQL® Database Wizard for user name and password

• After creating Database user and password than comes User PRIVILEGES section. You have to provide User PRIVILEGES here. Its better if you using your own website and database select "All PRIVILEGES"  so that you will get the full control of your database and website.

Database User PRIVILEGES

Now your have successfully created your new Database. Before going to the next step please save your database name, database user name and database password in a notepad file. To configure your uploaded database it will require.

Please follow my next article, there I will show your "Backup Database upload and Configure."