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
Does wordpress still use php?
Which function can be used to exit from the script after displaying the error message?
Does php support function overloading?
What is meant by an associative array?
How can you upload a file using php?
Can we override magic methods in php?
Are sessions stateless?
What are global variables in php?
Which function can be used to delete a file?
Is php dead 2019?
How can we extract string "pcds.co.in" from a string "https://info@pcds.co.in" using regular expression of php? More on reg can you explain
What are the special characters you need to escape in double-quoted stings?
Why session is required?
What does $_cookie means?
Which software is used to run php programs?