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 / kalai
mysqldump -uuser -ppassword databasename >filename
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do I install mysql workbench?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
How do I rename a mysql database?
What is mysql url?
What is heap table in mysql?
How to find second highest salary from a table?
What are the advantages and disadvantages of using mysql?
What are the functions used to encrypt and decrypt the data present in mysql?
What is different between sql and mysql?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
Can you tell few best practices to be followed for optimization in sql?
What are the advantages of a procedure?
How do you determine the location of mysql data directory?
How to use 'mysql' to run sql statements?
Can we rollback truncate in mysql?