March 19, 2018
MySQL backup and restore from command line

Go to start -> Run -> write CMD, then right click on Command Prompt icon and click on Run as administrator Navigate to the “bin” directory of your mysql Backing up via the command line Type the following command at the prompt replacing USERNAME and DATABASE with the one you use: A:\xampp\mysql\bin>mysqldump -a -u USERNAME