How to dump/restore MySQL Databases - Revision history

Srapaz at 23:02, 10 June 2025

2025-06-10T23:02:47Z

Srapaz at 13:27, 25 April 2024

2024-04-25T13:27:31Z

Srapaz at 05:12, 22 January 2021

2021-01-22T05:12:18Z

70.79.79.234 at 22:08, 8 July 2013

2013-07-08T22:08:22Z

New page

Export A MySQL Database:
mysqldump -u username -ppassword database_name > FILE.sql

Import A MySQL Database:
mysql -u username -ppassword database_name < FILE.sql

←Older revision		Revision as of 23:02, 10 June 2025
Line 10:		Line 10:
	Update version:		Update version:
	https://phoenixnap.com/kb/how-to-backup-restore-a-mysql-database		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

←Older revision		Revision as of 13:27, 25 April 2024
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

←Older revision		Revision as of 05:12, 22 January 2021
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