# MongoDB Exporting and Importing Databases
Since database creation is a hectic and sometimes manual process,it cannot be done again and again.Hence, we need a way to transfer a database or a collection from one system to another system.vThe commands we would use here are
The process to transfer a collection's data would be:
- Exporting the data and creating JSON file for the collection
- Moving that JSON file to the system where you want to export the data.
- Importing the data through those JSON files.
Suppose you have collection named 'clients' in a database named 'dropdeliver'. The first step was to export the data and create its JSON file.
Open the Command Prompt if you are using Windows,or Terminal if you are using MAC OS and type in the following command:
mongoexport -d databasename -c collectionname -o path-for-json-file
For this example:
mongoexport -d dropdeliver -c clients -o C:/json/client.json
If you get an error like:
This means that mongoexport is not avaiable at that location. So you need to change your folder and go into the bin folder of MongoDB in the Program Files directory.
If your command runs successfully you will get something like:
Now,the second step is copying the JSON file 'clients.json' to the system you want to export the database in. After you have copied the file,we just have to import the data from the JSON file into MongoDB.
mongoexport command,for some people this command will be accessible from the bin folder.
The command is like:
mongoimport -d databasename -c collectionname path-to-json-file
For this example:
mongoimport -d dropdeliver -c clients C:/json/clients.json
If your command runs successfully,you will have something like:
Note:While importing you can choose a different database name and collection namefrom the source.Just keep the path to the JSON file correct. Thank You 😃
- MongoDB Exporting and Importing Databases