MySQL - creating backup

Simplest solution is to use mysqldump tool.

• To create backup of a specific database (database_name):
  
  
mysqldump -u root -p database_name > dumpfile.sql

  and enter your root password.
  


• To backup all databases:
  
  
mysqldump -u root -p --all-databases > dumpfile.sql