<ol>
<li>Go into Utilities</li>
<li>Click &quot;Database Backup&quot;, this will give you a .zip file of your data</li>
<li>Go into phpMyAdmin of your production site</li>
<li>Find your database, click Import</li>
<li>Upload .zip file</li>
</ol>

CC BY-SA 4.0
2015-01-12T03:40:35.690Z
2021-03-03T13:02:58.777Z
2021-03-03T13:02:58.777Z
Nick
<p>FWIW, I'd suggest a more holistic approach, such as the one described in my article <a href="https://nystudio107.com/blog/database-asset-syncing-between-environments-in-craft-cms" rel="nofollow noreferrer">Database &amp; Asset Syncing Between Environments in Craft CMS</a></p>

<p>It'll make your long-term workflow much easier.</p>

CC BY-SA 3.0
2017-10-03T17:52:19.933Z
2017-10-03T17:52:19.933Z
andrew.welch
<p>I've finished my site locally, and would like to migrate my data to my production database.</p>

<p>I've already uploaded the templates, assets, etc, but I'm unsure how to 'dump and load' (referenced from <a href="https://craftcms.stackexchange.com/questions/1079/migrating-a-whole-website-between-craft-instances">this question</a> ) my database to production.</p>

<p>I realize this may be a little bit more phpMyAdmin related, but I thought this question could help others who are just beginning work with Craft CMS!</p>

<database><migration>
What's the easiest way to migrate my local site data to my live site?
# What's the easiest way to migrate my local site data to my live site?

(Asked by: username_0 on 2015-01-12)

I've finished my site locally, and would like to migrate my data to my production database.

I've already uploaded the templates, assets, etc, but I'm unsure how to 'dump and load' (referenced from [this question](https://craftcms.stackexchange.com/questions/1079/migrating-a-whole-website-between-craft-instances) ) my database to production.

I realize this may be a little bit more phpMyAdmin related, but I thought this question could help others who are just beginning work with Craft CMS!

**Tags:** database, migration

---

## 2 answers

### Answer by username_0 on 2015-01-12. Score: 4

1. Go into Utilities
2. Click "Database Backup", this will give you a .zip file of your data
3. Go into phpMyAdmin of your production site
4. Find your database, click Import
5. Upload .zip file


---

### Answer by username_1 on 2017-10-03. Score: 2

FWIW, I'd suggest a more holistic approach, such as the one described in my article [Database & Asset Syncing Between Environments in Craft CMS](https://nystudio107.com/blog/database-asset-syncing-between-environments-in-craft-cms)

It'll make your long-term workflow much easier.


---

