MySQL and PHP: DATABASE PROGRAMMING

MySQL is a powerful database processing package.

We provide setup support for MySQL.  Note we provide no techical support beyond setup. You must be fluent and educated in database and SQL languages yourself to take advantage of mySQL's features. Database programming is very specific and should not be entered into lightly. mySQL databases can be manipulated through PHP, a server-side processing language which our servers also support (see below). There is NO charge for initial database setup.

It is recommended that all users use MySQL, as it is by far the easiest package to use in relation to web pages.  Please note that upgrading between sql packages is not possible.  If you change versions you must start all over from scratch.

SQL literally lives in /usr/local/Minerva/bin, and we have to create the database for you.
To request a SQL database for your account, email us. We require that the database names be in the form "your_username-databade name", such as "charlie-mydatabase"  Please note that the name of the dtabase may be slightly different than what you request.
Other Information:

• PHP/FI HANDBOOK
• mSQL Library -- at Hughs Technology
• MySQL Documentation

It is important to periodically back up your database, as they can become corrupt.  Restoration is usually only possible if you have a backup.  Although we do maintain server backups it is done globally in the event of total server failure, so it is usually not possible to restore just one or two corrupt files on demand.  Make sure to save your backup to your local PC so you have a copy off of the internet, safe from any corruption.

Using the mysqldump command, databases can either be backed up all at once, or one table at a time.  Log into your database server, type mysql, and then run this command:

mysqldump -hdb#.pair.com -uUsername -pPassword Username_Database Table >
Backupfile

where:
# = the pair database server number
Username = login name for the database
Password = password for the database
Username_Database = name of your database
Table = table name; optional
Backupfile = the file the database (or table) will be saved to; doesn't
need to exist before you run this command

PHP is a powerful, flexible, cutting-edge server-side processing language. It is an aggressively-maintained, well-known, and widely-supported freeware package. One of its most popular uses is as an interface to mSQL.  We currently support PHP version 4 (.php) and PHP version 3 (.php3).  For security reasons, it will not process files that end with any other extension.

For further information on using PHP, please visit the PHP homepage.
For further information on using PHP-cgi-wrap refer here.