Duplicator WP Plugin & Digital Ocean

Stumbled upon this - while it is a bit late here is an easy solution.

I use sentora cpanel from sentora.org.

While it is currently not ready for client use, in my opinion, it makes life really easy on a droplet. Steps:

1. have a domain for the “hosting” can be something as simple as a dtdns account subdomain. lets call it xyz.com
2. Create a fresh Ubantu 14.xx droplet with the name identical to your chosen domain name - you need this for the ptr record 2a) Point xyz.com to your droplet
3. update and upgrade the droplet
4. Go to sentora.org and read the current install instructions
5. Copy the install command and paste it into your ssh session to the droplet.
6. set the cpanel subdomain to xyz.com in the setup script ie cpanel.xyz.com - then Follow the bouncing ball…
7. Set up firewall minimal ports
8. Login to the cpanel.xyz.com as zadmin- password displayed at end of install script
9. Create an account for your customer
10. log to your customers account
11. use customers account to create DB and User and then add the customers domain to host the wordpress site (may take a while to propagate - change customers domain named servers to point to the droplet) 12)create customer ftp account 13)ftp the duplicator files up to the customers domain root
12. open browser and run installer and give the appropriate details. Wordpress is now live

Hope this helps - should take about 15 mins (after domains are available) excluding upload times

Additional suggestion is to add swap to the droplet. I tend to use cloudflare and set up both the “hosting” and the customers domain ready to switch to the droplet. this may take 24 hrs (though usually 1 hr) then switch-over to the droplet is almost instantaneous.

I do this sort of thing for run and profit… PM me if you want assistance.

.

In my case** I already have installed the LAMP and PHPMyAdmin working and backup my database.sql**. What should I do, only export this database.sql using PHPMyAdmin? but what the password and host use in my old database?

After several errors i got it import, but I’m with my doubts because DB had the name of my BLOG.SQL, the DROPLET installed Wrodpress create a DB with WordPress.SQL name. When I imported it automatically** MERGE?** because it was all mixed up the database, see in the image below

http://postimg.org/image/9qhyj6ipr/

How to rename the tables that indicated in RED, I want remove this: wp_696xx5w6nk I do not know how to godaddy created this …