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
What are the advantages of indexes in php?
What is php simple definition?
How to update memcached when you make changes to php?
What is action hooks and filter hooks?
What is a definer in mysql?
How many types of arrays are there in php?
What are php loops?
What is laracast?
Which function will you use to create an array?
How to write the form tag correctly for uploading files?
How do you define a constant in php?
Write a program using while loop in php?
Explain setcookie() function in php?
sort term descripttion form, report and uery
Is strcmp case sensitive?