Examveda

What is used to reload a delimited text data file?

A. mysqldump

B. mysqld

C. mysqlimport

D. mysqlnaive

Answer: Option C

Solution (By Examveda Team)

This question is about loading data from a text file into a MySQL database. Let's break down the options:
Option A: mysqldump
- mysqldump is used to backup your database, meaning it creates a copy of your data in a file. It's not used for loading data.
Option B: mysqld
- mysqld is the MySQL server itself. It runs in the background and manages the database. It's not used for loading data directly.
Option C: mysqlimport
- mysqlimport is the tool designed specifically for loading data from text files into a MySQL database. This is the correct answer!
Option D: mysqlnaive
- mysqlnaive is not a valid command or tool in MySQL.
Therefore, the correct answer is Option C: mysqlimport.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous