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

What are the differences between GET and POST methods?

726


What is composer json?

674


What are different types of Print Functions available in PHP?

704


Are react hooks stable?

710


Is multiple inheritance supported in php?

755


Explain me is multiple inheritance supported in php?

764


What is meant by public, private, protected, static and final scopes?

745


How do sessions work in php?

713


What is the use of namespace in php?

729


What is the difference between get and post in php?

746


Do you know what are traits?

730


How many types of array are there in php?

790


Whether php supports microsoft sql server?

748


What is the use of preg_match in php?

725


Why is php used for web development?

723