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 / meena bisht

Backup:- mysqldump -u <user name> -p<pwd> dbname >
filename.sql

Restore:- mysql -u <user name> -p<pwd> dbname < filename.sql

The backup and restoration of any table is faster in sql
file.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I change directories in mysql?

693


How to set mysql variable in php?

720


What is a string in mysql?

702


What is ISAM?

895


Is mysql workbench a dbms?

790


Write a command to view mysql database table structure?

751


What is delimiter in mysql stored procedure?

693


What is insert query in mysql?

693


How do I completely remove mysql from windows?

718


What is triggers and how it can be used in mysql?

738


How to make a copy values from one column to another in mysql?

827


What is mysql architecture?

775


In which language mysql has been written?

1086


What is view in mysql?

778


How do I edit a table in mysql?

694