Suggestion: Database backup?

[timatidg]

I take advantage of the wonderful CV commands available when doing an CiviCRM upgrade, but I don't know of any way to use the command line to read the database information from settings.php and back up the mySQL database. (I have to update a whole bunch of sites and, if this existed, it would mean I would not have to look up each site's details manually, but could just use the same command on all sites.)

I researched if this feature exists anywhere, and I can't find anything. I wish I had the skills to code it and help, but I don't.

[colemanw]

Sorry this command doesn't currently exist. You may be interested to follow this discussion: https://lab.civicrm.org/dev/core/-/issues/5277

[MegaphoneJon]

This conversation may be more relevant: #191

There's lots of times to backup a db that aren't related to portability - e.g. I back up the db before an upgrade.

My MySQL credentials are stored in a pass repo that my Ansible uses for lookup. But you could use cv vars:show and jq to do this:

PASS=`cv vars:show | jq -r '.["CIVI_DB_PASS"]'`; USER=`cv vars:show | jq -r '.["CIVI_DB_USER"]'`; NAME=`cv vars:show | jq -r '.["CIVI_DB_NAME"]'`; mysqldump -u$USER -p$PASS $NAME > backup.sql