How can we take a backup of a mysql table and how can we
restore it. ?
- 7 Answers
- 16730 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
What is the best practice for running mysql queries in php? Consider the risk of sql injection.
what are the differences between php and perl
What is abstraction php?
What is the method to register a variable into a session?
How to get no. of rows using MYSQL function?
What is the use of mysqli_real_escape_string() function?
Explain the difference between urlencode and urldecode?
How can we know the total number of elements of Array?
What is trim codeigniter?
What are the different filter functions used to filter a variable?
Does browser understand php?
What do the initials of php stand for?
What is the current stable version of php?
How to increase the maximum execution time of a script in php?
How is it possible to cast types in php?
