Database Access - MySQL

Unix web-hosting clients have the option available to purchase a MySQL database to add functionality to their Web site.
For the most up to date pricing on these, we suggest you contact your account manager, or our Corporate Sales department.

What can a MySQL database offer me?

• Ability to handle an unlimited number of simultaneous users.
• Capacity to handle 50,000,000+ records.
• Very fast command execution, perhaps the fastest to be found on the market.
• Easy and efficient user privilege system.

When you recieve your MySQL details you will have been provided with:

• A Username and password to access your database
• A port number to use when connecting
• A MySQL server name (mysql.connect.com.au)

To connect to your MySQL database using PERL you would use a connection string similar to:

	use DBI;
	$hostname = 'mysql.connect.com.au:99999';
	$database = 'testdb';
	$user     = 'myuser';
	$password = 'mypass';
	$driver   = 'mysql';
	$dsn      = "DBI:$driver:database=$database;host=$hostname";
	$db = DBI->connect($dsn, $user, $password);
	

How do I populate my database?

ConnectWeb Unix clients may upload data to their MySQL Database by either using perl/PHP/ASP scripting, or by using FTP to upload a MySQL Dump file, and then using telnet to import the database from the command line.
If choosing the scripting method, clients may use either their own scripts, or by using a third-party, script based "gui" interfaces widely available that have been written in Perl or PHP. (Suggestion: search for "MySQL web interface" at http://www.google.com or similar search engine.)
If using telnet, the MySQL command line interfaces can be found at: /opt/mysql/bin/.

AAPT will not upload clients databases for them, except under very severe circumstances (Eg: databases over 20MB). A fee may be charged for this service.

What if I need help writing my queries?

Please be aware that AAPT will not provide support for structuring SQL queries in customers scripts. If you are having problems with syntax, we suggest you reference the sample scripts, or look online for help. There are many online resources for clients to use.

Some excellent resources that provide examples of syntax are:

  The MySQL homepage - documentation section
    http://www.mysql.com/documentation/index.html
  DevShed - Beginning MySQL Tutorial
    http://www.devshed.com/Server_Side/MySQL/Intro/

Very Large databases