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
- 10184 Views
- I also Faced
- E-Mail Answers
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
Which is better mysql or mssql?
If we use sum function in mysql, does it return sum of that row or for that column?
What is the difference between mysql_connect and mysqli_connect?
How do I start mysql from command line?
How do I optimize a selected query in mysql?
Is mysql a backend?
What is maximum table size in mysql?
How do I start mysql database?
What is the difference between a database and a table?
What is mysqlcommand?
How to Change a users password from unix shell.
Is mysql a scripting language?
Is mysql good for large database?
What is unsigned int in mysql?
In which year mysql created?
