Amazon S3 provides scalable and reliable storage for static website content such as images, videos, and other media files. By moving WordPress media files to Amazon S3 and serving them through Amazon CloudFront, you can reduce the load on the WordPress server and improve media delivery performance for visitors.
<\/p>\n\n\n\n
Before proceeding, make sure you have:<\/p>\n\n\n\n
In this post, we will explain moving wordpress media to Amazon CloudFront and S3.<\/p>\n
Step 1: Install the following plugins on WordPress.<\/p>\n
https:\/\/wordpress.org\/plugins\/amazon-web-services\/<\/a><\/p>\n https:\/\/wordpress.org\/plugins\/amazon-s3-and-cloudfront\/<\/a><\/p>\n Step 2: Configure your Amazon Web Services account here and create a new user in the AWS console.<\/p>\n Step 3: To create the AWS S3 bucket for your domain, create the new user in AWS and copy the AWS Access Key ID and Secret Access Key.<\/p>\n Step 4: Log in to your server and configure the AWS user using the following command.<\/p>\n Step 5:Go to your WordPress site upload folder and run the following command.<\/p>\n Step 6: In the root folder, you can create a new file named aws-cdn-script.php using the following code.<\/p>\n Step 7: In the URL, you can access this page like http:\/\/sitename.com\/aws-cdn-script.php?remove=true, and after execution, the file will be removed.<\/p>\n\n\n Migrating WordPress media files to Amazon S3 and serving them through CloudFront can reduce the resource usage of the WordPress server and improve the delivery of static content. Before running the migration script, always maintain a verified backup of the database and media files.<\/p>\n\n\n\n After confirming that all media is loading correctly from S3\/CloudFront, the temporary migration script should be removed from the WordPress root directory for security reasons. The migration should also be tested carefully on a staging environment before applying it to a production website.<\/p>\n\n\n\n Moving media files to Amazon S3 reduces the storage and bandwidth load on the WordPress server. It also provides scalable and highly durable storage for images and other static files.<\/p>\n\n\n\n Amazon CloudFront is a Content Delivery Network (CDN) that delivers files from locations closer to website visitors, which can improve media loading performance.<\/p>\n\n\n\n No. WordPress media can be served directly from Amazon S3. CloudFront is optional but recommended when you want CDN-based delivery and better global performance.<\/p>\n\n\n\n How to download files from S3 bucket to local machine or server<\/a><\/p>\n\n\n\n A Guide to upload Images to S3<\/a><\/p>\n\n\n\naws configure<\/pre>\n
aws s3 sync . s3:\/\/bucket-name\/folder<\/pre>\n
<?php\n\n ini_set('display_errors', 1);\n error_reporting(E_ALL);\n\n \/* ======================================================\n This script is NOT FULLY TESTED (not tested on Windows Server either)\n USE AT YOUR OWN RISK - development environment Ubuntu Linux 14.04.3 LTS\n\n The purpose of this script is for small websites and blogs\n to have their existing media to work through Amazon S3\n \n There's a great plugin, WP Offload S3, that we'll be tapping\n into...it works great for new media, but this is a quick\n fix for EXISTING media - media added before you start\n using WP Offload S3.\n\n This script is not fully tested, but should be useful for\n most situations. It does create a backup of your database,\n though it's not tested to work 100% in all hosting scenarios.\n\n Put this file in your WordPress root directory, where wp-config.php is.\n You must also already have these 2 plugins installed and configured:\n - https:\/\/wordpress.org\/plugins\/amazon-web-services\/\n - https:\/\/wordpress.org\/plugins\/amazon-s3-and-cloudfront\/\n\n TURN OFF CACHING if you have it on your site. Re-enable it after\n everything is done.\n\n ======================================================\n STEPS\n\n 1) Manually upload all of your existing \/wp-content\/uploads\/ files to the\n Amazon S3 bucket (the bucket you configured WP Offload S3 to use for new images)\n\n 2) Add and configure plugins (the 2 listed above)\n\n 3) Run this script from the root directory of your WordPress site\n\n ======================================================\n Developer: TJ Nevis\n Website: http:\/\/blog.TJNevis.com, http:\/\/NevisTechnology.com\n More Info: http:\/\/blog.tjnevis.com\/wordpress-and-amazon-s3-quick-fix-for-existing-media-to-be-served-on-amazon-s3\/\n Last Updated: 04\/19\/2016\n ====================================================== *\/\n\n require_once 'wp-config.php';\n require_once 'wp-content\/plugins\/amazon-s3-and-cloudfront\/wordpress-s3.php';\n global $table_prefix;\n\n echo '<h1>Move Existing Media to Amazon S3<\/h1>';\n echo '<h3>By TJ Nevis [<a href=\"http:\/\/NevisTechnology.com?ref=S3Script\" target=\"_blank\">NevisTechnology.com<\/a>] Detailed blog post <a href=\"http:\/\/blog.tjnevis.com\/wp-offload-s3-quick-fix-for-existing-media\/\" target=\"_blank\">here<\/a><\/h3>';\n\n \/* ======================================================\n First step, we're going to back up the database and\n save it in the the root directory of your site (where this file is) \n ====================================================== *\/\n $dbHost = $wpdb->dbhost;\n $dbName = $wpdb->dbname;\n $dbPassword = $wpdb->dbpassword;\n $dbSaveFileLocation = dirname(__FILE__) . '\/backup-' . date('Y-m-d-h:i:s', time()) . '.sql';\n $dbUser = $wpdb->dbuser;\n\n exec(\"mysqldump --user=$dbUser --password=$dbPassword --host=$dbHost $dbName > $dbSaveFileLocation\");\n\n \/* ======================================================\n Let's get set up with by grabbing WP Offload S3 values\n ====================================================== *\/\n amazon_web_services_require_files(); \/\/ Thanks k0nG\n $aws = new Amazon_Web_Services( __FILE__ ); \/\/ Thanks k0nG\n $awsS3 = new Amazon_S3_And_CloudFront(__FILE__, $aws); \/\/ Thanks k0nG\n $bucket = ( !empty( $awsS3->get_setting('cloudfront') ) ) ? $awsS3->get_setting('cloudfront') : $awsS3->get_setting('bucket'); \/\/ If you're using a CDN and the setting is saved, use that for CloudFront URL replcaement, otherwise use the S3 bucket name\n $region = $awsS3->get_setting('region'); \/\/ Thanks k0nG\n $folderPrefix = $awsS3->get_setting('object-prefix');\n\n \/* ======================================================\n Check if the user is requesting to remove the existing media updates\n ====================================================== *\/\n if( isset($_GET['remove']) && $_GET['remove'] ) { \/\/ ?removeS3Update=true\n if( $dbConnection = mysqli_connect($dbHost, $dbUser, $dbPassword, $dbName) ) {\n\n $removeAmazonS3Info = \"DELETE FROM \" . $table_prefix . \"postmeta WHERE meta_key = 'amazonS3_info';\";\n $reversePostContentHref = updatePostContent(\n 'href',\n $table_prefix . 'posts',\n get_site_url( $wpdb->blogid ) . '\/' . $folderPrefix,\n \"https:\/\/$bucket.s3.amazonaws.com\/$folderPrefix\",\n true\n );\n $reversePostContentSrc = updatePostContent(\n 'src',\n $table_prefix . 'posts',\n get_site_url( $wpdb->blogid ) . '\/' . $folderPrefix,\n \"https:\/\/$bucket.s3.amazonaws.com\/$folderPrefix\",\n true\n );\n\n echo 'RUNNING COMMAND: ' . $removeAmazonS3Info . ' - '; \n if( $dbConnection->query($removeAmazonS3Info) ) {\n echo ' <strong>TRUE, ' . $dbConnection->affected_rows . ' rows affected<\/strong><br \/>';\n }\n\n echo 'RUNNING COMMAND: ' . $reversePostContentHref . ' - ';\n if( $dbConnection->query($reversePostContentHref) ) {\n echo ' <strong>TRUE, ' . $dbConnection->affected_rows . ' rows affected<\/strong><br \/>';\n }\n\n echo 'RUNNING COMMAND: ' . $reversePostContentSrc . ' - '; \n if( $dbConnection->query($reversePostContentSrc) ) {\n echo ' <strong>TRUE, ' . $dbConnection->affected_rows . ' rows affected<\/strong><br \/>';\n } \n\n }\n\n echo '<h3>DONE with removing records for WP Offload S3 - reverted back to serving from the local server<\/h3>';\n\n exit(); \/\/ Don't do the rest of the script\n }\n\n \/* ======================================================\n Start fresh, delete data thatis from WP Offload S3 \n ====================================================== *\/\n $wpdb->delete($table_prefix . 'postmeta',\n array(\n 'meta_key' => 'amazonS3_info'\n )\n );\n\n \/* ======================================================\n Grab the attachments from the database, we'll need\n the meta_value (image name), and the post ID it's related to\n ====================================================== *\/\n $picturesToUpdate = $wpdb->get_results(\"SELECT * FROM \" . $table_prefix . \"postmeta WHERE meta_key = '_wp_attached_file'\");\n\n foreach($picturesToUpdate as $picture) {\n $pictureMetaData = serialize(array(\n 'bucket' => $bucket,\n 'key' => $folderPrefix . $picture->meta_value,\n 'region' => $region \/\/ Thanks k0nG\n ));\n\n \/* ======================================================\n Now let's insert the record that WP Offload S3 looks for\n to change the image URL to your S3 URL\n ====================================================== *\/\n $wpdb->insert($table_prefix . 'postmeta', \n array(\n 'post_id' => $picture->post_id,\n 'meta_key' => 'amazonS3_info',\n 'meta_value' => $pictureMetaData\n )\n );\n\n }\n\n if( $dbConnection = mysqli_connect($dbHost, $dbUser, $dbPassword, $dbName) ) {\n\n $hrefMySQLUpdate = updatePostContent(\n 'href',\n $table_prefix . 'posts',\n get_site_url( $wpdb->blogid ) . '\/' . $folderPrefix,\n \"https:\/\/$bucket.s3.amazonaws.com\/$folderPrefix\"\n );\n $srcMySQLUpdate = updatePostContent(\n 'src',\n $table_prefix . 'posts',\n get_site_url( $wpdb->blogid ) . '\/' . $folderPrefix,\n \"https:\/\/$bucket.s3.amazonaws.com\/$folderPrefix\"\n );\n\n echo 'RUNNING COMMAND: ' . $hrefMySQLUpdate . ' - '; \n if( $dbConnection->query($hrefMySQLUpdate) ) {\n echo ' <strong>TRUE, ' . $dbConnection->affected_rows . ' rows affected<\/strong><br \/>';\n }\n\n echo 'RUNNING COMMAND: ' . $srcMySQLUpdate . ' - ';\n if( $dbConnection->query($srcMySQLUpdate) ) {\n echo ' <strong>TRUE, ' . $dbConnection->affected_rows . ' rows affected<\/strong><br \/>';\n }\n\n }\n\n echo '<h3>DONE with adding records for WP Offload S3 to recognize the image on S3<\/h3>';\n\n\n\n function updatePostContent($type, $table, $blog, $s3bucket, $reverse = FALSE) {\n \/\/ $reverse is to remove the post_content updates and put them back to serving locally\n $from = ( !$reverse ) ? $blog : $s3bucket;\n $to = ( !$reverse ) ? $s3bucket : $blog;\n\n return \"UPDATE $table SET post_content = replace(post_content, '$type=\\\"$from', '$type=\\\"$to');\";\n }\n\n?><\/pre>\nConclusion<\/h2>\n\n\n\n
FAQs<\/h2>\n\n\n\n
1. Why should WordPress media files be moved to Amazon S3?<\/h3>\n\n\n\n
2. What is the role of Amazon CloudFront?<\/h3>\n\n\n\n
3. Do I need both Amazon S3 and CloudFront?<\/h3>\n\n\n\n
Related Articles<\/h2>\n\n\n\n
Talk to our experts:<\/strong><\/h2>\n\n\n\n