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


Please Help Members By Posting Answers For Below Questions

How does limit work in mysql?

668


What is the current root password of mysql?

671


why not null is not allowed at table level

2509


What is dbms in mysql?

742


Is mysql connect deprecated?

720


What is mysql root?

719


Does mysql use sql?

679


How do I view mysql logs?

701


How do I edit a table in mysql workbench?

614


What is the maximum size of table in mysql?

790


What are enums used for in mysql?

732


Is mysql from oracle?

719


What is the difference between float and double?

809


What is key in mysql?

672


How can you count the total number of records of any table?

707