Export and import database via phpMyAdmin

Some websites require database backup especially the ones that were transferred or migrated. Please follow the instructions below for you to export and import database  through the phpMyAdmin.

Export Database via phpMyAdmin

Step 1. Log in to the cPanel.

import database

Step 2. Click on phpMyAdmin under Databases panel.Import and export database

Step 3. If you have multiple databases, select the database you want to export.

select-database-export

Step 3. Click Export tab.

export-phpmyadmin

Step 4. If you want to export the database right away, select Quick and click Go button and the SQL file will be downloaded directly to your computer. However, if you want to have a custom export, select Custom to display all export options.export-method-database

Step 5. Select the database tables you want to export. If you wish to export all the tables, click Select All.       select-table-export

Step 6. Select the file format depending on what type of file you want to save and use. By default, SQL is chosen. You may also check the Format-specific options.format-database-exportselect-format-sql-export

Step 7. Name the file. It would be easier if you use the database name and date you exported it.output-database-export

Step 8. Modify the Object creation options. If you are unsure, leave the default options.object-creation-options-export-database

Step 8. Check the Data creation options. If you are still unsure what to select, leave the default options.click-go-export-database

Step 9. Click Go button and the file will be downloaded to your local computer or drive.

Import database via cPanel

Step 1. Log in to the cPanel.

import database

Step 2. Click on phpMyAdmin under Databases panel.Import and export database

Step 3. If you have multiple databases, select the database you want to use.

php3

In this article, the example is testdomain_wordpress.

php4

Step 4. Click on Import button.import1

Step 5. Click on Choose file button. Select the SQL file from your local computer or external drive. Click GO button to start the import process.import2

Another option is using the  Query Window in the phpMyAdmin page.

 

Step 1. Choose the database and click on the Query window button.

import4

Step 2. Click on Import files tab.

 

Step 3. Click on Choose file button. Select the SQL file from your local computer or external drive. Click GO button to start the import process.

import5

Do not hesitate to contact our support team if you have further questions.

Export and import database

 

 

(Visited 222 times, 1 visits today)