![]() ![]() Now go check your csv file in file path you gave, below is the snapshot of the file generated.Įxporting table from MySQL Command line (Server)īelow is the snapshot of a table data “Customers” from a database named dbone Give file path where you want to store data and select the file type then click on “Next>”, as you can see, I am saving my file in downloads.Ĭlick on Next on “Export Data” tab and click on ‘Finish’ on Export Results tab. Now select the columns that you want to export and click on next. ĭata of table “people” from abc database. Select the database from which you want to export table and right click on the table name then click on “Table Data Export Wizard” as shown in below snap shot, I am exporting table people from database “abc”. On your MySQL workbench click on “Schemas” under navigator. MySQL to MongoDB terminology mapping chartĮxporting tables using MySQL workbench to a CSV file ![]() In this blog we will see a very simple way of migration where you export tables from mysql-workbench and mysql command line to csv files, and importing a csv file to mongodb. While MongoDB is more flexible and ensures data availability ,MySQL ensures greater reliability of transactions ,so if you have a application where there is a need to perform complex queries and you do not intend to add more features it’s better to stay on MySQL, on the other side ,if you are constantly adding new features and functionalities to your application it’s better to migrate to MongoDB. MongoDB is a non-relational document database used to store unstructured data, it has flexible data model as it allows you to store data in Json format, it uses collections and documents unlike tables and rows in relational database, documents consist of key-value pairs which are mongo dB’s basic unit of data, fields in a MongoDB document can be indexed with primary and secondary index’s. MySQL is one of the most used relational database managements (RDMS) based on SQL, it stores data in rows and columns each row will have unique data for the defined columns, and every RDMS follows a predefined schema to store data, use a relational database management system when you want your data to be stored in a particular predefined schema. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |