How do I administer my MySQL database?

To administer/manage your MySQL database we provide the popular program phpMyAdmin. The program works via a web browser and allows for creating and editing databases and database tables, executing SQL statements and much more.

To use phpMyAdmin, first log in to your cPanel:

Once logged in, towards the bottom of the page click on phpMyAdmin

The phpMyAdmin program will now be shown. On the top left of the page you will see a listing of your MySQL databases. You will also notice a database shown called information_schema. This is a system database and can be ignored. It does not count against your number of databases you are using. To view a database and it's tables and content, click on the database name you wish to view on the top left of the page.

The database will now be shown and you will see a listing of the database tables in the middle of the page.

To browse the fields and records of a table click on the table name under the database name at the top left of the page. The page will be shown as below.

To export/dump/backup a database, click the database name at the top left of the page, then click on Export towards the top middle of the page.

The export page will now be shown. You can leave all the settings as they are for a basic export of your database. Make sure all the tables are selected as you most likely will want to export your entire database including all it's tables. Towards the bottom of the page click on Export. An export of your database in .sql format will now be downloaded to your PC.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I backup my site?

To backup your website, or parts of it (Home Directory, MySQL etc) first log in to your cPanel:...

How do I use the File Manager?

From within cPanel you can access your online File Manager. This allows you to manage the...

How do I create a MySQL database and user?

Below is a guide to creating a MySQL Database. MySQL databases are used by many web applications...

How do I view my website statistics?

We provide several different statistics programs within cPanel for you to view and analyse your...

How do I password protect a directory?

From within cPanel you can password protect a folder. This allows you to require a username and...