phpMyAdmin is a visual tool for managing your MySQL databases, letting you browse tables, run queries, and import or export data. This guide explains how to reach and use it in cPanel.
Opening phpMyAdmin #
- Log in to cPanel.
- In the Databaser section, click phpMyAdmin.
- Your databases appear in the left panel.
Finding your way around #
- Left panel: lists databases and tables.
- Structure: shows tables and columns.
- Browse: view and edit rows.
- SQL: run queries directly.
Exporting (backup) #
- Select the database.
- Click Export, choose Quick and SQL.
- Click Go to download the .sql file.
Importing #
- Select the target database.
- Click Import, choose your .sql file, and click Go.
Safety tips #
- Always export a copy before making changes.
- Confirm which database you are editing.
- Avoid dropping tables unless certain.
Troubleshooting #
- Import too large: compress the file or split it.
- Site errors after edits: restore your exported copy.
Need help? #
If you are unsure about a database change, contact support before proceeding.
