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


Please Help Members By Posting Answers For Below Questions

What is null value in php?

565


How to take a substring from a given string?

536


Which is better php or wordpress?

515


What is the method to register a variable into a session?

486


What is the difference between require_once and require in php?

553






Explain how can php and javascript interact?

542


In php how can you jump in to and out of "php mode"?

562


How to fix "headers already sent" error in php

542


What are psrs?

601


Why do we use javascript in php?

526


What is the difference between html and php?

541


What does the scope of variables mean?

531


How to concatenate two strings in php?

534


Tell me when a conditional statement is ended with an endif?

498


What is difference between static and constant in php?

500