How can we take a backup of a mysql table and how can we
restore it. ?
Answer Posted / sekhar
backup of a table:
click on phpmyadmin -> open the database -> click on the
table -> click on export button -> give the file name ->
click on go button -> after that select the table create
statement and insert statement after that save the matter as
a text file.
Restore of a table:
click on phpmyadmin -> open the database ->click on import
button -> and select the file location -> and click on go
button.
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
What are the differences between echo and print?
How do I escape data before storing it into the database?
What is the difference between session_unregister() and session_unset()?
What is the main function of php?
What is csrf verification?
How many types of array are there in php?
Which is correct about mysqli and pdo?
How to block direct directory access in PHP?
What are the php variables?
for image work which library?
Define about declare construct?
What is the use of 'print' in php?
What is orm in php framework?
How to set session.gc_divisor properly?
Tell me can you extend a final defined class?