Difference between revisions of "How to dump/restore MySQL Databases"
| Line 7: | Line 7: | ||
Use the --all-databases option to back up all the MySQL databases: | Use the --all-databases option to back up all the MySQL databases: | ||
mysqldump -u root -p --all-databases > all_databases.sql | mysqldump -u root -p --all-databases > all_databases.sql | ||
| + | |||
| + | Update version: | ||
| + | https://phoenixnap.com/kb/how-to-backup-restore-a-mysql-database | ||
Latest revision as of 13:27, 25 April 2024
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
Update version:
https://phoenixnap.com/kb/how-to-backup-restore-a-mysql-database
