Take multiple database backup at once on localhost :

Step : 1
Open to http://localhost/phpmyadmin

Step : 2
click on to Export tab

Step : 3
In Export method, choose 'Custom - display all possible options' and select the database you want to export if not all.

Step : 4
Scroll below and in Object creation options Make sure you select

Step : 5
Add CREATE DATABASE / USE statement
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement

Step : 6
Click Go and Let all you table be saved in default download folder or select it manually.
Default File name would be 127_0_0_1.sql Make sure you open this file with text editor and verify if sql command is correct, at least for first database and first table. it should be backed up now. If having any Problem in doing so, please leave comment below to ask.


- Nikhil Bhalerao
Software engineer at Freelance IT Developer / Programmer / Software Engineer / Coders

For any Professional Software Development, Website Development, Mobile Apps Development at affordable cost contact me at