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 fix a crashed mysql database?
How do I free up space in mysql?
What is mysql in linux?
What language is used in mysql?
How to see the create table statement of an existing table?
What is a blob datatype?
What's the latest version of mysql?
What is pdo connection?
Why use stored procedures in mysql?
What is delimiter in mysql trigger?
Is there a free mysql?
How do I stop a mysql command?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
What is action query?
How do I kill a mysql query?