Skip to content
Host4u Limited

phpMyAdmin: opening, exporting, importing and repairing

Support Portal  »  Knowledgebase  »  Viewing Article
There was a problem loading the comments.
  Print

phpMyAdmin lets you work with the data in your MySQL databases in your browser. In cPanel, open phpMyAdmin in the Databases section. It logs you in automatically and shows your databases on the left.

Always export a copy of a database before you change or delete anything in it.

Exporting a database (backup or move)

  1. Click the database on the left.
  2. Click the Export tab.
  3. Leave the method as Quick and the format as SQL, and click Export.

The file downloads to your computer.

Importing a database

  1. Create an empty database first if you need one (see Databases: creating a database and user).
  2. In phpMyAdmin, click the database on the left.
  3. Click the Import tab, choose your .sql file and click Import.

Seeing how big a database is

Click the database on the left: the list of tables shows the size of each table, with the total at the bottom. Your cPanel home page also shows Database Disk Usage.

Repairing a database

If your website reports a crashed or corrupt table, open Manage My Databases in cPanel, choose the database under Repair Database and click Repair Database. You can also check a database for errors there with Check Database.

Deleting a table

  1. Click the database on the left.
  2. Tick the table, choose Drop from With selected, and confirm.

This cannot be undone: export the database first.


Share via
Did you find this article useful?  

Related Articles


Self-Hosted Help Desk Software by SupportPal