mysqldump -uuser -ppassword databasename >filename

How would you backup and restore a big MySQL database? What
are the advantages of the approach which you have taken
over the others?

Question Posted / kalai

Answer Posted / kalai

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the different tables present in MySQL?

1049

How many columns can a mysql table have?

851

How do I insert multiple rows in a table?

845

How do I download mysql?

836

Tell us something about heap tables?

940

How do I import database through command line?

934

What is row level locking in access?

832

how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

2177

What is the use of mysqli_query?

837

What is save point in mysql?

901

How do I find mysql version in mysql workbench?

868

How do I edit a stored procedure in mysql?

859

What is int mysql?

893

How to represent ENUMs and SETs internally?

1087

What are the column comparisons operators?

1176