How to export or import a database using phpMyAdmin?

Whether you need to back up your database, move your website to another server, or restore a previous version, you can easily export or import your database through phpMyAdmin in cPanel. This built-in tool offers a user-friendly interface that enables you to manage your database with just a few clicks — no advanced technical skills are required.

 

 

1. Export a database

1. Access cPanel directly through your Z.com account.

2. Once you have reached the cPanel dashboard, locate phpMyAdmin under Databases.

3. Upon being redirected to the phpMyAdmin homepage, a list of available databases will be displayed once you expand the username on the left sidebar by clicking on the + button.

4. Select the name of the database you would like to export and click Export at the top.

5. Choose the Export method (Quick: exports the entire database with default settings, or Custom: allows you to select specific tables and options) and ensure the format is set to SQL. Once done, click Export.

6. Done! Your database will download as a .sql file to your computer. Depending on the size of the database, the downloading may take some time.

2. Import a database

1. Access cPanel directly through your Z.com account.

2. Once you have reached the cPanel dashboard, locate phpMyAdmin under Databases.

3. Upon being redirected to the phpMyAdmin homepage, a list of available databases will be displayed once you expand the username on the left sidebar by clicking on the + button.

4. Select the name of the database you would like to import and click Import at the top.

5. Under the File to import section, click Choose file and select the .sql file from your computer that you wish to import.

6. Ensure the format is set to SQL. Once done, click Import.

7. Done! This will import your .sql file for you.