stars building 1 stars building 2 stars building 3
title
Register your
or
domain with us
price
*T&CS APPLY
Find Out More
24/7 Australian Sales & SupportCall 13 24 85
View all Products Close Menu Menu
Importing and exporting MySQL tables using phpMyAdmin
Updated Friday December 11th 2020 / Category MySQL

Import a MySQL database

  1. Log in to your cPanel service.
  2. Click the phpMyAdmin icon.
  3. Using the left menu of phpMyAdmin, select the database you wish to import your data to.
  4. Now that you’re viewing the particular database, click the Import tab.
  5. There you will click Browse to select the file to upload, select the appropriate character set (if in doubt, leave as utf-8) and tweak the additional settings if required; then click Go.
  6. The file will then be imported, perhaps taking some time depending on file size; the outcome of the import will then be confirmed to you.

If your database is quite large (in excess of 50MB) you cannot import this manually through phpMyAdmin. Instead, upload it through cPanel’s Backup Wizard tool.

Export a MySQL database

  1. Log in to your cPanel service.
  2. Click the phpMyAdmin icon.
  3. Using the left menu of phpMyAdmin, select the database you wish to export.
  4. Now that you’re viewing the particular database, click the Export tab.
  5. Choose your export method (Quick is generally the norm) and select the format to export it as (typically SQL); then click Go.
  6. This will give you a download prompt confirming where to download it to on your computer.
Can’t find the answers you're looking for? Check out these other methods of support!