Skip to content

Instantly share code, notes, and snippets.

@mlbd
Last active April 13, 2019 08:10
Show Gist options
  • Save mlbd/382ebce19d027c6303cb743ba0cdb1db to your computer and use it in GitHub Desktop.
Save mlbd/382ebce19d027c6303cb743ba0cdb1db to your computer and use it in GitHub Desktop.
First go the mysql folder where your localhost install. in my case I'm using xampp.
In reqular xampp password will be blank as default unless you set something. If it is blank then you can just leave as blank like
--password=
========================
1. cd C:\xampp\mysql\bin
2. mysqldump --user=root --password=password mydbname > mydbname-backup.sql
========================
Backup file will be avaliable in C:\xampp\mysql\bin folder.
For more info visit.
https://learntech.imsu.ox.ac.uk/blog/mysqldump-all-databases-from-xampp-on-windows/
https://stackoverflow.com/a/13484728
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment