WordPress Development 10

Lecture Exercise

In today exercise, you will be pair programming with a person sitting next to you. We will also have milestones to complete just like lab exercises.

We’ll try to accomplish these goals tonight:

  1. Set up local WordPress
  2. Personalize local WordPress
  3. Set up Remote Server
  4. Migrate WordPress online

Milestone 1: Set up your WordPress locally

The WordPress.org website has detailed instructions on how to install WordPress and run it locally. However, the guide is too long and has information that you do really need to know.

I will provide a quick and easy way to get WordPress running locally on your computer. Below are the steps:

  1. Install WordPress
  2. Install MAMP
  3. Set up WordPress in local server (MAMP)

Milestone 1.1: Install WordPress

  1. Head over to https://wordpress.org/download/ and dowload the lastest stable version of WordPress (v 4.9.8)
  2. Unzip the WordPress package in a desire position. The directory contains the unzip file is a WordPress software for your website. Your WordPress directory should have the following files:WP files

    Each website requires a separate WordPress software i.e. if you want to make 3 different websites then you will have to install 3 separate WordPress software locally.

Milestone 1.2: Install MAMP

Now, you will need a local server (environment) for the WordPress to run on. WordPress.org has a list of recommended servers. I will use MAMP since it’s easy and will help you understand the science “behind the scene”. There is a new tool called Flywheel that’s gaining a lot of traction lately. I actually like this tool more than MAMP because of its intuitive UI and user-friendly. However, I’ll recommend you to use one other tool first before getting started on Flywheel.

  1. Go to https://www.mamp.info/en/ and download the MAMP free version. MAMP comes with PHP, Apache server, and MySQL server.
  2. Open MAMP and click on ‘Start Server’
  3. When the Apache server and MySQL server are all set up (green light), click on ‘Open WebStart page’ to start the local server. It will open a new tab on your web browser. The URL is either http://localhost:8888/MAMP/?language=English (on Mac) or http://localhost/MAMP/?language=English (on Windows)MAMP
  4. This is a Start page, where you interact with your local server. Click on phpInfo to be taken to the information page of PHP and Apache. Click on Tools > phpMyAdmin to be taken to the MySQL databases that contain all data of your websites.
  5. We will need a database for your new website (if there are 3 websites, there will be 3 different databases). Go to phpMyAdmin and click on New in the left panel. On the right panel, type “my-first-wp-site” in the database name. Collation is a set of rules that determine how data is sorted and compared. Pick “utf8_general_ci” as it is the most common collation. Then click Create. You will be taken to the Structure tab of your database. The database is empty because there is no table.phpMyAdmin

    When WordPress is set up with this database, there will be additional 12 tables added by WordPress. You can also create an additional custom table for your custom plugins but we won’t go into that now.

Milestone 1.3: Set up WordPress in MAMP

  1. Remember the unzip wordpress package that we did in step 2? Change the folder name from wordpress to my-first-wp-site (same name as database name).
  2. Manually move (copy-paste or drag-drop) the my-first-wp-site folder to inside the /MAMP/htdocs folder. htdocs folder is where all your wordpresses (websites) live.htdocs
  3. Now, go back to your MAMP Start page by click on the “Open WebStart page” on MAMP. Then, click on the My Website tab. You will be taken to http://localhost:8888/ or http://localhost/ depends on your Operation System
  4. You should see something like this:

    Index of /

    Click on the my-first-wp-site hyperlink to start the WordPress set up.

  5. Going through the instructions and click on Let's go! button to be taken to the database connection details page.
  6. Make changes to your database connection details so it looks like below:
    • Database Name: my-first-wp-site
    • Username: root
    • Password: root
    • Database Host: localhost:8888 (or localhost for Windows)
    • Table Prefix: wp_

    Click ‘Submit’

  7. Awesome! WordPress is all set up for the local server. Now, we can start the installation on the server. Click on Run the installation to be taken to the installation page.
  8. Fill the information as below (use your email address):WP installation details

    We use root for default username and password. You can change it later when you are more familiar with WordPress. Click on Install WordPress when you are done.

  9. Success! WordPress has been installed. Now you can log in to your local WordPress Dashboard using the default username and password.WP Dashboard

