best option Restore Database

Mysql Restore From Backup

A MySQL backup is a copy of a MySQL database that is made for the purpose of data protection. A backup can be used to restore the database to its original state if it is corrupted or to recover data if it is lost.

MySQL provides a number of methods for creating backups. The most basic method is to make a copy of the database files. This can be done using the cp or rsync commands. The mysqlhotcopy utility can …