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 delete cookie files on your computer?
Does php support function overloading?
Tell me what library is used for pdf in php?
What is final class and final method in php?
How to create a session? How to set a value in session?
How to insert a line break in php string?
How to call javascript function in php without any event?
What enctype is required for file uploads to work?
What is php and why it is used?
What is prepared statement in php?
Write a program to find a string is palindrome or not?
What is php pathinfo?
How to invoke a user function?
Write a program in php to reverse a number?
What is difference between session and cookie in PHP?