How would you backup and restore a big MySQL database? What
are the advantages of the approach which you have taken
over the others?
- 4 Answers
- 10250 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is mysql slow query?
Is mysql a relational database?
What is sqlyog?
What is mysql shell?
What's the difference between mysql and sql server?
Do I need to pay for mysql?
What are the differences between innodb and myisam engines?
How do I change directories in mysql?
How to print message in mysql trigger?
Why do we use views instead of tables?
How do you know the version of your mysql server?
What is mysql connection limit?
What is save point in mysql?
How can an index be declared in mysql?
Why does mysql have so many connections?
