Pull:db doesn't work on Kinsta

[joemaller]

WP Engine keeps a copy of the most recent DB snapshot in the site's wp-content directory. Kinsta doesn't. Both block serving of *.sql files.

The pull script should be smarter about missing *.sql files and fail with a descriptive message.

Cron works on Kinsta though, so a workaround is simply to add a cron job which dumps the DB hourly. Something like this:

# dump db hourly for dev mirrors
59      *       *       *       *       mysqldump --default-character-set=utf8mb4 -udbuser -pDBPASSWORD db-name > ~/public/wp-content/mysql.sql

[joemaller]

Documented in ee1acbc