· Tutorial ·

How to import and export databases with phpMyAdmin

Importing the database with phpMyAdmin

To import your web database to your new hosting in SWPanel you will have to follow the following steps:

1. First of all, you must access your SWPanel and in the top search window indicate the name of the hosting service you want to configure. Once you have located the service, you can click on its name to access its Dashboard:

enter image description here

2. Next, click on Database Management.

enter image description here

3. Here you can view the existing databases. In case you do not have any database created, you will have to create one in order to import the data. Once the database is created, go to the menu "[...]" and then select Open PhpMyAdmin. This action must be performed on the database where you want to import the data:

enter image description here

4. Once the phpMyadmin tool has opened in your browser, you must enter the User and Password of your website's database and click on the Continue button.

enter image description here

5. Next, select the database into which you want to import the data and go to the Import tab.

enter image description here

To import the DB you must follow the following steps:

1) Use the Examine... button to open your file browser and select the DB with the .sql extension that we exported and saved previously with the phpMyAdmin.

2) Once you have selected the database to import, you must click on the Continue button.

enter image description here

3) Once the DB import process has been successfully completed, the window will change and will show you the message Import successfully executed. In addition, you will be able to see that the corresponding tables and fields have been generated:

enter image description here

Database export with phpMyAdmin

To export a database, you must follow these steps:

1. First, you must access your SWPanel and in the top search window indicate the name of the hosting service you want to configure. Once you have located the service you can click on its name to access its Dashboard:

enter image description here

2. Next, click on Database Management.

enter image description here

3. Here you can view the existing databases. Go to the menu "[...]" and then select Open PhpMyAdmin. This action must be performed on the database where you want to export the data:

enter image description here

4. Once the phpMyadmin tool has opened in your browser, you must enter the User and Password of your website's database and click on the Continue button.

enter image description here

5. Once inside, you must select the DB corresponding to your website and then go to the Export tab.

enter image description here

6. In the next window you must leave the default options checked and then click on the Continue button.

enter image description here

7. Your browser will download your web database in database_name.sql format to your download folder.

i