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

Can you use both this () and super () in a constructor?

747


How to define a user function?

791


What is difference between include,require,include_once and require_once()?

749


What is difference between strstr() and stristr()?

713


How do you measure variables?

762


How to set cookies?

777


What is mysqli_fetch_array?

743


When to use self over $this?

747


Is php developer in demand?

714


/temp is a type of filesystem directory. State Whether True or False?

780


What is list function with their uses.

723


Why does php start with variables?

781


Does php support multithreading?

775


Can we override static method in php?

785


What are major variables in research?

752