ONLY FOLLOW THESE STEPS IF YOU HAVE WORDPRESS VERSION 4.5.24 OR OLDER – WHICH YOU SHOULDN’T – YOU’VE BEEN WARNED.<\/p>\n\n\n\n
WHAT MIGHT STILL WORKS IS REPLACING TEXT WITH MYSQL COMMANDS WHICH IS PART OF MYSQL FUNCTIONS AND HAVEN’T BEEN DEPRECATED<\/p>\n\n\n
Hello Web Developers…<\/p>\n
This is a extensive tutorial\u00a0for those of you who develop with WordPress<\/a>. WordPress is an amazing platform to build on. Either for just a section of your website or as whole CMS<\/a> (Content Management System), WordPress has become the leader platform not only for web professionals, but also for adventurers, that’s right… WordPress is getting Web Developers out of job.<\/p>\n Do not worry, web is not only about website design… there’s a whole lot for web developers in the Cloud than that you can imagine. You only have to dig in a little deeper.<\/p>\n <\/p>\n Now, if you are a WordPress developer, you might bump into a situation where you have to move it from one domain to another, even changing it to a sub folder… this also applies taking\u00a0over an already established WordPress project, to create and\u00a0install it into you localhost playing ground or Sandbox.<\/p>\n It is very simple to do, and you might be surprise how simple it is. To accomplish this task you can do it the easy way or the hard way. Let’s do it the hard way first so you can appreciate the easy way later. This means creating a local copy of the database and WordPress itself.<\/p>\n If you only have to change the location to a different directory under the same URL, just skip to the Easy Way (Step 5).<\/p>\n Importing and Modifying data storage tables on\u00a0MySQL Instance.<\/strong><\/p>\n Before we get started, for this, you will require a couple of MySQL management tools as well.<\/p>\n To execute the steps I will talk about in a couple of paragraphs,\u00a0you need to have access to administrative tools. You can either execute the\u00a0statements I will mention on\u00a0the shell (Terminal, PowerShell or Command Prompt), and also through PHPMyAdmin<\/a>, if it is available to you. Also you can use SQL Management Applications like MySQL Workbench<\/a> (my first option). Some hosting services allows you to connect through a shell using tools like PuTTy, a Windows\u00a0Environment Unix-Base shell to execute shell commands through SSH (Secure SHell). \u00a0For preference, I use BlueHost<\/a>\u00a0for hosting.<\/p>\n To connect to your Remote Host Shell In Linux or Mac OS X you can follow these tutorials: (I haven’t look at these tutorials but I assumed they are OK, for Linux<\/a> and for Mac OS X<\/a>) Also refer to your hosting documentation.<\/p>\n Of course, if you don’t have access to the database you cannot do anything with it, so I am assuming that you have administrative access to it. If you do not, you will need to recreate an SQL Structure\/Data with a third-party plugin as GD Press Tools<\/a>, my personal favorite or other similar plugins. GD Press Tools in no longer available as free version on the WordPress Plugins Repository, so if you are looking for free options just search ‘database backup’ under ‘Add New’ on the Plugins Dashboard.<\/p>\n To create a back up with GD Press Tools it is easy, first go to the Database Section under the GD Press Tools tab on your admin dashboard:<\/p>\n Unchecked the option ‘Save database backup as GZIP archive’ because is buggy and corrupt the file, most of the time.<\/p>\n Click on Backup button, when the process is finished you can download the backup file under the same section where you created it, or by the URL showed at the top of the Settings section, ‘\/wp-content\/gdbackup’ by default. See image above.<\/p>\n Note: This is a good idea also before you make a framework update, from one version to another or backing up your system for DR (Disaster Recovery). Never make updates without backing up your system, consider this before installing or updating plugins as well.<\/strong><\/p>\n If you were able to create the\u00a0SQL back up file, loading it to your local MySQL Instance is quite simple with MySQL Workbench. You can also load it with the shell as well<\/a>. But I will concentrating using a more user friendly tool, of course, the shell it is more trusted. Actually, Workbench uses the MySQL shell on the background, just making it easier for you.<\/p>\n MySQL Workbench is available for Windows, Linux, and Mac OS X, so you can really manage you MySQL in any platform the same way.\u00a0I will not go through the process of installing Workbench, but it is straight forward. Just search for ‘Installing MySQL Workbench<\/a>‘.<\/p>\n When you open Workbench for the first time, you will notice that you MySQL local instance will show up, so there is nothing to configure, assuming MySQL is already installed in your system. If your hosting allows you to connect to your MySQL host remotely, you can skip the backup process and the next instructions, because you can accomplish this more easily Creating a new Connection on\u00a0Workbench<\/a>, and request your hosting for the credential information, this might requires an SSH private key<\/a>.\u00a0But for now let’s keep setting up our local instance.<\/p>\n Click on this instance and enter the credentials you set up during installation (User\/Password), you can choose to save the password if you want, but I do not recommend. I do recommend using the root user when using Workbench.<\/p>\n When you up and running, create a new schema with the same name as the schema of your previous WordPress installation, you can RENAME the schema later, if you want to. I would copy the wp-config.php into the new URL version.<\/p>\n Then you will dump all the data using the backup file you just created. On your left menu bar, click on Data Import\/Restore tab.<\/p>\n Then checked ‘Import from Self-Contained File’, browse for the back up you just downloaded, select schema to dump the information, also in the selection box at the bottom of the screen, select ‘Dump Structure and Data’ and Start Import.<\/p>\n If you have the same MySQL version installed in your local environment, you should not have any problem. If you decided to update to a later version than your hosting, you might encounter DATETIME default values issues. In that case, that it is another tutorial to cover, but not here. If you need help with that now, just click here<\/a>.<\/p>\n You have to set an user for WordPress as well, never use your root user for WordPress, unless you do not mind an stranger snooping around your data.<\/p>\n On the left menu click on ‘User and Privileges’, once clicked, click on the button at the bottom center of the screen that’s labeled ‘Add User’ and you will create an user with the same information you have in the current installation of WordPress wp-config file:<\/p>\n For the moment, make sure you Limit to Hosts ‘localhost’, do not user 127.0.0.1 or % wildcard, for any reason, this does not work, and it is not safe either. Set the Authentication Type to Standard, which is what you need for host based authentication.<\/p>\n When done, press Apply, and when it is processed and registered, go to ‘Schema Privileges’ Tab. Where you will select the schema you created for WP and grant all privileges to that schema only.<\/p>\n Click OK, and the check all privileges check boxes. Make sure to check the ‘GRANT OPTION’ check box as well or WP will not work.<\/p>\n Once this is done… your are ready to install WordPress.<\/p>\n Now you need to install WordPress locally by downloading the files to your server with and FTP Client (Filezilla <\/a>or WinSCP<\/a>). If you are on Windows, I recommend the later.<\/p>\n I am assuming you know how to use the FTP Client and how to download the files, if not check this tutorial<\/a>\u00a0or using FileZilla<\/a>. Once these\u00a0is done and if you kept the credentials the same as it was in the previous installation, you do not need to do anything else. But if you are going to use Microsoft IIS (Internet Information Services) Server on Windows<\/a> as the local server you need to grant WordPress writing privileges only to it’s directories, most importantly the \/wp-content\/uploads. If you are in Apache you can skip to Step 3.<\/p>\n To grant updating and writing authorization to WordPress from the Dashboard, so you can be able to install plugins and make updates, you have to grant this privileges as follow. Locate the WordPress directory and right click for the option menu and select ‘Properties’.<\/p>\n On the Security Tab, click on Edit and add two user, one at a time, IUSR<\/em><\/strong> and IIS_IUSRS<\/em><\/strong>, and set permissions to Full Control if available or select Modify, Write and Read & Execute:<\/p>\n Hit Apply or OK if you are done.<\/p>\n Warning: This will expose your IIS Server as it expose any Web\u00a0Server to WordPress, which means, you need to understand web security\u00a0threat issues. If you think you are safe because you use Linux or Mac OS X, you are fried, read this<\/a>… No one is exempt of cyber attacks, so take all measures possible to avoid being exposed or attacked.<\/p>\n UPDATE<\/strong>: If you still have some problems trying to update or install plugins with a Fatal Error saying it couldn’t find an SSL certificate of the sort, download the Mozilla certificate here<\/a> (right click and save as), save it anywhere you want. If you have your PHP Manager for IIS… would look something like this<\/p>\n Double click it, and look for the php.ini file link:<\/p>\n If you don’t, create a phpinfo.php file and save it somewhere inside your local website with the following code:<\/p>\n Navigate to the php file you just created in the browser and check the location of the php.ini file IIS is reading to render PHP.<\/p>\n The location of your php.ini file might be in a different location, once you spot it, look for the file and run\u00a0your favorite text editor as administrator, and open the php.ini file.<\/p>\n Then look for the curl.cainfo statement, uncomment it and add the URL where you saved the cacert.pem for example:<\/p>\n Remember to enter the location where you saved your file, the image above it is just an example.<\/p>\n Save it and restart IIS, normally changes made on the setting file is automatically populated when using PHP Manager, but just in case reset, I prefer to do it on PowerShell, it’s as simple as typing iisreset<\/strong>:<\/p>\n Remember to run\u00a0powerShell as administrator. Now you should be able to get rid of the pesky Fatal Error.<\/p>\n Now that you have your data storage synchronized and the new instance of WordPress installed in your local folder, let’s update the domain the hard\u00a0way… But if you prefer skip to the easy way on Step 5.<\/p>\n As in many developing languages, SQL let you replace a string with another string by using the REPLACE() method or function. How it works is as follow:<\/p>\n This statement has to be executed on the OPTIONS database, by default Once you have executed this successfully on your localhost is time to do the same in your hosting. (Again, you need access to PHPMyAdmin or the ability to import data into your production server to do this. If not, the hosting administrator have to do it for you.)<\/p>\n In your favorite\u00a0text editor (Notepad++<\/a>, Brackets<\/a>, Visual Studio Code<\/a>) or IDE (Netbeans<\/a> or\u00a0Visual Studio Community<\/a>), my favorites being Notepad++, Brackets and Netbeans*, although Visual Studio Code has a neat integration with GitHub versioning.<\/p>\nREQUIREMENTS<\/h1>\n
\n
![](\"\/\/bluehost-cdn.com\/media\/partner\/images\/raphievila\/468x60\/bh-468x60-03-dy.png\")
<\/a><\/p>\n![\"backing-up-gdpresstools\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/backing-up-gdpresstools.png\")
<\/a><\/p>\n![\"backing-up-gdpresstools-2\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/backing-up-gdpresstools-2.png\")
<\/a><\/p>\n
\nStep 1. Setting up your Sandbox (Localhost Playground):<\/h1>\n
![\"workbench-local-instance\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/workbench-local-instance.png\")
<\/a><\/p>\n![\"New](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/new-schema.png\")
<\/a><\/p>\n![\"data-import\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/data-import.png\")
<\/a><\/p>\n![\"select-import-file\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/select-import-file.png\")
<\/a><\/p>\nStep 2. Setting Up an User<\/h1>\n
![\"creating-user-mysql\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/creating-user-mysql.png\")
<\/a><\/p>\n![\"creating-user-mysql2\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/creating-user-mysql2.png\")
<\/a><\/p>\n![\"creating-user-mysql3\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/creating-user-mysql3.png\")
<\/a><\/p>\n![\"creating-user-mysql4\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/creating-user-mysql4.png\")
<\/a><\/p>\nStep 3. Installing WordPress on your Local Environment<\/h1>\n
![\"granting-access-IIS\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/granting-access-IIS.png\")
<\/a><\/p>\n![\"granting-access-IIS-2\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/granting-access-IIS-2.png\")
<\/a><\/p>\n
\n![\"certificate\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/certificate.png\")
<\/a><\/p>\n![\"certificate2\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/certificate2.png\")
<\/a><\/p>\n<?php\n echo phpinfo();\n?><\/pre>\n
![\"certificate5\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/certificate5.png\")
<\/a><\/p>\n![\"certificate3\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/certificate3.png\")
<\/a><\/p>\n![\"certificate4\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/certificate4.png\")
<\/a><\/p>\n
\nStep 4: Understanding and Executing String Replacement on SQL. Updating the URL the Hard way.<\/h1>\n
UPDATE `table` SET `column_to_be_affected` = REPLACE(`column_to_be_affected` , 'http:\/\/current_url', 'http:\/\/newurl') WHERE `column_to_be_affected` LIKE '%http:\/\/current_url%';<\/code><\/p>\nwp_options<\/code>. Also, you might want to execute it on other tables if you have links pointing to the old url, for example: wp_comments, wp_posts, wp_links. But let me warned you, make sure you replace the url that start with ‘http:\/\/’ prefix, if not you will be replacing other things you might not expect, like emails. So be careful.<\/p>\nStep 5: Updating the URL the easy way.<\/h1>\n
![\"adding-statement-function\"](\"http:\/\/www.designersgate.com\/blogs\/wp-content\/uploads\/2016\/05\/adding-statement-function.png\")
<\/a><\/p>\n