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 you connect MySQL database with PHP?

740


How database are managed?

764


What is max connections in mysql?

708


Is mariadb faster than mysql?

711


How do I know if mysql is installed on windows?

700


Is mysql free software?

744


How do I start mysql manually?

676


What sql does mysql use?

705


How can you filter the duplicate data while retrieving records from the table?

685


What is the difference between char and varchar?

846


How do you know the version of your mysql server?

797


How to convert dates to character strings?

784


What is select query in mysql?

694


How is myisam table stored?

751


What is a user defined variable?

715