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

Which is the best web server?

528


What is needed to be able to use image function?

523


Does php use html?

475


What is a null coalescing operator in php7?

723


What are the characteristics of php?

560






What do you mean by having php as whitespace insensitive?

504


What is the use of namespace in php?

553


The left association operator % is used in PHP for?

576


What is faster in php?

576


Is ruby on rails php?

502


explain php variable length argument function.

579


What is the difference between query and question?

515


Are php sessions cookies?

506


How does php and apache work?

530


What is difference between required and require_once in php?

542