Backup DB from Production

trellis
1

Hi!

I need download a backup copy from the production server. But i have no clue how to do it!
Can someone help me!!!

2

Easiest is a good plugin to do that: WP Migrate. If you need a full backup (including media files), purchase the Pro version, it is well worth it. bonus: it makes synchronising your local / staging server to the production server super easy.

1 Like
3

You could either:

  1. Use a program such as Sequel Pro to connect remotely and then export. Trellis docs: https://roots.io/trellis/docs/database-access

  2. Connect to the server via SSH and export the database via WP CLI. WP CLI doc: http://wp-cli.org/commands/db/export

  3. Use a plugin (as @pixeline mentioned)

There’s also a great thread about leveraging WP-CLI aliases to help automate all of this: Leveraging WP-CLI Aliases in Your WordPress Development Workflow.

4 Likes
4

Thank you a lot my friend!

2 Likes