How to Import a Database with phpMyAdmin

In some situations, you may need to import a MySQL database from another server into your web hosting account with WHC.

To import a database into your account:

  1. You should have a copy of the database you need to import, in SQL format. You can normally obtain such a copy by exporting your database from your source server. You can also compress your SQL file into a ZIP format to make it smaller and easier to work with.
  2. Sign in to your cPanel account at Web Hosting Canada
  3. If you have not already done so, create a new database with the MySQL Database Wizard
  4. Once the database is created, return to the cPanel and click on phpMyAdmin
  5. Choose the desired database and click on the Import tab
  6. Browse your computer for the SQL (or ZIP) file that contains your database and click GO
  7. Wait for the process to complete. The database should now be imported into your account! 

Once uploaded, you can browse and manipulate data within your database by using a database management tool such as phpMyAdmin.

Was this answer helpful?