DATABAS DUMP - mysqldump -u <user> -p <password> <dbname&

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 / anil alpati

Answer Posted / anil alpati

DATABAS DUMP - mysqldump -u <user> -p <password> <dbname> > filename

DATABASE RESTORE - mysql dbname< filename -u <user> -p <password>

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the other commands to know the structure of a table using mysql commands except explain command?

1042

How can I change database in mysql?

892

What is table level locking in mysql?

921

What is information_schema in mysql?

997

What is the use of concat() in mysql?

998

What is a blob datatype?

868

What is indexing in mysql?

968

I want to find out all databases starting with ‘test’, I have access to?

1158

How do you use auto increment?

941

How to calculate expressions with sql statements?

1123

What are the types of database engines available in mysql?

1043

What is database url for mysql?

965

What is difference between function and procedure in mysql?

966

Can mysql handle big data?

960

Write a query to display current date and time?

930