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

Explain csv tables.

934

How do I start mysql server?

838

How can I change database in mysql?

838

How do I import database through command line?

932

How to filter data from a mysql database table with php?

835

What is clob datatype?

835

What is limit in mysql?

824

What is a join in mysql?

843

What are slow queries?

847

Does mysql scale well?

837

Write a query to fetch common records between two tables using mysql?

958

How can you retrieve a particular number of records from a table?

892

Is primary key auto increment?

905

Why we use mysql workbench?

844

What is the use of count function in mysql?

975