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
- 11183 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
How to update a root password.
How to create a table index in mysql?
How to decrement dates by 1 in mysql?
Which software is used for mysql?
what is the difference between gui testing and database testing? : Mysql dba
How to shutdown mysql server?
What is mysql cursor?
What is default password for mysql?
Is mysql free download?
What do we use to remove duplicate records while fetching a data in mysql ?
How to use rank function in mysql?
How can you plan the logshipping before processing?
How to insert html code into mysql database using php?
How many TRIGGERS are allowed in MySql table?
Is there a free version of mysql?
