Difference between revisions of "How to dump/restore MySQL Databases"
| (One intermediate revision by the same user not shown) | |||
| 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 | ||
| + | |||
| + | 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
