Introduction | Creating the remote database | Creating the local database
OK, so now what?| Deciding on fields | Deciding on an index | Creating the table | Insert some data
Querying the database| Scripted querying | Uploading onto the server

Introduction

This document is a guide to creating, editing, uploading and accessing a MySQL database. This document assumes you have a working basic knowledge of MySQL and the functions involved, if you do not have any knowledge of MySQL and would like to learn I would suggest that you start your quest for knowledge at the MySQL home page where I am sure you will find many tutorials and documents for learning all about the many different features of MySQL, if you would rather purchase a book on MySQL a good choice would be "Sams - Teach Yourself MySQL in 21 days", which is £28.99 available from most bookstores on-line or otherwise with ISBN number 0-672-31914-4. I would suggest that you at least download the MySQL manual, in one of its many forms (HTML, PDF, plain-text etc.) from the MySQL home page as it is an indispensable guide to all the MySQL functions and features.

I personally run the MySQL server on a Linux machine and although I will attempt to cover all the different angles and operating systems that this server can be run on, the different systems may handle things differently and hence you may run into problems - although they should not be any major problems and you should be able to proceed easily.

This document also assumes that you have registered a domain name with Web Wyzard and have a website and web space available.

Getting started

As we are going to create the database locally the first thing that we are going to need is the MySQL server, available from the MySQL home page, on the home page there are many different servers available for many different operating systems so this may seem a bit complicated, but do not worry, the one we are after should be there somewhere. Before we continue you must make sure that you have full access to the system, ie. you must be the systems administrator or have equivalent privileges (in Windows there's no need to worry). Firstly locate the download section for the latest stable version of MySQL (there should be a link on the main page) and download the latest stable version for your operating system, unless you know what you are doing I would suggest downloading the precompiled binaries or executables if they are available. If this is a compressed file (.zip, .tgz, etc) then you will likely need an application in order to decompress it, when you are able to decompress it I would suggest decompressing it into a temporary directory somewhere on your system. There will most likely be some documentation included with this archive explaining how to install and configure the MySQL server, this should be followed exactly, otherwise you may have a wrongly configured server which is of no use to us. The file for explaining how to do all this will be probably be called "INSTALL" or something along those lines, there is also extensive information on installing and configuring the MySQL server in the MySQL manual.

Once the MySQL server has been installed you need to configure a user to access it, because although you can access this MySQL server with your current username, the MySQL server on the main web server will require you to specify a particular username and password, and by having the same details on your local MySQL server any scripts or programs that you create to access the MySQL server should behave exactly the same on the server as they do on you local machine, and hence no editing of any scripts that have been made will be required, so the username can not be just anything, it should be the same as your username on the server, which should be the same as your web site's address without the trailing characters, eg. if the address is `mysqltest.com', then your username would be `mysqltest', you also need to decide on a password for use on the MySQL server. Once all of these have been decided you need to do two things. The first of these is create the database on the remote web server.


Introduction | Creating the remote database | Creating the local database
OK, so now what?| Deciding on fields | Deciding on an index | Creating the table | Insert some data
Querying the database| Scripted querying | Uploading onto the server