Content:: sysadmin -
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.sqlNote there is no space between -p and the password!
Adding the shell script into the cron job
0 3 * * * root /scripts/sqlbackup.shThis 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.
