How to make a copy (manually also possible) of a MySQL database on Centos 6?

Question

MySQL

You can just write a command for SSH access that will copy the database from def. name.

Answer 1

mysqldump -u root -p --all-databases > backup.sql
mysqldump database_name > database_name.sql
mysqldump --databases database_one database_two > two_databases.sql