Guides and tutorials

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

How to import and export BBDD

Importing the DB with phpMyAdmin

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

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

enter image description here

2. Then click Database Management.

enter image description here

3. Here you will be able to view the existing databases. In case you do not have any database created, you must create one to be able 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 carried out on the database in which you want to import the data:

enter image description here

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

enter image description here

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

enter image description here

To import the database you must follow the following steps:

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

2) Once you have selected the DB to import you must press the button Continue

enter image description here

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

enter image description here

DB export with phpMyAdmin

To export a database, you must follow the following steps:

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

enter image description here

2. Then click Database Management.

enter image description here

3. Here you will be able to view the existing databases. Go to the "[...]" menu and then select Open PhpMyAdmin. This action must be carried out on the database in which you want to export the data:

enter image description here

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

enter image description here

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

enter image description here

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

enter image description here

7. Your browser will download your website's database in database_name.sql format to your downloads folder.

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.
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.