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

How to count all the lines of code in a directory and sub folder?

926

Can we use onclick in submit button?

966

where do we use htaccess?

942

Write a program to find a string is palindrome or not?

904

How does php work?

925

What is the difference between Session and Cookie?

994

What is super () python?

969

What is difference between post and put in rest?

950

Is php front end?

865

Is gender a dependent variable?

917

How is it possible to know the number of rows returned in the result set?

1062

Where is session value stored php?

950

What is mvc? Why its been used?

894

Is php faster than python?

970

How to insert an new array element in array?

975