Examveda

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

A. CREATE

B. INSERT

C. UPDATE

D. SELECT

Answer: Option D

Solution (By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous