Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11203 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
What is orm in mysql?
What is the return type of mysqli_query?
What is the difference between char and varchar?
Where MyISAM table will be stored and also give their formats of storage?
What is heap table?
How do I uninstall mysql connector?
In how many ways we can retrieve data in the result set of mysql using php?
How triggers can be used in mysql?
How does mysql clustering work?
What data type is money?
How to insert dynamic values in mysql using php?
What are the common mysql functions?
How to write date and time literals?
Is mysql better than oracle?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
