|Using CSIM SQL server|
Using MySQL with MySQL-Front
Using MySQL from MS Access
Im/Exporting from/to a file
CSIM network runs a SQL server for your benefit. This server is based on the widely used open source MySQL software.
The MySQL server is installed on a dedicated machine called database.cs.ait.ac.th.
As a user of CSIM system, you have an account open on the MySQL server. Your account has the same user name and password as your normal Unix or samba account. When you change your Unix password, with the web page for account management, it will also change your MySQL password.
Note: if your account on CSIM system was created before the MySQL server was installed (before November 15th, 2001), you have to first go to the web page for account management and change your password once to open your MySQL account.
You can read online documentation in HTML format, there is a special section about calling MySQL from a Perl script. Usefull information can also be found on DevShed.
You have access to a database that is created for your own usage, it has the same name as your user name on Unix or samba. Among the many databases available on the server, you can only use the one that has your user name. For security reason, you can use this server only from CSIM network.
As a summary:
|User name:||your user name|
|Database:||your user name|
CSIM server banyan.cs.ait.ac.th and our web server have the libraries installed to access MySQL server, either directly with the mysql tool or with Perl scripts. Below is an example of a MySQL session on banyan:
MySQL-Front is one of the many free clients for Windows that allow you to create and manage your database with a graphical interface.
This software does not have a fancy installation procedure, just download it and unzip it somewhere (in C:\Program Files\MySQl-Front for example). You will also have to make an entry in C:\Windows\Start Menu.
When you access MySQL-Front for the first time you have to create a new connection. Do not save the connection with your password, else any user will be able to connect to your database.
I noticed the following while using MySQL-Front:
What I especially like with MySQL-Front is the SQL requests that are displayed at the bottom of the screen with ever operation made on the database.
This will come later.
The server is a stand-alone machine, where you cannot store your files; to import data, you can use the command LOAD with the LOCAL:
LOAD DATA LOCAL INFILE 'file_name.txt' INTO TABLE tbl_name
To export files, there is not such an option. Instead you can export data from MySQL-Front if you are using Windows environment, or you can do it via a short program that will read the table reccord by reccord, and store the in a file.
|Contact us: Olivier Nicole||Last update: Nov 2001|