Shulou(Shulou.com)06/01 Report--

This article mainly introduces the method of migrating data from mysql to MongoDB. What it involves is learned from theoretical knowledge. There are many books and literature available for your reference. In practical terms, accumulated years of practical experience can be shared with you.

Recently, some projects need to use hadoop knowledge, and hadoop hbase as an indispensable member of the NoSQL family, naturally its status can not be ignored. But the same MongoDB supports mapreduce, and it has also sprung up in NoSQL in recent years. Shanda also launched MongoIC (taken from MongoDB In Cloud) on top of it. Directly promoting MongoDB as SAAS (so to speak) shows how hot MongoDB is.

It just so happens that we need to investigate whether it is convenient and reliable to migrate some data from the original mysql to MongoDB. For this reason, there is this article. As the most basic content, suitable for rookies, experts directly skip.

1. In mysql, there is a database called scores. There are three tables below (chinese,eng,math). Insert 4 rows of data into eng.

2. You can see that this table has the following data

3. View MongoDB database

4. Check which collections exist under test database. It can be seen that there is no eng collection at present.

5. You need to migrate the data of eng table in scores database to eng collection of MongoDB.

6. You can see that the migration was successful.

Summary: It can be seen that migrating from mysql to MongoDB is really simple. There is no need to create a collection of data structures like mysql tables in MongoDB in advance. You can migrate directly. very convenient

Help a friend's shop advertise ah-crocs canvas shoes

Read the above mysql data migration to MongoDB method introduction, I hope to give you some help in the actual application. Due to the limited space in this article, it is inevitable that there will be deficiencies and needs to be supplemented. You can continue to pay attention to the industry information section and regularly update industry news and knowledge. If you need more professional answers, you can contact us at the official website for 24 hours before and after sales.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.