mysqldump dbname tablename > backup.sql mysql dbname

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

Question Posted / esorimer

Answer Posted / esorimer

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

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is beforeRender() used?

1058

What is the importance of "method" attribute in a html form?

1021

What are the differences between php3 and php4 and php5? What is the current stable version of php? What advance thing in php7?

1049

Explain me what is the importance of "method" attribute in a html form?

929

How to find current date and time?

1024

Which php function will attach one file to another?

986

Is it easy to learn php?

967

How to make horizonatl menu and vertical menu responsive

2307

How to replace a text in a string with another text in php?

976

Is multilevel inheritance possible in php?

965

Tell me how the result set of mysql be handled in php?

985

How do I escape data before storing it into the database?

978

What is $row in php?

945

What is use of preg_replace in php?

1073

What is the use of dual table in mysql?

975