Using phpMyAdmin to Manage Databases Print

phpMyAdmin is a tool that lets you manage MySQL databases through a web browser.

Accessing phpMyAdmin

1. Log into cPanel.
2. In the Databases section, click phpMyAdmin.

Common Tasks

Back up a database:

1. In phpMyAdmin, click on the database name from the left sidebar.
2. Click the Export tab at the top.
3. Choose Quick export method and SQL format.
4. Click Go to download the backup.

Import a database:

1. In phpMyAdmin, select the database from the left sidebar.
2. Click the Import tab.
3. Click Choose File and select your .sql file.
4. Click Go to run the import.

Run an SQL query:

1. Click the SQL tab.
2. Enter your query in the text area.
3. Click Go to execute.

Warning: Be careful when editing or deleting data in phpMyAdmin. Wrong changes can break your website. Always back up first.