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 / 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 |
Post New Answer View All Answers
How do I change directories in mysql?
How to set mysql variable in php?
What is a string in mysql?
What is ISAM?
Is mysql workbench a dbms?
Write a command to view mysql database table structure?
What is delimiter in mysql stored procedure?
What is insert query in mysql?
How do I completely remove mysql from windows?
What is triggers and how it can be used in mysql?
How to make a copy values from one column to another in mysql?
What is mysql architecture?
In which language mysql has been written?
What is view in mysql?
How do I edit a table in mysql?