Migrating a Local WordPress Site from XAMPP

2.75M

EW CMS

1. CMS

Name of Department

2. Agenda

• What is CMS
• Some stats
• Installation
• On hosting
• On local with migration
2

3. Definition

• A Content Management System (CMS) is
software
• create,
• manage,
• publish digital content
• user-friendly interface
• organize, and update
No need for deep technical knowledge or coding expertise
3

4. Key Aspects

5. Components

• Content Management Application (CMA)
• Content Delivery Application (CDA)
• Interface where users create and
manage content.
• System responsible for publishing and
displaying content on the website.
• Examples:
• Handles:
• writing blog posts
• uploading images
• editing pages
• rendering pages
• serving content to visitors
• database communication
5

6. What can you manage?

• website pages
• blog posts
• images and media
• users and permissions
• themes and layouts
• plugins or extensions
6

7. Popular CMS Platforms

8. Software Required to Run a CMS

• Web Server - Responsible for delivering
website pages to users.
• Database System - Stores website content,
user accounts, settings, and posts.
• Examples:
• Common databases:
• Apache HTTP Server
• Nginx
Server-side Programming Language Processes user requests and communicates
with the database.
Example:
•PHP
• MySQL
• MariaDB
Local Development Environment - To develop
websites locally
XAMPP - Includes:
•Apache server
•MySQL database
•PHP
•phpMyAdmin
8

9. XAMPP

10. Advantages and Disadvantages

• easy content management
• performance overhead
• quick website deployment
• security risks if not updated
• plugin ecosystem
• dependency on plugins
• user role management
10

11. CMS Market Overview (Statistics)

• About 43% of all websites on the internet
use WordPress.
CMS
Market Share (CMS market)
• CMS platforms power over 70% of websites
that use a known CMS.
WordPress
~63%
Shopify
~6%
Wix
~4%
Squarespace
~3%
Joomla
~2%
• There are 800+ million WordPress
websites globally.
• Over 60,000 plugins and 10,000+ themes
exist for WordPress.
11

12. Real-World Websites Using CMS

• Websites using WordPress
TechCrunch
Sony Music
BBC America
Microsoft News blog
• Websites using Drupal
• NASA
• Harvard University
• Australian Government
Websites using Shopify
•Gymshark
•Allbirds
•Kylie Cosmetics
12

13. CMS vs Static Websites

Feature
Content updates
Database
Dynamic pages
Ease of use
Flexibility
Complexity
Performance
CMS Website
Easy via admin panel
Yes
Yes
Beginner-friendly
High
Medium
Moderate
Static Website
Requires editing code
No
No
Requires coding
Limited
Simple
Very fast
13

14. Hosting comp

• CMS Hosting
• Static Hosting
• Requires:
• Requires only file storage.
• Web server (Apache/Nginx)
• Database
• Server-side language
• CMS installation
• Typical hosts:
• Bluehost
• Hostinger
• InfinityFree
• Examples:
• GitHub Pages
• Netlify
• Vercel
• These platforms deploy websites directly
from Git repositories.
14

15. Performance Comparison

• Static site request:
• CMS request:
• Browser → HTML file → Display
• Browser → Server → CMS → Database
→ Generate page → Display
15

16. Development Workflow Comparison

• Static Website Workflow
• Write HTML/CSS
• Push to GitHub
• Deploy with GitHub Pages
• Used by:
• developers
• documentation sites
• portfolios
• Better for
portfolio sites
landing pages
documentation
small business websites
• CMS Workflow
Install CMS
Install theme
Add plugins
Create pages in admin panel
• Used by:
businesses
bloggers
e-commerce stores
news websites
• CMS is better for
Blogs, news portals
online stores
university websites
multi-author websites
16

17.

• If you build a portfolio website, would you choose WordPress or GitHub Pages?
Why?
17

18. Free hosting platforms for CMSs

• WordPress.com
• InfinityFree
• GoogieHost
• x10Hosting
• AwardSpace
• Most free hosts have limitations such as:
• limited storage or bandwidth
• slower performance
• no custom domain (or paid upgrade
required)
• limited support
• possible inactivity suspension
18

19. Setting up WordPress on Free Hosting

• Step 1 — Create Hosting Account
Go to InfinityFree
Click Create Account
Confirm email
Create a free subdomain
• Step 2 — Open Hosting Control Panel
• After account creation:
• Click Control Panel
• Open Softaculous Apps Installer
• Select WordPress
19

20. Step 3 — Install WordPress

Field
Example
Site URL
mysite.infinityfreeapp.com
Site Name
My Portfolio
Admin Username
admin
Admin Password
strong password
Admin Email
your email
20

21. Step 4 — Login to WordPress

• Open:
• mysite.infinityfreeapp.com/wp-admin
• Login with the admin credentials.
• Now you can:
install themes
add pages
install plugins
publish content
21

23. Database

• Step 3 — Create Database on Hosting
Step 4 — Import Database
• In the hosting panel:
Open phpMyAdmin in hosting:
• Open MySQL Databases
• Create new database
• Example:
1. Select the database
2. Click Import
3. Upload the .sql file
• Database name: if0_12345678_wp
User: if0_12345678
Password: ********
23

24. Config

• Step 5 — Update wp-config.php
• Step 6 — Fix Site URL
• Edit this file in your hosting:
• Sometimes the site still points to localhost.
• wp-config.php
• Change database details:
• define('DB_NAME', 'if0_12345678_wp');
define('DB_USER', 'if0_12345678');
define('DB_PASSWORD', 'yourpassword');
define('DB_HOST', 'sqlXXX.infinityfree.com');
• In phpMyAdmin → wp_options table
change:
• siteurl
home
• Example:
• http://mysite.infinityfreeapp.com
24

25. Easier Migration Method (Recommended)

• On Local WordPress
• On Live WordPress
• Install plugin
• Export → File
• Download .wpress
• Install same plugin
• Import .wpress
25

26. References

• https://thiel.com/simplifying-the-complex-part-1-content-management-system/
• https://www.thealien.design/insights/cms-website-development
• https://sqmagazine.co.uk/cms-market-share-statistics/
• https://www.navaweb.com/most-popular-cms-for-websites/
26

English Русский Rules