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

Total Post:411

Points:2881
Posted on    March-12-2012 1:58 AM

 MYSQL MYSQL 
Ratings:


 1 Reply(s)
 2152  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

Points:476
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 ;

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.

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

Follow MindStick