Advertise with us

How to restore backup file in MySQL database?

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!!
Last updated:3/12/2012 8:10:38 AM

1 Answers

Arun Singh
Arun Singh

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 ;

Where,
$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.

Last updated:3/12/2012 8:10:38 AM

Answer