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":16},"categories":[1],"tags":[4843,1596,1601,1597,1599,76,1600,1598],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/16624"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/145"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=16624"}],"version-history":[{"count":1,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/16624\/revisions"}],"predecessor-version":[{"id":53580,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/16624\/revisions\/53580"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=16624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=16624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=16624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\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