Export and Import Database in PhpMyAdmin

When developing applications, it is often necessary to transfer not only the written code to a new environment, but also the associated DB. In order not to rewrite all the data from scratch, the existing DB can first be exported and then imported into the new development environment. Let's figure out how to do this.

Example . Export DB

Let's go to our database by clicking on its name in the left sidebar. Then open the Export tab:

Next, select the quick export method and the .sql format. To confirm the export, click the Export button:

Example . Import DB

Now let's import the saved database. To do this, go to the Import tab:

Next, in the File to import section, select the file we need located on our computer. To do this, click the Choose File button:

For a simple database import, leave all the default settings and at the end click on the Import button:

Practical tasks