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 does mysql workbench do?

830

How do I stop a mysql service?

966

How can you filter the duplicate data while retrieving records from the table?

862

What is difference between statement and preparedstatement?

947

How to shutdown mysql server?

1019

Write a query to display current date and time?

895

How do I rename a procedure?

840

what is the difference between between and in operators in mysql?

995

How do I assign a variable in mysql?

948

How to get a version of mysql?

999

What is relational database in mysql?

891

How to concatenate two character strings?

987

how to display nth highest salary from a table in a mysql query? : Mysql dba

1014

What is a trigger in mysql?

997

Why use stored procedures in mysql?

937