phpMyAdmin is a graphical interface for managing MySQL databases via browser. Convenient for viewing data, export, SQL import, manual edits.
How to open:
cPanel → “Databases” section → phpMyAdmin. A new tab opens.
Main operations:
- View table — click the database on the left, then the table.
- SQL query — SQL tab, write query, execute.
- Export — pick database → Export tab → method Quick, format SQL → Go. Dump downloads.
- Import — Import tab → pick .sql file → Go. Good for restore.
- Search — Search tab, searches all tables in the DB.
Tip: backup before changes
Before major edits always export the DB — that is your backup. If something breaks, restore via import.
Limits:
- Interface upload — up to 50–100 MB. For larger dumps — via cPanel Backup Wizard or SSH.
- Long queries (>120 sec) are cut by PHP timeout.