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 ) 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!

2 Answers 2

  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

FWIW, I'd suggest a more holistic approach, such as the one described in my article Database & Asset Syncing Between Environments in Craft CMS

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.