Sponsored By
DataConverter
Advertise with Us
Advertisement
Advertise with Us
Follow Us
Follow _MindStick_ on Twitter View MindStick Software's LinkedIn profile View MindStick Software's Facebook profile
Mindstick
Article Article  Forum Forum  Blog Blog  Quiz Quiz  Beginner Beginner  Careers Careers  Contact Contact  Login Login  
Home | Product | Services | About Us | Interview | DeveloperSection | Submit an Article | Submit Blog
Report Abuse Form
Reason:    
   
Home >> Database >> MYSQL >> How to restore backup file in MySQL database?
Author Post

Pravesh Singh

Total Post: 38
Member Since: 12/12/2011
Points: 198
How to restore backup file in MySQL database?
Posted On: 3/12/2012 1:58:49 AM
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!!
Author Post

Arun Singh

Total Post: 48
Member Since: 7/1/2011
Points: 331
Re: How to restore backup file in MySQL database?
Posted On: 3/12/2012 8:10:38 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.
Report Abuse Form
Reason:    
 
Total Online Users: 7020
Advertisement
MindStick DataConverter
Advertise with Us
  
Copyright © 2009 - 2013MindStick. All Rights Reserved.