Skip to content

Instantly share code, notes, and snippets.

@sajadtorkamani
Last active August 28, 2018 12:55
Show Gist options
  • Save sajadtorkamani/bd09459f6afc29ddae1d0bdd7a9e4f71 to your computer and use it in GitHub Desktop.
Save sajadtorkamani/bd09459f6afc29ddae1d0bdd7a9e4f71 to your computer and use it in GitHub Desktop.
Creating a mysql dump file
Dump database to file

mysqldump -u <username> -p <database> > <dump_filename>

Create database from dump file.
mysql> create database <db_name>;
use <db_name>;
source <absolute_path_to_dump_file>;
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment