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
- 10879 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 sql in mysql?
How to make a column bigger and delete unique from table.
How do I insert multiple rows in a table?
What is ibdata1?
How many ways to get the current time?
What do you understand by mysql terminal?
Is mysql relational?
How to get a version of mysql?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
How to install mysql?
Explain the difference between mysql and mysql interfaces in php?
How to enable or disable a row of a table using MySQL in struts?
How do I make an action query?
How many columns can a mysql table have?
What is mysql data directory? How to determine the location of the data directory?
