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
Explain the difference between require() and require_once()?
How to check a key exist in an array?
What are encryption functions in php?
How a variable is declared in php?
What is new static in php?
Which method do you follow to get a record from a million records? (Searching not from database, from an array in php)?
What is move_uploaded_file in php?
What is difference between put and post method in http?
Tell me how to find current date and time?
What is string and its function?
What is inheritance in php?
How to concatenate two strings together in php?
What is uri routing?
Is it possible to protect special characters in a query string?
Tell me what is the use of "ksort" in php?