Home > DeveloperSection > Forums > How to restore backup file in MySQL database?
Pravesh Singh

Total Post:412

Posted on    March-12-2012 1:58 AM


 1 Reply(s)
 2431  View(s)
Rate this:
Hello Everyone,
I'm facing a problem in restoring backup file in MySQL database. So can anyone help me how to solve this problem.

Thanks in advance!!

Arun Singh

Total Post:68

Posted on    March-12-2012 8:10 AM

Hi Pravesh Singh,
To restore MySQL database backup file,  you have just use LOAD DATA INFILE query like this...

Query: LOAD DATA INFILE '$backupFile' INTO TABLE $tableName ;

$backupFile -> is backup file name with path.
$tableName -> is table name in which you will load or insert data.

I hope it will be solve your problem.

Don't want to miss updates? Please click the below button!

Follow MindStick