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
How does limit work in mysql?
What is the current root password of mysql?
why not null is not allowed at table level
What is dbms in mysql?
Is mysql connect deprecated?
What is mysql root?
Does mysql use sql?
How do I view mysql logs?
How do I edit a table in mysql workbench?
What is the maximum size of table in mysql?
What are enums used for in mysql?
Is mysql from oracle?
What is the difference between float and double?
What is key in mysql?
How can you count the total number of records of any table?