How can a InnoDB database be backed up without locking the tables?
Correct Answer: mysqldump --single-transaction db_name
Explanation:
Note: This Question is unanswered, help us to find answer for this one
MySQL Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More MySQL MCQ Questions
Is it possible to use group by clause to concatenate strings?
How to return a JSON representation of a MySQL query?
Which datatype is used to store binary data in MySQL?
Which statements relating to Alias names is true?
Which makes a backup on the whole database except the tables sessions and log?
Which is not a valid Bit operator?
How can the following error be solved in MySQL? ERROR 1153: Got a packet bigger than 'max_allowed_packet' bytes
Is there any function in MySQL that allows for replace through a regular expression?
Most common use of the mysql EXPLAIN statement?
Correct way to change the character set to UTF8?