I was able to go into the server through the VirtualBox GUI using username and password vagrant:vagrant, then logged into mysql using the credentials root and vault_mysql_root_password contained in host_vars/development/vault.yml:
mysql -uroot -p
Then within MySql: list databases;. Leave mysql by pressing CTRL-C (I think) and then:
mysqldump -uroot -p name_of_database_you_recognized_in_above_command > database_backup.sql
Then I went back to my computer (having to use Option + Command + Escape to get out of the VirtualBox VM window) and got my local IP address. You can just google IP address. I used ifconfig | grep "inet " | grep -v 127.0.0.1 | awk '{print $2}' so I could feel cool. Now back to the VM:
rsync -avP database_backup.sql mikekilmer@my-ip-address:Documents/
And it’s now in ~/Documents.
Unfortunately now I’m getting failed provisioning on Wordpress Install.
failed: [default] (item={'value': {u'multisite': {u'enabled': False}, u'cache': {u'enabled': False}, u'ssl': {u'enabled': False, u'provider': u'self-signed'}, u'local_path': u'../site', u'site_hosts': [u'blablabla.dev'], u'admin_email': u'mike@mzoo.org'}, 'key': u'blablabla.dev'}) => {"changed": true, "cmd": ["composer", "install"], "delta": "0:00:00.101408", "end": "2016-07-13 12:44:20.743464", "failed": true, "item": {"key": "blablabla.dev", "value": {"admin_email": "mike@mzoo.org", "cache": {"enabled": false}, "local_path": "../site", "multisite": {"enabled": false}, "site_hosts": ["blablabla.dev"], "ssl": {"enabled": false, "provider": "self-signed"}}}, "rc": 1, "start": "2016-07-13 12:44:20.642056", "stderr": "You are running composer with xdebug enabled. This has a major impact on runtime performance. See https://getcomposer.org/xdebug\nRunning composer as root/super user is highly discouraged as packages, plugins and scripts cannot always be trusted\nComposer could not find a composer.json file in /srv/www/blablabla.dev/current\nTo initialize a project, please create a composer.json file as described in the https://getcomposer.org/ \"Getting Started\" section", "stdout": "", "stdout_lines": [], "warnings": []}
I was hoping to avoid “nuke the entire dir and your hosts file”, but that may end up being necessary. Which directory are you actually referring to, just Trellis, Trellis and Bedrock or something else? I would think either way I would keep the host_vars/production directory which is hopefully still working.