MySQL imports data into the MongoDB database

Little scum · Posted on 8/20/2017 5:22:14 PM

First, the syntax is as follows:

Export the required data from SQL in CSV format

Import data in csv format to a MongoDB database

Note: I have two "-" signs in front of type, and using one "-" will give an error

First, I have a table of vehicle location information in my database

There are more than 10 million data, and the export command is as follows:

Login is visible.

The data is exported to the root directory of the C drive by default, as shown in the figure below:

Let's import the exported csv data into the MongoDB database with the following command:
（No, you don'tCreate a database and collection first, and the program will automatically create it for us)

Login is visible.

After execution, the import will begin, and the import progress bar will be displayed, as follows:

Parameter description:
-h: Indicates the IP of the database host
-u: Indicates the username of the database
-p: Indicates the password of the database
-d: Indicates the name of the database
-c: Indicates the name of the collection
-f: Indicates which columns to import

After waiting for about 5 minutes, the import was successful!!

The data is as follows, you can view the imported data, but the column names do not follow the column names we specified, I don't know why...

[Source] MySQL imports data into the MongoDB database

Related Posts

Sections viewed