Difference between revisions of "How to dump/restore MySQL Databases"
| Line 4: | Line 4: | ||
Import A MySQL Database: | Import A MySQL Database: | ||
mysql -u username -ppassword database_name < FILE.sql | mysql -u username -ppassword database_name < FILE.sql | ||
| + | |||
| + | Use the --all-databases option to back up all the MySQL databases: | ||
| + | mysqldump -u root -p --all-databases > all_databases.sql | ||
Revision as of 05:12, 22 January 2021
Export A MySQL Database:
mysqldump -u username -ppassword database_name > FILE.sql
Import A MySQL Database:
mysql -u username -ppassword database_name < FILE.sql
Use the --all-databases option to back up all the MySQL databases:
mysqldump -u root -p --all-databases > all_databases.sql
