How would you backup and restore a big MySQL database? What
are the advantages of the approach which you have taken
over the others?
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 you connect MySQL database with PHP?
How database are managed?
What is max connections in mysql?
Is mariadb faster than mysql?
How do I know if mysql is installed on windows?
Is mysql free software?
How do I start mysql manually?
What sql does mysql use?
How can you filter the duplicate data while retrieving records from the table?
What is the difference between char and varchar?
How do you know the version of your mysql server?
How to convert dates to character strings?
What is select query in mysql?
How is myisam table stored?
What is a user defined variable?