MySQL Database Backup and Recovery Tips!!!!

Tip #1
Making Backups by Copying Files

Tip #2
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

Tip #3
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.

Tip #4
Backing Up Replication Slaves

These are some of the simple ways how we can take backup from MySQL database.

Continue Reading the Tutorial Here

No comments: