---
title: "How to restore backup file in MySQL database?"  
description: "How to restore backup file in MySQL database?"  
author: "Pravesh Singh"  
published: 2012-03-12  
updated: 2012-03-12  
canonical: https://www.mindstick.com/forum/392/how-to-restore-backup-file-in-mysql-database  
category: "mysql"  
tags: ["mysql"]  
reading_time: 1 minute  

---

# How to restore backup file in MySQL database?

Hello Everyone, \
I'm facing a problem in restoring [backup file](https://www.mindstick.com/forum/390/how-to-create-mysql-database-backup-file-using-php) in [MySQL database](https://answers.mindstick.com/qa/38302/what-is-the-main-difference-between-innodb-myisam-mysql-database-engines). So can [anyone help me](https://www.mindstick.com/forum/331/can-anyone-help-me-out-how-to-use-session-concept) how to [solve this problem](https://answers.mindstick.com/qa/94681/my-google-assistant-shows-completely-different-search-results-from-what-i-ask-how-can-i-solve-this-problem).\
\
Thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)!!

## Replies

### Reply by Anonymous User

Hi Pravesh Singh,\
To restore [MySQL](https://www.mindstick.com/articles/12156/what-is-mysql) database [backup](https://www.mindstick.com/interview/1205/what-is-the-command-to-take-backup-and-restore-for-sharepoint-site) [file](https://www.mindstick.com/articles/59/encrypting-and-decrypting-files-using-c-sharp), 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](https://yourviews.mindstick.com/view/81399/tackling-the-problem-of-unemployment-during-corona-pandemic).


---

Original Source: https://www.mindstick.com/forum/392/how-to-restore-backup-file-in-mysql-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.