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 / eric
Alternative to the solutions above, that all use the console
you can also use administration software, like
-MySQL Administrator (that's what I use, but it seems to be
replaced by the MySQL Workbench...)
-MySQL Workbench(I think this should also do the job, but I
didn't test it yet)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are date and time data types in 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.
Explain csv tables.
What mysql -u john -p command does?
What is mysql default database?
What is the difference between the LIKE and REGEXP operators?
How many columns can you create for an index?
How to delete an existing column in a table?
How to returns the columns and column information pertaining to the designated table.
What is the use of mysqli_num_rows?
what is the difference between gui testing and database testing? : Mysql dba
How do I select a table in mysql?
Explain about reporting services of MYSQL?
Why use stored procedures in mysql?
Why we use mongodb instead of mysql?