Making Backups by Copying Files
To make an SQL-level backup of a table's contents, you can use SELECT * INTO OUTFILE 'file_name' FROM tbl_name. The file is created on the MySQL server host, not the client host. For this statement, the output file cannot already exist because allowing files to be overwritten would constitute a security risk
Another technique for backing up a database is to use the mysqldump program or the mysqlhotcopy script. mysqldump is more general because it can back up all kinds of files. mysqlhotcopy works only with some storage engines.
Backing Up Replication Slaves
These are some of the simple ways how we can take backup from MySQL database.
Continue Reading the Tutorial Here