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
- 10828 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 do I exit mysql?
Can you tell how to find the number of rows in a resultset using php?
Can python connect to mysql?
how you will Create a database on the mysql server with unix shell.
What is limit in mysql?
Can you tell what are various ways to create an index?
What is the purpose of -> in the mysql terminal?
What are the functions of commit and rollback statements?
How to see the create table statement of an existing table?
How do I clear the screen in mysql?
How do I download mysql on my laptop?
What is a storage engine?
Is mysql a scripting language?
Can mysql handle billions of records?
What is the maximum connection pool size?
