MySQL and MongoDB are a very popular open-source databases these days. Through this blog, I wanted to share a use case of migrating MySQL database to MongoDB database and perhaps want to share few lessons during the migration process which would be helpful.<\/p>\n
There are\u00a0three steps to\u00a0the migration process:<\/p>\n
Suppose you have a user table with the\u00a0following structure, which needs to be migrated to MongoDB collection named\u00a0“user<\/strong>”<\/p>\n [code]<\/p>\n +————+————–+——+—–+———+—————-+ [\/code]<\/p>\n Step 1 :<\/strong> Generate csv of the data for existing table :<\/p>\n [code]<\/p>\n select first_name, last_name, address, age, version into outfile ‘user.csv’ FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\\n’ from user;<\/p>\n [\/code]<\/p>\n This query will generate a file named user.csv into directory where MySQL\u00a0is installed followed by your database name. Suppose your database name is Test,\u00a0then\u00a0file will be generated at \/var\/lib\/mysql\/test directory.<\/p>\n Step 2 :<\/strong> Now move the file to appropriate directory, or else\u00a0you will get file permissions error. Incase, you have all permissions, you may skip this step.<\/p>\n [code] sudo mv \/var\/lib\/mysql\/test\/user.csv Desktop\/ [\/code]<\/p>\n Step 3 :<\/strong> Now import generated csv into\u00a0MongoDB<\/p>\n [code]<\/p>\n mongoimport –host 127.0.0.1 –port 27017–username user\u00a0–password pass\u00a0–db test\u00a0–collection user –type csv -f first_name,last_name,address,age,version –file Desktop\/user.csv<\/p>\n [\/code]<\/p>\n This will import data into “user<\/strong>” collection \u00a0under test\u00a0<\/strong>database.<\/p>\n I hope you found this blog useful with the steps for migrating from MySQL database to MongoDB.<\/p>\n Keep performing!!!<\/p>\n","protected":false},"excerpt":{"rendered":" MySQL and MongoDB are a very popular open-source databases these days. Through this blog, I wanted to share a use case of migrating MySQL database to MongoDB database and perhaps want to share few lessons during the migration process which would be helpful. There are\u00a0three steps to\u00a0the migration process: Suppose you have a user table […]<\/p>\n","protected":false},"author":145,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":29,"footnotes":""},"categories":[1],"tags":[4843,1596,1601,1597,1599,76,1600,1598],"class_list":["post-16624","post","type-post","status-publish","format-standard","hentry","category-technology","tag-database","tag-mongo","tag-mongo-csv-import","tag-mongo-migration","tag-mongoimport","tag-mysql","tag-mysql-csv","tag-mysql-migration"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t
\n| Field | Type | Null | Key | Default | Extra |
\n+————+————–+——+—–+———+—————-+
\n| id | bigint(20) | NO | PRI | NULL | auto_increment |
\n| version | bigint(20) | NO | | NULL | |
\n| address | varchar(255) | NO | | NULL | |
\n| age | int(11) | NO | | NULL | |
\n| first_name | varchar(255) | NO | | NULL | |
\n| last_name | varchar(255) | NO | | NULL | |
\n+————+————–+——+—–+———+—————-+<\/p>\n