Q280
To use 'mysqldbcopy' which privileges are required on the source server?
A.
CREATE
B.
INSERT
C.
UPDATE
D.
SELECT
AnswerAnswer: Option D
Solution
Answer: Option D
Solution:
This question is about MySQL's `mysqldbcopy` tool. `mysqldbcopy` helps you copy data between MySQL servers.To use `mysqldbcopy`, the source server needs to allow you to read the data you want to copy.
So, the answer is Option D: SELECT.
Why not other options?
* CREATE is for creating new tables or databases, not copying data.
* INSERT is for adding data to existing tables, not retrieving it.
* UPDATE is for changing data in existing tables, not copying it.