Introduction to MySQL for Website Administrators
Presenter: Eli the Computer Guy
Length of Class: 30 Minutes
Introduction to Website Administration
Purpose of Class
This class teaches new website administrators to be able to understand MySQL Databases for general administration. This class does not delve deep into database architecture and theory, it just teaches what is needed successfully manage a site that uses MySQL to store and retrieve data.
What is a MySQL Database
How to Navigate through a MySQL Database using PHPMyAdmin
How to export, backup a database
How to extract data from a MySQL Database
Databases are used to store data.
MySQL databases are most commonly used for websites because MySQL is open source and free.
MySQL Server software manages databases
A Database is generally the largest unit for storing data
Tables contain information about specific types of data (vendors, employees, parts list)
Columns in Tables store specific information (Frist Name, Last Name, ID Number)
Rows store Records in a Table (All of an Employees Record, or All Information about a Part
Employee Number Last Name First Name Email Address Phone Number
1 Evans Tom firstname.lastname@example.org 444-444-4444
2 Thompson Fred email@example.com 555-555-5555-
Connecting to the Database
Database software allows for Users and Permissions like an Operating System does.
If the Database Server is on the SAME server as the Web Server then you connect to the database using LOCALHOST, if not you use the address of the Database Server
Working with MySQL
You can backup the entire database and restore it by exporting to the SQL format.
You can export TABLES into Excel spreadsheets to easily extract data such as site members email addresses.