Using mysqldump Using 'mysqldump' command you can take the mysql database backup. This command all the datas to a text file. The syntax is shell> mysqldump [options] db_name [tables] shell> mysqldump [options] –databases db_name1 [db_name2 db_name3…] shell> mysqldump [options] –all-databases Backuping ...