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 can I use single quotes in single quotes in php?
What is difference between session_unset and session_destroy?
Which variable declarations within a class is invalid in php?
What are some new features introduced in php7?
Explain include(), include_once, require() and require_once?
What is final class and final method in php?
What is return in php function?
Tell me what does the scope of variables means?
What is a variable cost example?
How send email using php?
Is not null in php?
How can you tell if a number is even or odd without using any condition or loop?
What is mysqli php?
Why is php used for web development?
How can you get the size of an image in PHP?