Duplicator WP Plugin & Digital Ocean

Question

Hello,

I have been struggling for a few days now to launch my clients new website on my droplet. I have a site fully built on wordpress on a local server and I exported the site using the Duplicator WP plugin. I uploaded the installer.php and zip package via FTP onto the server. Usually when using other hosting services PHPmyadmin and MySQL are preinstalled.

I have read online a lot and have come to the conclusion that I need to install a LAMP stack. During attempting to do this following these two tutorials:

When installing LAMP and executing the code “sudo /usr/bin/mysql_secure_installation” my command line keeps saying “ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)” and I have reset the root password and tried every combination of passwords and nothing seems to be working.

Long story short, I have deployed my installer.php and my zip file into var/www/ and I need to have this site live today. I have installed Duplicator WP on my current default Wordpress setup to “restore” it as many have said online and I can’t seem to find this file.

Please help!

Whiterabbitz · Answer

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: have a domain for the “hosting” can be something as simple as a dtdns account subdomain. lets call it xyz.com Create a fresh Ubantu 14.xx droplet with the name identical to your chosen domain name - you need this for the ptr record2a) Point xyz.com to your droplet update and upgrade the droplet Go to sentora.org and read the current install instructions Copy the install command and paste it into your ssh session to the droplet. set the cpanel subdomain to xyz.com in the setup script ie cpanel.xyz.com - then Follow the bouncing ball… Set up firewall minimal ports Login to the cpanel.xyz.com as zadmin- password displayed at end of install script Create an account for your customer log to your customers account 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 account13)ftp the duplicator files up to the customers domain root 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. .

gilsoninacio · Answer

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?

gilsoninacio · Answer

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 …

Become a contributor for community

DigitalOcean Documentation

Resources for startups and AI-native businesses

The developer cloud

Start building today

Report this

Duplicator WP Plugin & Digital Ocean

Report this

Duplicator WP Plugin & Digital Ocean