How do I find my Wordpress files and database?

Hi @mywebguy,

If you are using FileZilla, you need to use a user on your Droplet, let’s say root with your SSH key.

Now, the WordPress files can be in a lot of different places. To do find out where exactly they are, you need to SSH to your Droplet and type in the following command:

netstat -tulpen | grep 443

Depending on the result, it might be Nginx or Apache2, you’ll need to enter the following directory:

If Apache2:

cd /etc/apache2/sites-enabled

If Nginx

cd /etc/nginx/sites-enabled

In One of the above folders, you should see a config file for your Droplet, cat it to check its contents. In there you should see the root/homedir of your Website.

As for your MySQL, you just need to dump the data from your Database. Once you are in your WordPress directory, you can check your DB credentials from the wp-config.php file.

Once you know them you can just dump the Database with the following command:

mysqldump -u DBUser -p DBName > wordpressdb.sql

Where DBUser and DBName are the ones you saw in wp-config.php.

Hello @mywebguy

You can check our tutorial on How to Transfer Files to Droplets With FileZilla

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

You can access the database using any MySQL client. Another thing is to directly import/export your database. We have this process covered in an article as well:

https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-and-reset-a-root-password-in-mysql

Regards