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 / eric

Alternative to the solutions above, that all use the console
you can also use administration software, like
-MySQL Administrator (that's what I use, but it seems to be
replaced by the MySQL Workbench...)
-MySQL Workbench(I think this should also do the job, but I
didn't test it yet)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If you wish to encrypt the username and password using php, how will you do that?

506


How to use sum function in where clause in mysql?

438


What is the phantom problem?

492


Does facebook still use mysql?

494


What's new in mysql 8?

554






What is a mysql model?

495


Which command is used to view the content of the table in mysql?

487


What is a text delimiter?

501


What is the difference between the LIKE and REGEXP operators?

529


How we can get distinct columns values in mysql?

595


What is text?

548


How do you kill a long running query in mysql?

458


Why are function needed?

483


What is difference between microsoft sql and mysql?

486


How to determine the location of the data directory?

492