# PhpMyAdmin database backup

Databases can be saved from the [P](http://fr.wikipedia.org/wiki/PhpMyAdmin)[hpMyAdmin](http://fr.wikipedia.org/wiki/PhpMyAdmin) interface, connecting using the login and password created during the [LAMP](http://fr.wikipedia.org/wiki/LAMP) server installation, the database installation, or in the data transmitted by your hosting provider.

![](https://748165138-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LH9CCYPqjHw1VKNcuiq%2F-LH9CGn0ncN_3G09lrQH%2F-LH9DGBU9kxCa2uhzaYb%2Fphpaccueuil.png?generation=1531327467339996\&alt=media)

*Illustration: Administration - PHPMyAdmin*

Once in the graphical interface of PhpMyAdmin, go to the \_Export\_tab and select the database to be saved. There's probably another one called “information\_schema”, which you can just ignore.

You may want to change the output format of the backup file. To save, choose on the desired format below the databases to export. In the present example we chose SQL.

The name of the saved file can also be changed in the *Output* section. It can be compressed using one of the three offered formats. Do not forget to select the *Save output to a file* option, otherwise it will just print the backup result on screen, which will not really help you.

You're only left with downloading the file. It will be saved by default in your *Downloads* directory or on your desktop, depending on your browser's configuration.

Saving the databases through *hpMyAdmin* is over. The saved file will be to the SQL format (.sql extension) and will be importable later on, in case of problem, through PhpMyAdmin.