ConnectWeb NT - Using MySQL Databases

NT 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 ASP you would use a connection string similar to:

	<%
	myDSN = "Driver={MySQL};DATABASE=mydatabase;SERVER=mysql.connect.com.au;PORT=99999;UID=mycompany;PWD=mypasswd;"
	Set DBConnection = Server.CreateObject("ADODB.Connection")
	DBConnection.Open myDSN
	%>
    

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 NT clients must upload data to their MySQL Database using perl/PHP/ASP scripting.
Clients may use either their own scripts to do this, or one of the script based "gui" interfaces available written in Perl or PHP. (Suggestion: search for "MySQL web interface" at http://www.google.com or similar search engine.)

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/