Vidyalelo
MySQL · Q201

MySQL

Programming · MySQL · question 201

Q201

Which program performs logical backups?

A.
mysqlimport
B.
mysqldump
Answer
C.
myslqpit
D.
mysqllogic

Answer: Option B

Solution

Answer: Option B
Solution:
This question is asking about a program that creates a logical backup of a MySQL database. A logical backup means that the program creates a copy of the data itself, not the physical files on the server. Here's a breakdown of the options: * Option A: mysqlimport This program is used to import data into a MySQL database, not for backing up data.
* Option B: mysqldump This program is used to dump the data from a MySQL database into a file. This is a common method for creating logical backups.
* Option C: myslqpit This option is incorrect. There is no program called "myslqpit" in MySQL.
* Option D: mysqllogic This option is incorrect. There is no program called "mysqllogic" in MySQL.
Therefore, the correct answer is Option B: mysqldump