skip navigation

www.Hilands.com


Content:: Systems Administration

Systems Administration

System Administrors deal with server maintenance. Normally handling sometimes difficult tasks of keeping servers up and running. The system administrator is the person behind the scenes keeping everything running smoothly. A good system administrator is rarely seen, until problems occur.

Names for the system administrators can vary. System administrator, Systems Administrator, SysAdmin, System Operator and SysOp just to name a few. When hilands.com was a BBS and internet gateway the System Administrators were all SysOps, this term is rarely heard these days.

Servers really aren't much different from desktop workstation. Usually an upgrade in hardware, possible raid array for the hard drives, trimmed down operating system and server software. If you are a Systems Administrator in a windows environment the software can be quite different. Windows XP and Windows 2007 are loaded with a vast difference of tools. Different Windows servers such as enterprise also have more monitoring tools for your system. In the linux world a server will usually be trimmed down, without a GUI interface only ports running will be services for server like apache, or secure shell.

No matter what Operating System you use for your servers ever Sysadmin has quite a few tasks at hand.
Primarily the Sysadmin will deal with:

System Firewalls, System Backups, Security Audits, Log Analysis, Software updates, Documentation


This section will have information on server configurations, software, protocols and security.

LAMP - Linux Apache MySQL and PHP (LAMP)
MySQL Command Reference - Basic MySQL I always seem to forget.
MySQL Backup/Restore @ sixapart.com

Simple Shell Script to backup MySQL DB
#!/bin/sh
DATE=`date +%Y%m%d` ;
mysqldump -a -u <user> -p<password> <database> > file.$DATE.sql
Note there is no space between -p and the password!

Adding the shell script into the cron job
0  3    * * *   root    /scripts/sqlbackup.sh
This should backup the database in the above script every day at 3am.
File might need to be executable if ran this way chmod 755. If you dislike that try sh /scripts/sqlbackup.sh

As you might notice having a password is a way for an intruder to gain access to yet another part of your system.