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
- 10842 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
Does insert statement lock the table?
What is offset limit?
Can mysql and mariadb coexist?
What is difference between mongodb and mysql?
change column name and make a unique column so we get no dupes.
How do I run mysql from command line?
What is meant by decimal (5,2)?
How to use triggers to track changes in mysql?
What are the indexes in mysql?
How to Change a users password from unix shell.
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
What is the use of procedure in mysql?
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
Why mongodb is faster than mysql?
What is not null in mysql?
