Created
March 6, 2016 21:12
-
-
Save maximishchenko/2c76325b136b15722a73 to your computer and use it in GitHub Desktop.
mysql_dump_db_or_tables
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Export to file (Full Database or custom tables) data only | |
| mysqldump -u[username] -p[password] --no-create-info [dbname] [table_n1, ... , table_n] > [filename].sql | |
| # Export to file (Full Database or custom tables) structure only | |
| mysqldump -u [username] -p[password] --no-data [dbname] [table_n1, ... , table_n] > [filename].sql | |
| # To import to database from file | |
| mysql -u [username] -p[password] [dbname] < [filename].sql |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment