# Backup DB from Production

**URL:** https://discourse.roots.io/t/backup-db-from-production/9007
**Category:** trellis
**Created:** 2017-03-06T13:49:03Z
**Posts:** 4

## Post 1 by @Erick_Amaral — 2017-03-06T13:49:03Z

Hi!

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

---

## Post 2 by @pixeline — 2017-03-06T13:59:16Z

Easiest is a good plugin to do that: [WP Migrate](https://wordpress.org/plugins/wp-migrate-db/). 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.

---

## Post 3 by @nathobson — 2017-03-06T14:13:26Z

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](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](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](https://discourse.roots.io/t/leveraging-wp-cli-aliases-in-your-wordpress-development-workflow/8414).

---

## Post 4 by @Erick_Amaral — 2017-03-06T18:21:06Z

Thank you a lot my friend!