Milestone 2: Personalize your local WordPress

Go to ../my-first-wp-site/wp-admin/. This is a dashboard for you (the administrator) to manage your WordPress website. Now we will add some content to your site such as Posts, Pages, and Main Menu.

Milestone 2.1: Publish 2 Posts

  • One post with an image, a youtube video, and some ipsum text (categorize and tag your post)
  • One post with a featured image and some ipsum text (categorize and tag your post)

You can also just grab some random posts from the internet for your content (try this http://catsinternational.org/articles/). Right now, we only focus on the technical aspect of WordPress.

Milestone 2.2: Publish 2 Pages

  • About Me page: content about yourself
  • Contact page: how online people can reach you (e.g. Address: 12 Tôn Đản, Bến Nghé, Quận 4, Hồ Chí Minh 700000; Phone: 0122 474 2431; etc.)

Milestone 2.3: Create a Main Menu

  1. Go to Appearance and give the Menu Name: Main Menu.
  2. Add Contact, About Me, and Sample Page inside the Menu Structure. The Sample Page is a sub item of the About Me page.
  3. Tick ‘Top Menu’ in the Display location and then click Save Menu.

Your WordPress Home page now should look similar to this:

WP Homepage

Milestone 2.4: Manage your database

All the content that you have created so far (pages and posts) are stored in the backend MySQL database. Now, let us take a look at these data

  1. Open the MAMP WebStart page again and go to phpMyAdmin
  2. Click on the my-first-wp-site database on the left panel. Notice that WordPress has created 12 tables with prefix “wp_” after the WordPress installation in Milestone 1.3
  3. Locate the wp_posts table and click on Browses. Now, you can see all your posts’ and pages’ content are in the post_content columnwp_posts

    Equivalently, you can also just run this sql script in the SQL tab to get the same result:

    SELECT * FROM `wp_posts`
  4. Now, let’s do a bit of SQL while we are here. Sometimes, you need to check some data in the database to troubleshoot issues.The list that we saw above contains all the Posts and Pages in your website. However, you only want to view only the Pages. To do that, run this SQL script:
    SELECT * FROM `wp_posts` WHERE `post_type` = "page"

    You have written your first SQL script, and the results return only the Pages. If you want the results to return only Posts, change the post_type to “post”.

Milestone 2.5: Manually install a new theme

  1. Go to https://colorlib.com/wp/themes/ for free themes.
  2. Pick activello and download the zip file (you can pick a different one later). You can upload the Theme by going to Dashboard > Appearance > Themes > Add New > Upload Theme and just upload the theme zip file there. However, I want to add the theme manually.
  3. Unzip the zip file into a folder. The folder should be named activello.
  4. Drop the folder into ../MAMP/htdocs/my-first-wp-site/wp-content/themes/. There are already 3 other theme folders inside the themes folder: twentyfifteentwentyseventeen, and twentysixteen. Your default theme is twentyseventeen.
  5. Go back to your admin Dashboard and you should see the new Activello theme appears in the Themes page. Activate the theme to use it.

Milestone 2.6: Manually install a new plugin

This is similar to how you installed a theme in milestone 2.5. You just need to download the zip file, unzip it and drop the plugin folder into ../MAMP/htdocs/my-first-wp-site/wp-content/plugins/ folder. Then, activate the plugin in the Plugin page.

See how every post has a comment section that anyone can just make a comment on. Now, let’s disable all the comments by using a plugin.

post with no comment

Milestone 3: Set up a Remote Server

Your WordPress website has only run locally on your computer so far. Now, we will push the website into the web. To do that we will need a domain and a hosting server. Have I told you that you can do all of the hostings for free of charge? 🙂

Milestone 3.1: Register a free domain

There are many websites that give out free domains and freenom is one of them.

  1. Go to http://www.freenom.com/ and type in your desired domain name in the Check Availability box. I use my-diy-wordpress-site but you should pick a different name since the same name is probably already taken by me.freenom
  2. Do not use .tk domains. Many host servers have stopped working with .tk domains because these domains are abused by spammers and hackers. The other domains (.ml.ga.cf, and .gq) should be okay. Pick at least 2 domains in case one domain stops working. Here, I’ll pick .ml and .ga, and click Checkout.
  3. Change the Period to 12 Months @ FREE, and click on Continuefreenom-2
  4. Enter your email address at the ‘Review & Checkout’ page. You can also use a temp email instead. Then verify your email address.
  5. After the email verification, you are required to fill in the ‘Your Details’ information. Fill in all the blank fields, tick the ‘Terms & Conditions’ checkbox and click on Complete Order.freenom-3
  6. Now, you are all set. Click on the button Click here to go to your Client Area.
  7. Sign in with your email and password, and go to Services > My Domainsfreenom-4

    I can see now that my two domains are active and ready to be used.

Milestone 3.2: Register a free remote hosting server

You have gotten yourself a domain name, the next step is to get a remote server to host your WordPress website. There are also a lot of websites that provide free hosting. In this lab, we will use InfinityFree

  1. Go to https://infinityfree.net/ and sign up for a new account (don’t close the freenom tab yet, we’ll go back to it later). If you use a temp email, you can re-use the same email that you signed up with freenom.infinityfree-1
  2. When the registration is all done and you are logged in. Click on + NEW ACCOUNT to start a new server. You are allowed to have up to 3 servers per registered account.
  3. We don’t want to use their subdomains so let’s ignore the first option. We want to use our own domain. The domain that we have set up in Milestone 3.1 need to point to these nameservers: ns1.byet.orgns2.byet.orgns3.byet.orgns4.byet.orgns5.byet.org. Otherwise, it won’t work.

Milestone 3.3: Assign a domain name to your remote server

  1. Go back to your domains in the freenom website
  2. Pick one domain and click on Manage Domain
  3. Click on the drop-down Management Tools and choose Nameservers
  4. Choose custom nameservers and fill in like below:infinityfreVe-2
  5. Click Change Nameservers. Now, the changes have been saved successfully!
  6. Go to your remote server in the InfinityFree website. Enter your domain name and click on CHECK.infinityfree-3

    You should receive a congratulation notice saying that your domain is available. Otherwise, check the nameservers in from your domain again.

  7. Now, you will need to provide a Label and Password for your account. Make sure to keep these credentials somewhere safe because you will need them later. I’ll change my account Label to “My First DIY WordPress” and keep the Password the same.
  8. Click on CREATE ACCOUNT.
  9. The server is being set up. The epiz_22****** is your Username. Click on VIEW IN CLIENT AREA.
  10. Wait for a few minutes and then go to your website (mine is http://my-diy-wordpress-site.ml/),
  11. If you see the below for your website, congrats! Your remote server is now live!infinityfree-4

Milestone 4: Migrate your WordPress online

Now, we have an online remote server all set up, and a WordPress website running locally. The last thing we need to do is to migrate our local WordPress online.

Note: All remote servers nowadays provide One-click install WordPress. However, doing this won’t help you understand what happens behind the scene. This practice force you to do things manually which is tiresome but will provide you more insights on how WordPress works specifically, and all the web applications as a whole.

Inside your InfinityFree account, go to the Control Panel (cPanel) by click on the button GO TO CONTROL PANEL. The cPanel is a user interface for all the technical stuff that let remote server owners manage their websites easier.

Now, to push our local stuff online correctly, we will have to do 2 main things:

  • Upload MySQL database online using sql script
  • Upload all WP files online using an FTP tool

Milestone 4.1: Migrate database using a SQL script

  1. In your cPanel, click on ‘MySQL Databases’ to access all your remote databases. There is currently no database because you just set up the server.
  2. Enter a name for your new database and click on ‘Create Database’. My remote database name is: epiz_22047555_my_first_wp_site. This is an empty database (you can check the database by using the online phpMyAdmin).
  3. Now, we need to export our local database and import to the online database. Access your local phpMyAdmin through MAMP, choose my-first-wp-site database and click on the Export tab.sql-export
  4. Leave the default options: Quick export in SQL format and click Go. The tool provides you a sql script that generates all the tables and contents of the my-first-wp-site database. Copy the script.
  5. Open a new file in your text editor and paste the script here. Save the file as my-first-wp-site.sql in your local machine. A copy of your database now sits in this script.sql-export-script
  6. Go to your remote phpMyAdmin in cPanel to access your remote database.
  7. Click on the Import tab. In the File to Import section, upload your my-first-wp-site.sql
  8. Leave default settings for the others. Click on Go to start the database migration. It probably takes just a few seconds.
  9. Click on the Structure tab to make sure that all the tables have been imported correctly.
  10. You can run similar sql scripts as in Milestone 2.4 or examine individual tables to make sure that the contents are correct.
  11. We need to do one last configuration with our remote database: the site url needs to be changed. Browse the wp_options tablewp-options table
  12. We need to change the option_value of siteurl and home. Start with the option_name siteurl, click on Edit and update from something similar to http://localhost:8888/my-first-wp-site to your registered free domain e.g. http://my-diy-wordpress-site.ml/. Click on Go to complete.
  13. Do the same thing for option_name home.Your remote database is now all set!

Milestone 4.2: Migrate WordPress files using a FTP software

Fix the wp-config.php file

  1. Remember your WordPress folder my-first-wp-site that lives in /MAMP/htdocs folder? Make a copy of that outside MAMP and rename it to my-first-wp-site-prod. I don’t want to use the same folder in MAMP because that one is configured for running locally only (dev version). To run on a remote server, it needs to be configured with the remote server details (prod version).
  2. Use your text editor to open the wp-config.php file in the my-first-wp-site-prod folder to make some changes. We need to change the values of DB_NAME, DB_USER, DB_PASSWORD, and DB_HOST.
    • DB_NAME: change my-first-wp-site to the remote MySQL Database Name (e.g. epiz_22047555_my_first_wp_site)
    • DB_USER: change root to the remote MySQL User Name (e.g. epiz_22047555)
    • DB_PASSWORD: change root to the remote MySQL Password (your cPanel Password)
    • DB_HOST: change root to the remote MySQL hostname (e.g. sql211.epizy.com)
  3. Save the wp-config.php file.
  4. Now, we need to use a FTP tool to upload all the files inside the my-first-wp-site-prod folder to the remote server. We will use a popular free FTP software called FileZilla

    Use FileZilla to upload WordPress files

  5. Download FileZilla here https://filezilla-project.org/download.php
  6. Open FileZilla and clicks on File > Site Manager
  7. Name the site infinityfree and fill in your remote server’s HostUser, and Password information. Host and User are FTP hostname and FTP username; this info can be accessed easily in the cPanel right bottom panel. Password is your cPanel/server Password.filezilla
  8. Click Connect and provide your cPanel Password
  9. You know you are connected successfully to the remote server through FTP when you receive these messages:
    Status:         TLS connection established.
    Status:         Logged in
    Status:         Retrieving directory listing...
    Status:         Directory listing of "/" successful
  10. In the remote site, go to htdocs directory. In your local site, go to my-first-wp-site-prod directory. It should look like this:filezilla-2
  11. Now, we will start the file transferring:
    • Select all files in my-first-wp-site-prod folder by pressing Ctrl-A or Cmd-A
    • Move all files from /my-first-wp-site-prod in local to /htdocs in remote to start the uploading process (I have 1760 files total to upload)
    • When there is a ‘Target file exists’ notice, choose ‘Overwrite if different size’ and tick ‘Apply to current queue only’

    This process will take 1 to 2 hours so make sure you have a good internet connection when you are doing this.

Milestone 4.3: Test your remote site

  1. When the transfer is done, first go to the wp-admin portal (e.g. http://my-diy-wordpress-site.ml/wp-admin/)
  2. Username and Password should still be root, then log in
  3. Go to Setting > General, make sure that all the URLs are now pointing to your domain name rather than your local, then click Save Changes
  4. Go to Setting > Permalinks, make sure that all the URLs here are also pointing to your domain name rather than your local, click Save Changes
  5. Now, go to your website (e.g. http://my-diy-wordpress-site.ml/) and it should be a functioning WordPress web application!


    Source: CoderSchool

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s