Difference between revisions of "How to dump/restore MySQL Databases"
| (One intermediate revision by the same user not shown) | |||
| 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 | ||
| + | |||
| + | ==Change Wordpress Password== | ||
| + | USE database_wp; | ||
| + | UPDATE wp_users SET user_pass = MD5('newpassword123') WHERE user_login = 'admin'; | ||
| + | EXIT; | ||
| + | |||
| + | ==Dump single Database== | ||
| + | |||
| + | |||
| + | ==Restore single database== | ||
| + | mysql -u root -p database_wp < database_wp.sql | ||
Latest revision as of 23:02, 10 June 2025
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
Change Wordpress Password
USE database_wp;
UPDATE wp_users SET user_pass = MD5('newpassword123') WHERE user_login = 'admin';
EXIT;
Dump single Database
Restore single database
mysql -u root -p database_wp < database_wp.sql
