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
- 11020 Views
- I also Faced
- E-Mail Answers
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
What is the maximum number of records in mysql table?
What is the use of mysqli_num_rows?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
Can mongodb replace mysql?
What is a transaction? Describe mysql transaction properties.
Can python connect to mysql?
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.
Is mysql connect deprecated?
SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?
What is mysql optimization?
What does mysql flush hosts do?
What storage engines are used in MySQL?
How can I change database in mysql?
Does mysql support sequence?
Is mysql a database?
