How would you backup and restore a big MySQL database? What are the advantages

How would you backup and restore a big MySQL database? What
are the advantages of the approach which you have taken
over the others?

Question Posted / pranab

4 Answers
11052 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How would you backup and restore a big MySQL database? What are the advantages of the approach whi..

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

How would you backup and restore a big MySQL database? What are the advantages of the approach whi..

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

How would you backup and restore a big MySQL database? What are the advantages of the approach whi..

Answer / kalai

mysqldump -uuser -ppassword databasename >filename

Is This Answer Correct ?

2 Yes

2 No

How would you backup and restore a big MySQL database? What are the advantages of the approach whi..

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