Database Dump

Note, the following causes the production server to error with an HTTP 500 code. I believe this is because it blocks writes to the database. The error goes away as soon as the dump completes.

The MySql database resides on a AWS RDS server. To dump the database, you must be able to connect to the machine. To connect, you must add your IP address to the list of IP addresses that can connect. Remember to remove your IP address when you are done. Otherwise, we hit the limit of 20 allowed addresses and one must be removed before another can be added. Access in controlled via an AWS console page.

I connect to the MySql workbench and use it to create a dump file on my local machine. This is done via the "Data Export" option.