Created
May 4, 2016 12:01
-
-
Save panagiotisTB/72f06c4c8fd3ad4ed33c804694a630e5 to your computer and use it in GitHub Desktop.
Create MySQL dump and import it to another database
This file contains 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 dump as .sql | |
| mysqldump -u [username] -p [database_name] > [dump_name].sql | |
| # Enter database password | |
| # Import dump to new databse | |
| mysql -u [username] -p -h [databse_host] [database_name] < [dump_name].sql | |
| # Enter database password |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment