How can we take a backup of a mysql table and how can we
restore it. ?
Answer Posted / ajay giri
We can use below query for exporting data to a .txt file.
mysql> SELECT * FROM <table_name> INTO
OUTFILE '<file_name>' FIELDS TERMINATED BY ',';
We can use below query for importing data from .txt file
mysql> LOAD DATA INFILE <file_name> INTO
TABLE '<table_name>'
FIELDS TERMINATED BY ',';
Is This Answer Correct ? | 20 Yes | 4 No |
Post New Answer View All Answers
How to create an array of a group of items inside an html form?
How arrays are passed through arguments?
Explain converting an object?
How do you use bcrypt for hashing passwords in php?
What is a http session?
What is the difference between htmlentities() and htmlspecialchars()?
Explain the importance of the function htmlentities.
Are php short tags acceptable to use?
How to convert strings to upper or lower cases?
What are php keywords?
Tell me how to execute an sql query? How to fetch its result?
List some features of php that are deprecated in php
What is Gd PHP?
What is the difference server side and browser side validation?
What is csrf token and how it works?