How to take the backup of complete data including all the databases in the MySQL Server?
Is there one command to take the full backup of data in sql format of MySQL Database?
My MySQL Server version is 5.5.23.
To take the backup of all the database on a MySqL Server you use the mysqldump tool.
You have to logon to the server where MySQL is running and use the following command on console:
mysqldump --all-databases > all_databases.sql