Difference between revisions of "How to dump/restore MySQL Databases"

From HyperSecurity Wiki
Jump to: navigation, search
 
 
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

Latest revision as of 22:12, 21 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