Search code examples
phpmyadmin

How to export all the databases with phpmyadmin

Can I export all the databases with one-go using phpMyadmin?

If not what is the best way to do it?

Thanks in advance.

Solution

  • If you login as the root user, you should be able to select every database you want to backup, then export it from there.

    1. Open your PHPAdmin site in a web browser.
    2. Click on the "Export" tab enter image description here
    3. On the export page select the database you wish to backup or select all using the controls above the input field. enter image description here
    4. Then configure any options you would like to have. I highly suggest you read the documentation to determine exactly what you options you should use. You can read more about the options in the phpMyAdmin documentation
    5. Click go enter image description here