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
- 11034 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 the use of mysqli_fetch_array?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
What is the difference between mysql and oracle?
How to create a test table in your mysql server?
How to enter boolean values in sql statements?
What is difference between mysqli and pdo?
What is difference between mysql and mysqli?
What is database in php mysql?
What is mysql data directory? How to determine the location of the data directory?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
How many concurrent queries can mysql handle?
Is mysql better than oracle?
How do I make an action query?
What is a heap table?
What is RMS Migrations
