Interested to Buy Any Domain ? << Click Here >> for more details...
How can we take a backup of a mysql table and how can we
restore it. ?
- 7 Answers
- 17995 Views
- Brain Infosys, Oracle, I also Faced
- E-Mail Answers
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
Explain do you use composer? If yes, what benefits have you found in it?
What is singleton design pattern in php?
What is difference between md5 and SHA256?
What does $globals mean?
How many types of session are there?
Are php sessions cookies?
What is the difference between == and === operator in PHP?
What is ci in php?
What is mod_php?
Which is true about the singleton design pattern?
What is the difference between htmlentities and htmlspecialchars in php?
What is the use of preg_match in php?
How can we get ip address of a client in php?
How is it possible to propagate a session id?
Which array function checks if the particular key exists in the array?
