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
- 11019 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 'mysqlimport'?
How we can get the current date in mysql?
How many columns can a mysql table have?
What is mysql workbench used for?
How do I create a stored procedure in mysql?
How do I find mysql version in mysql workbench?
What is heap table?
What does tinyint mean?
How many sql ddl commands are supported by 'mysql'?
Can you tell what are various ways to create an index?
What is a transaction? Describe mysql transaction properties.
How to check if value already exists in mysql database in php?
Why should I learn mysql?
What are slow queries?
What is mysql gpl?
