Migrating to VPS from Shared Hosting

I have recently done the same thing.

– exported the db from the shared account
– ZIPped the contents of the WP installation on the shared account
– created a new db on the cP account
– import the db export file into this new db
– upload the ZIP to the root of the cP account
– extract the ZIP
– edit the wp-config.php now in the cP account to reflect the new db name and db user (password too if that was changed)
– point your domain to the cP hosting (change the nameservers at your domain registrar to the nameservers for your VPS/cP account)
– wait for them to propagate
– done ??

2ninerniner2, thanks for your speedy response and apologies for my less-than-speedy one.

Will give this a whirl and get back to you with results!

Hmmm… Getting the following error… I was pretty sure that all permissions were 755… Is that right?

SSL connection error
Unable to make a secure connection to the server. This may be a problem with the server, or it may be requiring a client authentication certificate that you don’t have.
Error 107 (net::ERR_SSL_PROTOCOL_ERROR): SSL protocol error.

Ok, that’s coming from me trying to access https and when I go to http and then my VPS’ IP address, I get to the WordPress installation page… That can’t be right, surely? It’s already “installed” by me having uploaded the files from the shared hosting, right?

Just a quick update on this for any one else who may struggle with this like I have!

Managed to do exactly what 2niner2niner said and it was WAY easier! But stumbled upon a wordpress login screen that asked me to re-install wordpress.

In the end, I re-installed wordpress and just uploaded the exported file from the old site to the fresh installed wordpress, with a few minor changes to the memory limits on my VPS server.

Worked a treat after a few tweeks on the old file. Currently using redirecton in cPanel to get the IP address to home page but we’ll get there eventually!

Pretty much everything 2niner2niner said is true, but i ran into a few problems with SQL compatibility (ERROR 1062 (23000) at line XXX: Duplicate entry ‘XXX’ for key ‘PRIMARY’); and rather than zipping/extracting and wasted steps you can:

– Login though FTP and download your wordpress directory
– Backup your Database through myPhpAdmin to SQL (Required Settings: UNCHECK “AUTO_INCREMENT” under create table options, and CHECK “Truncate Table before insert” and “INSERT IGNORE statements”. Optional: Select the datatbase system compatibility)
– Install wordpress on new site
– Upload your backed up wordpress directory over your new install
– Update settings in wp-config.php (check wp from your new install, if installed through your server or script it might already have the settings you need)
– Import your SQL dump
– Update your DNS settings to reflect your new site

Enjoy!

**Update** another issue I ran into (when DNS finished populating) was on VPS & Dedicated Servers mod-rewrite tends to be disabled by default (and in a few ways), so any commands your .htaccess files have will be completely ignored, oh, and this also means ONLY YOUR MAIN PAGE will load. To fix this you just need to enable mod-rewrite on your apache server.

To make sure mod-rewrite is enabled:

– send command “a2enmod rewrite” to your server either through terminal or web interface to ensure it is enabled server-side
– SCP/SSH/File Manager into your VPS and go to “/etc/apache2/sites-available/”
– Edit either the “default” file which would make all changes sitewide or one specifically made for just your wordpress install if there is one (if you used a script to install there would be)
– Change any instances of “AllowOverride None” to “AllowOverride All”
– Restart VPS or at a minimum restart Apache server

Your website should now be fully functional!

I’m also having a problem using “site software” in WHM cpanel after VPS migration a few days ago.

I have several sites and under additional dedicated IP I had a number of true domains that were formerly networked under multi-site.

To get this second main domain to work on the new server – technical support uninstalled the multi-site and reinstalled this and an add on domain with wordpress and my former content data. But I also had a number of “clean” domains – that I had not yet installed with wordpress and after assigning them to this IP domain (so I could keep them in the same account panel of management on my server) I was instructed by tech support to install WP on each of the subdomains using site manager. It seemed simple enough but we didn’t notice the pre-populated subdomain field defaulting to “wordpress” so installed the wordpress on sub domains in a subdirectory – no good. So was instructed to “uninstall” (there was no option to overwrite) and checking in file manager the directories of the sub domains were emptied out or clean – bar hidden filed of .ftp quota which we deleted as well anyway even if not affecting reinstall.

But – there is no way we can install directly to each of the add on domains of that IP main domain account. We can install ONE copy (in addition to the two described above that were existing) but we cannot create any new database and we get a message that there is already an install to that public_html domain. The technical support area of the hosting company say they do not know what the problem is. What to do? We can still install via manual ftp but there are lots of sites to put up. Also I need to reinstall multi-site and am worried about the impact of attempting this with existing issues.

Any guidance is welcome.

ps – that should read “site software” not site manager.