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

How to create a session? How to set a value in session? How to remove data from a session?

517


What are the differences between php constants and variables?

513


What are the features of php 7?

507


Is php a programming language?

554


Why many companies are switching their current business language to php? Where php basically used?

506






What is form submission?

548


How to get the directory name out of a file path name?

546


What is the difference between include and require?

530


Which function(s) in PHP computes the difference of arrays?

581


What is php and what does it do?

546


What is csrf token and why it is required?

542


What is the difference between pop3 IMAP and MAPI?

643


Where can I find php ini file?

501


Which function parses an English textual date or time into Unix timestamp in PHP.

579


Tell me what does the initials of php stand for?

556