# Import / Export Data from On Site Edx to Tutor OpenEdx in AWS

**URL:** <https://discuss.openedx.org/t/import-export-data-from-on-site-edx-to-tutor-openedx-in-aws/11383>\
**Category:** Site Operators\
**Created:** [October 10, 2023, 9:10pm UTC](https://discuss.openedx.org/t/import-export-data-from-on-site-edx-to-tutor-openedx-in-aws/11383 "2023-10-10T21:10:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kevin\_Chung](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.openedx.org/kevin_chung/32/5937_2.png) [@Kevin\_Chung](https://discuss.openedx.org/u/Kevin_Chung)\
**Post date:** [October 10, 2023, 9:10pm UTC](https://discuss.openedx.org/t/import-export-data-from-on-site-edx-to-tutor-openedx-in-aws/11383/1 "2023-10-10T21:10:08Z")

</div>

I have openedx install on ubunto 16.04 and I just installed an instance on AWS using tutor [overhang.io](http://overhang.io). I am looking to move the database from one server to the next. I have a few questions

1, Where is the database located in tutor AWS.  
2. I have the .sql backups from the old server, once imported what commands should I run to initialize the change without a break  
3. Should I create a snapshot in AWS before these changes or take an AMI image?

---

<div class="post-metadata">

**Author:** ![Anh\_Vu\_Nguy\_n](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.openedx.org/anh_vu_nguy_n/32/1740_2.png) [@Anh\_Vu\_Nguy\_n](https://discuss.openedx.org/u/Anh_Vu_Nguy_n)\
**Post date:** [October 11, 2023, 4:15am UTC](https://discuss.openedx.org/t/import-export-data-from-on-site-edx-to-tutor-openedx-in-aws/11383/2 "2023-10-11T04:15:10Z")

</div>

This might help you: [Making backups and migrating data — Tutor documentation](https://docs.tutor.overhang.io/tutorials/datamigration.html)  
Always create snapshots/AMI before making big changes. I would prefer AMI for this kind of operation.

---

<div class="post-metadata">

**Author:** ![Kevin\_Chung](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.openedx.org/kevin_chung/32/5937_2.png) [@Kevin\_Chung](https://discuss.openedx.org/u/Kevin_Chung)\
**Post date:** [October 17, 2023, 3:01am UTC](https://discuss.openedx.org/t/import-export-data-from-on-site-edx-to-tutor-openedx-in-aws/11383/3 "2023-10-17T03:01:14Z")

</div>

I have Open edX Eucalyptus Release running in house on ubunto 16.04.  
I manage to retireve the mysqldump.sql files from that server

I installed a ned Olive Tutor release in AWS zero click installation  
When I run mysql : Command ‘mysql’ not found, but can be installed with:

According to ([Making backups and migrating data — Tutor documentation](https://docs.tutor.overhang.io/tutorials/datamigration.html#backup-tutorial))  
The `dump.sql` and `dump.mongodb` files will be located in `$(tutor config printroot)/data/mysql` and `$(tutor config printroot)/data/mongodb` .

When I try to browse to $(tutor config printroot)/data/mysql`  
I am getting the following error  
tutor config printroot: command not found  
bash: cd: /data/mysql: No such file or directory

It is still not clear how I can replace the .sql file and restore the database.

---

<div class="post-metadata">

**Author:** ![j.thorat10](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.openedx.org/j.thorat10/32/5590_2.png) [@j.thorat10](https://discuss.openedx.org/u/j.thorat10)\
**Post date:** [December 5, 2023, 9:37am UTC](https://discuss.openedx.org/t/import-export-data-from-on-site-edx-to-tutor-openedx-in-aws/11383/4 "2023-12-05T09:37:17Z")

</div>

Hi Kevin, I also created database dumps by referring to the same tutor documentation you’ve linked. I am using tutor 15.0.0 on my Ubuntu 20.04 AWS EC2 machine.  
I think there are two possible reason you are not able to find those dump files

1. You may be trying to access those files from the `root` user; make sure you are logged in as the correct user where your tutor installation is available; in my case, it was `tutor`. You can simply do `sudu su tutor` and then use `cd $(tutor config printroot)/data/MONGO_OR_SQL_folderName`

2. Or you can provide a full path rather than using variables associated with the tutor.  
e.g., `cd /home/tutor/.local/share/tutor/data/`
