Vidyalelo
MySQL · Q280

MySQL

Programming · MySQL · question 280

Q280

To use 'mysqldbcopy' which privileges are required on the source server?

A.
CREATE
B.
INSERT
C.
UPDATE
D.
SELECT
Answer

Answer: 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.