Creating a mysql dump using SnapShooter

Hi there!

I am trying to setup a mysql dump using SnapShooter.

Does anyone have experience with this?

Currently i am not able to connect to the database from snapshooter, is this because i need to whitelist their ip addresses?

How would i do that?

Best Regards

It could be because the mariadb is in a private docker network and has not been exposed via port forwarding

Thanks for the response Steven!

I was suspecting this would be the case. I tried to search around a bit how to do something like that in docker.

Would you have any resources that can point me in a direction?

Possibly this could be interesting for other users self hosting appwrite.

I'm using digital ocean to host my machine and they acuired snapshooter and it is available as a add-on in the DO ecosystem

there should be plenty of resources online.

Here's an example in our dev version that forwards the port: https://github.com/appwrite/appwrite/blob/fc35e0f6ffd5ce7dab863515983e1495027e410c/docker-compose.yml#L801-L802

Keep in mind, if you forward the port, you need to lock things down so that no unauthorized user can access the container. Perhaps with firewall rules so that you can only access the port on the server iteslf

Another thing, I highly discourage modifying Appwrite's docker-compose.yml. Instead, you should create a docker-compose.override.yml file that overrides whatever you need.