phpmyadmin Question posted in
The official documentation can be found here.

how to export all databases as separate sql files instead of localhost.sql – Phpmyadmin

I want to export all databases as separate .sql files but I get localhost.sql Can anyone here show me how we can accomplish this?

Tags:

2

Answers


  1. 0
    1. Log into phpMyAdmin.
    2. Select the source database on the left pane.
    3. Click on the Export tab in the top center pane.
    4. On the next page you must select a Quick or Custom export method. …
    5. From the dropdown menu, choose the format you’d like to save the file as. …
    6. Click the Go button to continue.
    7. A pop-up displays allowing you to download the file. (Note: your browser may also download it automatically.)

    For more check Check this steps Maybe you should probably be searching well on Google

    Login or Signup to reply.
  2. 0 
    mysqldump -u root -p --all-databases > alldb.sql

    Look up the documentation for mysqldump. You may want to use some of the options mentioned in comments:

    mysqldump -u root -p --opt --all-databases > alldb.sql

mysqldump -u root -p --all-databases --skip-lock-tables > alldb.sql
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search