Backing Up a Database as Root

We recommend backing up MySQL databases using the customer's environment. You can either:

1. Add an SSH key or a password to the website under "developer tools" in the website dashboard
2. Log in to your server as root and "su" to the website's unix user
3. Dump a database as root

To dump a database as root:

1. Log in to your system as root. If you have a multi server cluster, this should be the server running the database role for the website you wish to back up.
2. docker exec mysqlcd sh -c "mysqldump database_name_here > /var/backups/database_name.sql"
3. You will find the resulting file in /var/local/LxRoot/mysqlcd-backups on the host o/s.

We recommend that you rm the backup file when you're done.