What opinions are there for database syncing? The obvious one is wp db migrate pro. Is there any others I would like to work in the command line since I’m already there. Seems like the only thing missing. Thanks

Trellis uses wp cli and you can export the database with wp db export command. Works same with import after you deploy.

So I would vagrant ssh in order to export the database? Is there a guide that you know of to show examples of steps involved? Thank you!

https://wp-cli.org/commands/db/ You can also use the forum’s search feature to read threads that have already addressed this :thumbsup:

And Migrate DB pro also has WP Cli Addon in case you’d prefer that, here’s a nice video showing it - https://deliciousbrains.com/wp-migrate-db-pro/doc/cli-addon/

[image] Aggressive: Is there a guide that you know of to show examples of steps involved? [image] cfx: You can also use the forum’s search feature to read threads that have already addressed this :thumbsup: I’ve written up how you can use WP-CLI and SCP/rsync to keep production and sta…

Thank you all for the information. Couple options to consider and best workflow I’ll have to consider.

WP Migrate DB is better but I’ve made this based on roots/bedrock-capistrano and lavmeiker/capistrano-wpcli . Take a look and tell me what you think. :smile:

[image] Pushing local database to the remote with wp_cli bedrock For who is still interested in this topic, I’ve made a more simple tool that works with Ansible (and it’s more Trellis agnostic) and doesn’t need Ruby and Capistrano. Take a look and tell me what you think. s…

I use the following, with WP-CLI aliases (see above): # export production alias to local wp db export \ # backup the local database && wp db reset \ # optional - create a blank slate && wp @production db export - | wp db import - \ # export the production database and pipe it into our local databas…

Getting Started
Releases
Support us

WP Packages is our new WPackagist replacement that's 17x faster and updates every 5 minutes

Roots Discourse

Database syncing

trellis

strarsis June 24, 2017, 7:41pm 10

Related tool:

Leveraging WP-CLI Aliases in Your WordPress Development Workflow blog

Actually another pull request by @guilro is in line for automating database and file backups using Stouts.backup Ansible role with Duplicity and is mentioned here: https://github.com/roots/trellis/pull/650 . I think that would be really good to have and can be configured in many different ways.

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled