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

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

More MySQL Interview Questions

What is meant by decimal (5,2)?

0 Answers  


How to load a csv file into a table

0 Answers  


What is int mysql?

0 Answers  


What is difference between group by and order by clause?

0 Answers  


How do I edit a trigger in mysql?

0 Answers  






How to insert dynamic values in mysql using php?

0 Answers  


What is mysql database extension?

0 Answers  


How do I start and stop mysql on windows?

0 Answers  


How do you login to MySql using Unix shell?

0 Answers  


What are the types of index?

0 Answers  


List data types in mysql? Explain

0 Answers  


Is mysql a scripting language?

0 Answers  


Categories