How can we take a backup of a mysql table and how can we
restore it. ?

Answer Posted / esorimer

mysqldump dbname tablename > backup.sql
mysql dbname < backup.sql

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to use http headers inside php? Write the statement through which it can be added?

507


Describe session in php.

533


How can we make a constant in php?

554


What is the difference between query and question?

516


Do you know how can we check the value of a given variable is a number?

517






Suppose your zend engine supports the mode Then how can you configure your php zend engine to support Mode ?

572


What are the advantages of stored procedures, triggers, indexes in php?

502


Is php a framework?

521


How do I use isdigit function?

560


How can I load data from a text file into a table?

563


How do you call a constructor for a parent class?

507


What is delimiter php?

533


How do you use an array in excel?

529


What is meant by ‘passing the variable by value and reference' in php?

528


What are the different types of php variables?

539