backup whole MySQL database with all users and permissions and passwords

電腦小知識

# typical mysql dump backup and restore usage

mysqldump -u root -pPassword -x –all-databases > db_dump.sql

mysql -u root -pPassword < db_dump.sql

, ,