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