How to Import or Export a Database using cPanel Print

Sometimes you may need to export a database from or import a database into your web host. Here’s how you can do both using the phpMyAdmin web application.

Exporting a Database via cPanel:

1. Log in to your hosting account's cPanel or similar interface.
2. Click on the phpMyAdmin icon.
3. Select the database you want to export from the list on the left.
4. Go to the Export tab.
5. Choose the Quick export method to export the entire database, or select Custom to pick specific tables.
6. Set the format to SQL, click Go, and then save the file to your local drive.

You now have a SQL dump of your database for future import.

Importing Data into a Database via cPanel:

1. Create a SQL file by exporting data as described above or obtain it from another source.
2. If the SQL file exceeds 2MB and is not compressed, compress it into a zip file.
3. If you need to create a new database or remove existing tables, refer to relevant instructions on how to set up or clean up a database.
4. Log in to your hosting account's cPanel (or similar interface).
5. Click on the phpMyAdmin icon and go to the Import tab.
6. Click on the Choose File button to select your compressed SQL file.
7. Ensure the format is set to SQL, then click Go.

Your data will be imported into the database.