Guides and tutorials

Hundreds of tutorials and step by step guides carefully written by our support team.

How to import and export databases with phpMyAdmin

Importing the database with phpMyAdmin

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

1. First of all, you must access your SW Panel 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 into the new database. 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 SW Panel 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.

More than 2000 m² of own facilities and Data Centers in Spain
Your privacy is important for us
We use our own cookies for the proper functioning of the site. In addition, third-party cookies are used for analytical purposes only. This information is not associated with any person so that personal identifying data is not stored, but is only information that is collected to identify the session, with the aim of facilitating the analysis of the website. You can change your preferences at any time by entering this website again. For more information about our cookie policy you can visit our Cookies. You can press the "Accept and close" button to give us your consent or you can access more detailed information and manage cookies.
More than 2000 m² of own facilities and Data Centers in Spain
Your privacy is important for us
We use our own cookies for the proper functioning of the site. In addition, third-party cookies are used for analytical purposes only. This information is not associated with any person so that personal identifying data is not stored, but is only information that is collected to identify the session, with the aim of facilitating the analysis of the website. You can change your preferences at any time by entering this website again. For more information about our cookie policy you can visit our Cookies. You can press the "Accept and close" button to give us your consent or you can access more detailed information and manage cookies.