Python-dev drafts. Blog with tutorials for Python developers.
10/16/15
Back Up MySQL Databases From The Command Line
Creating A Backup
mysqldump database_name > database_name.sql
mysqldump --databases database_1 database_2 > two_databases.sql
mysqldump --all-databases > all_databases.sql
Restoring a Backup
mysql database_name < database_name.sql
mysql --one-database database_name < all_databases.sql
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment