Question

WordPress Local to Droplet online

Posted April 21, 2017 1.5k views
MySQL PHP WordPress CMS Ubuntu 16.04 Data Analysis

Hi,

I’ve create a one click app’ Wordpress, put my own theme on the wp, export my database,

But how I can connect the database ?
How I can migrate from local to online droplet with my template and my database

I need to put my wordpress tomorrow, so if you have the answer please tell me !!! :)

I’ve pass all that day on it !!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

1 answer

Hello,

As you have Wordpress already installed what you could do is to upload your wp-content folder only, you could do that with FileZilla:

https://www.digitalocean.com/docs/droplets/how-to/transfer-files/

After that export, your database from your local environment, upload it again with FileZilla, and then follow the steps here on how to import your backup to your MySQL server running on your Droplet:

https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb

Regards,
Bobby

by Mateusz Papiernik
Being able to import and export your database is an important skill to have. You can use data dumps for backup and restoration purposes, so you can recover older copies of your database in case of an emergency, or you can use them to migrate data to a new server or development environment. This tutorial will cover how to export the database as well as import it from a dump file in MySQL and MariaDB.
Submit an Answer