How to Access phpMyAdmin in cPanel
Step 1: Log in to your Cpanel Account
Step 2: Locate phpMyAdmin
- Once logged in, scroll down to the Databases section on your cPanel dashboard.
- Click on the phpMyAdmin icon.
Step 3: Access phpMyAdmin Interface
- After clicking on phpMyAdmin, a new tab or window will open, taking you to the phpMyAdmin interface.
- From here, you can manage your MySQL databases, including running SQL queries, managing tables, and more.
How to Import/Export a Database in cPanel Using phpMyAdmin
Step 1: Access phpMyAdmin
- Follow the steps above to log in to cPanel and access phpMyAdmin.
Step 2: Select the Database
- In the phpMyAdmin interface, select the database you want to import data into from the left-hand sidebar.
Step 3: Import the Database
- Click on the Import tab at the top of the phpMyAdmin interface.
- Click the Browse button and select the SQL file from your local computer.
Note: If the SQL file is large: Before clicking the Browse button, make sure your SQL file has been compressed into a ZIP archive to facilitate a smoother upload. The file should have a .sql.zip extension (e.g., backup.sql.zip).
- Ensure the format is set to SQL.
- Click the Go button to start the import process.
- Wait for the process to complete. A success message will be displayed if the import is successful.
How to Export a Database in cPanel Using phpMyAdmin
Step 3: Export the Database
- Click on the Export tab at the top of the phpMyAdmin interface.
- Choose the export method: Quick: Exports the entire database with default settings. Custom: Allows you to customize what gets exported, such as specific tables, file formats, and compression options.
- Ensure the format is set to SQL.
- Click the Go button to download the exported database to your local computer.
- Wait for the process to complete. A success message will be displayed if the export is successful.
This is how you can access the phpMyAdmin from cPanel and import/export the databases.