forum

Home / DeveloperSection / Forums / How to restore backup file in MySQL database?

Ask Question

How to restore backup file in MySQL database?

Pravesh Singh371012-Mar-2012
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!!
mysqlmysql 
Updated on 12-Mar-2012
Pravesh Singh

Pravesh Singh

Follow
Student

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

12-Mar-2012
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.

Liked By