HOW TO RESTORE BACKUP FILE IN MYSQL DATABASE?

Pravesh Singh

Total Post:412

Points:2888
Posted by  Pravesh Singh
MYSQL 
 2454  View(s)
Ratings:
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!!
  1. Arun Singh

    Post:68

    Points:476
    Re: How to restore backup file in MySQL database?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!