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
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 |
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 |
Answer / kalai
mysqldump -uuser -ppassword databasename >filename
Is This Answer Correct ? | 2 Yes | 2 No |
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 |
What is meant by decimal (5,2)?
How to load a csv file into a table
What is int mysql?
What is difference between group by and order by clause?
How do I edit a trigger in mysql?
How to insert dynamic values in mysql using php?
What is mysql database extension?
How do I start and stop mysql on windows?
How do you login to MySql using Unix shell?
What are the types of index?
List data types in mysql? Explain
Is mysql a scripting language?