Importing a site (Wordpress) from a CPANEL user export

This will have a lot of steps but are fairly simple. This guide will also include images along the way to help you out.

Launch a site on NodeHost and upload files

First step is to launch a new site on the NodeHost panel and set your domain. Now just get your SFTP info, you will find it under SFTP in the sidebar, this is how you connect to the site for uploading your files.

Use that info to upload your site files, you will find them in the unzipped folder from CPANEL under homedir and then in that folder your site contents will be under public_html OR a folder with your domain name on it.


Upload the files to your /web/ folder on NodeHost using your local FTP client like FileZilla (PC/Mac) or Transmit/Cyberduck (Mac). Before you upload or after remember to delete our default index.html file we created when you launched the site.

Setup the database

On the panel setup a new database, and use that info to connect to our Database Editor. When you login visit the Import section.


You will find your website database backup in the zip contents under mysql. If the names are for example numbered you can find the correct one by opening your wp-config.php file in your site. it will contain the name of the database you want to restore.


Once done and your database is done edit your sites wp-config.php with the new connection info you set on the NodeHost panel.


Create a .htaccess file

On your FTP program create a new .htaccess file under your main site folder same folder as you see wp-config.php. You will then set the following contents in the file. This allows redirects and the URL's to work properly.


# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
# END WordPress

When done the file should look like this.


All done

You should now have a working site online. Don't forget to enable Let's Encrypt on your domain.