Importing your MySql database

Portal Home > Knowledgebase > Databases > Importing your MySql database

Below you will find a step by step instruction to import MySql databases as well how to create and associate databases and database usernames.

Login to your cPanel and under Databases, click on MySql Databases.

On that page, create a new database. For example, if you enter dbname, the database name will be yourusername_dbname

Now that you have a database, you MUST associate that database to a username, create a username on that same page. Add new user.

Then go to the bottom of this page, add username to database and assign all privileges for this user to the database

You're done on creating the db, and the username which can access that db.

Now go back to your cPanel main page, under Databases click on phpMyAdmin.

On the phpMyAdmin page, on the left database list, click on the database which you just created from the above steps

Then, on the top menu, click Import. Select your sql file to load, and click the Go button

Voila! You just successfully imported your database

You can now access that database from your application or scripts, using the database host localhost, and the database name and username which you created on the above steps.

Keywords: mysql, creating mysql database, creating mysql user, mysql username, mysql access

Add to Favourites Print this Article