How would you backup and restore a big MySQL database? What
are the advantages of the approach which you have taken
over the others?
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 |
Post New Answer View All Answers
Explain csv tables.
How do I start mysql server?
How can I change database in mysql?
How do I import database through command line?
How to filter data from a mysql database table with php?
What is clob datatype?
What is limit in mysql?
What is a join in mysql?
What are slow queries?
Does mysql scale well?
Write a query to fetch common records between two tables using mysql?
How can you retrieve a particular number of records from a table?
Is primary key auto increment?
Why we use mysql workbench?
What is the use of count function in mysql?