How to backup and restore your mysql data

For a single database 

# dumps
mysqldump -u username -p --databases name_of_a_database > ~/db.sql

# tansfer
scp yingshaoxo@192.168.49.132:~/db.sql ~/db.sql

# loads
mysql -u root -p --one-database name_of_a_database < ~/db.sql

For all databases 

You have to make sure that the two of your MySQL software’s version is equal.

# dumps
mysql -u username -p < ~/all_databases.sql

# tansfer
scp yingshaoxo@192.168.49.132:~/all_databases.sql ~/all_databases.sql

# modify
sudo sed -i "s/utf8mb4_0900_ai_ci/utf8mb4_general_ci/gi" /all_databases.sql

# loads
mysql -u root -p < ~/all_databases.sql

​