How to transfer large WordPress files

This article will help you transfer large WordPress files to your WordPress Hosting.

1. Download all necessary WordPress backup:

  • A copy of your WordPress website files
  • A copy of your WordPress SQL database

2. Access your WordPress Hosting package and get your SFTP credentials

Step 1. Copy your SFTP credentials.

Step 2. To view the password, click Show.

3. Save Database Credentials

Step and open wp-config.php file.

Step 2. Open the wp-config.php file using a text editor or notepad.

Step 3. Take note of the following database details:

/** The name of the database for WordPress */
define(‘DB_NAME’, ‘database_name’);
/** MySQL database username */
define(‘DB_USER’, ‘database_username’);
/** MySQL database password */
define(‘DB_PASSWORD’, ‘(database_pw’);
/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);


Step 4. Access your WordPress website backup files and locate wp-config.php.

Step 5. Open the wp-config.php file using a text editor or notepad.

Step 6. Replace the database details with the one from your WordPress Hosting wp-config.php file and save it.

4. Upload WordPress Files

Step 1. While connected to your SFTP, access your WordPress backup files and upload.

Step 2. Overwrite all WordPress files from the remote site.

Step 3. Wait for the upload to finish.

5. Import SQL Database Backup

Step 1.  open phpMyAdmin

Step 2. A new tab will open which will redirect you to your WordPress database.

Step 3. Remove all existing tables. ( This part is optional. If you do not want to remove the existing tables, proceed to Step 6.) Select All tables.

Step 4. With Selected, select “Drop”.

Step 5. Click “YES” for Do you really want to execute the following query.

Step 6. Click the database name and click Import.

Step 7. Choose the SQL backup file and click “Go”.

Step 8. Once done importing the database, access your WordPress site.

If in case you will see an error message when you access your WordPress website, kindly double check the database configuration details and make sure they are all correct.

If you are using a different domain name, make sure to update the site URL and home URL in the database.

Update the site URL and home URL in the database

Step 1. In your phpMyAdmin, click on wp_options table. (Note: Some tables may have a different prefix. This depends on how you set it up. Some prefix may be random words or a combination of letters and numbers. You just need to look for the _options.)

Step 2. Look for the siteurl and home in the option_name.

Step 3. Click on Edit button or the pencil icon. 

Step 4. Enter the new URL in the option_value field and click on Go. Make sure that you change both the siteurl and home.

  • wordpress, largefiles
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Add New WordPress Site

Follow the instructions below on how to add a New  WordPress Site. Step 1. Log in to your...

Create WordPress Staging Site

A staging site clones your current live production site on a separate environment. This allows...

Add Multiple Domain Names on a WordPress Hosting

You can add multiple domain names for your WordPress Site. These domain names must use Vodien’s...

Transfer WordPress Staging Site to Live Production

Transferring Staging Site to Live Production will transfer any changes made in Staging to your...

Access WordPress Panel

Follow the instructions below on how to access your WordPress panel also known as WordPress...

Powered by WHMCompleteSolution