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 / anil alpati
DATABAS DUMP - mysqldump -u <user> -p <password> <dbname> > filename
DATABASE RESTORE - mysql dbname< filename -u <user> -p <password>
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we store videos in mysql database?
How to shutdown mysql server?
How do I start mysql in mysql workbench?
How to check server status with 'mysqladmin'?
How to returns the columns and column information pertaining to the designated table.
Which is faster mongodb or mysql?
How can I create database in mysql?
What is int unsigned?
How to drop an existing table in mysql?
What is a join in mysql?
Write a query to display even rows in student table using mysql?
can you elaborate on blob and text in mysql? : Mysql dba
What is 'mysqlimport'?
How do I stop a mysql command?
How many rows can a mysql table hold?