How To Migrate Your Website To Skystra Using cPanel

SkyStra
Sep 15, 2020

This guide gives step-by-step instructions on how to migrate your website to your new hosting service at Skystra using cPanel.

Backup

Backup Files And Folders

At your old host, log into cPanel.

On cPanel, click the File Manager under the Files section:

Next, locate your website directory (your website should be found in the public_html directory, or a subdirectory within the home or public_html folder if it’s an addon domain). 

Select it with your mouse, and click Compress from the top menu bar:

In the pop-up window, select  Zip Archive, and click the Compress File(s) button:

The File Manager will let you know once the backup is completed, so click the Close button once ready:

Download Files and Folders

Locate your new backup file (it will be the name of the folder with the .zip suffix – test2.zip in our case), select it again with your mouse, and click Download from the  top menu bar:

Your browser will prompt you to download the zip backup, go ahead and download it to your computer. 

Make sure you save it somewhere you won’t forget, the Desktop is always a good spot.

Backup Database

Now it’s time to create a backup of our database. 

Go back to cPanel and click phpMyAdmin under the Databases section:

PHPMyAdmin will open in a new pop-up in your browser. Locate your database in the left frame and click it with your mouse to select it, then click the Export button in the top menu bar:

On the next screen, select the Custom – display all possible options option:

Under the Output section, select gzipped in the drop-down menu for Compression option:

Scroll to the bottom of the page and click the Go button:

Download Database

Your browser will prompt you to download the compressed backup of your database. Download it to your computer to a spot you’ll remember. 

Restore

Restore Files And Folders 

On your new hosting service with Skystra, log into cPanel.

Here are steps on how to get to cPanel.

First, we’ll start by uploading the backup of the files and folders using cPanel’s File Manager. 

If it’s your main website, the zip file should be uploaded directly to the public_html directory; if it’s an addon domain – upload it to your addon domain’s directory. 

Head to File Manager, locate the web folder for your site, and click the Upload button in the top menu bar:

Click the Select File button and select the backup file on your computer.

The upload will automatically start:

Once the upload is completed, close the window and head back to the File Manager.

Select the newly uploaded file and click the Extract option in the top menu bar:

Next, click the Extract File(s) button to go to the next step: 

The files and folders from the zip archive will be extracted to the subfolder, so enter that folder (by double-clicking it with your mouse), select all files (by holding the shift key), and click the Move button in the top menu bar:

In the new pop-up window, delete the subfolder name to move all files to the correct directory above:

Restore Database

Next, you need to restore your database backup. Since your hosting service comes with WordPress automatically installed, we first need to empty the existing database before importing your database backup.

Head back to cPanel on your hosting service with us, and click on phpMyAdmin under the Databases section:

Click on your database in the left frame:

Next, scroll down to the bottom of the screen, and click the Check all link:

In the drop-down menu next to it (With select:), choose the Drop option:

Confirm the action by clicking the Yes button on next screen:

This will remove all existing tables from the database, so you can proceed further with the import process.

This is how the screen should look when this has completed (completely empty, and saying there are no tables in the database):

If your database name changed between your old hosting provider and Skystra, we’ll need to edit the database backup file we downloaded previously. Extract the compressed database backup, and open the .sql file in Notepad (on Windows) or TextEdit (on Mac). At the top of the file, find the Database: section and edit the database’s name.

Our example:

Old:

New:

Save the file on your computer.

Head back to cPanel and click on the phpMyAdmin option under the Databases section:

Select your new database on the left, and click the Import button in the top menu bar. Click the Browse button and find the SQL backup file on your computer and select it.

Once ready, click the Go button to restore the backup:

PHPMyAdmin will let you know once the backup has been successfully imported:

If the database username and name didn’t change in this process, you don’t have to do anything else. If these were changed, we need to do one more update to finish the restoration.

Update wp-config.php File

Head to the FileManager again and locate your site’s web directory. Select the wp-config.php file, and click the Edit button in the top menu bar:

Locate the MySQL settings section at the top of the file, and adjust your database name, username, and password fields to match new connection details.

Old:

New:

Save Changes

Click the Save Changes button in the top-right corner when ready:

That’s it! At this point, your website has been migrated over. You can update your nameservers and then wait a few hours for your DNS to update to see your website loading from your new hosting account at Skystra.