Hi, There are two ways in which you can set up the database for the tutorials. >From the command line you can bring up the mysql prompt as follows:
C:\>cd mysql\bin C:\mysql\bin>mysql --user=root--password=<your root password> You will then see the following: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 22 to server version: 3.23.51-max-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> >From this prompt you can write SQL statements. Thus the first thing you should type is: mysql> create database music; which will create your new 'music' database. To get the table structure and data into this database type: mysql> use music which returns: Database changed then type: mysql> source [full path to .sql file]database\music.sql This will create the tables and enter the data for the two tables used in the tutorials. Alternatively you can use a product called mysqlfront which is available to download from http://efux.de/mysqlfront/MySQL-Front_2.5_Setup.exe This is a front end client which is a lot more user friendly than using the command prompt. It makes setting up and maintaining databases a lot easier. It also has a SQL Query window which would allow you to paste in the sql statements contained in music.sql Once the database has been set up you will need to set up an ODBC connection and instructions on how to do this are contained in the tutorial. If you have any further issues please do not hesitate to contact me. Regards, Fergal Fergal Donlon Technical Engineer Witango Technologies, Suite 4, Level 1, 44 Miller Street, North Sydney, 2060 ****************************************************************** CORROBOREE 2003 - September 22nd to 26th 2003 - San Diego, CA, USA Witango Developers Conference and Training This year the format is a little changed. We will be combining the Developers Conference with Training sessions at all levels to ensure that the week provides the optimum opportunity for members of the community to advance their skills and broaden their approaches to Witango programming techniques. Look forward to seeing you there !! ********************************************************************* ----- Original Message ----- From: "Barbee, Leslie A Jr" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 5:20 AM Subject: Witango-Talk: Problem Getting Witango Tutorial's Database Working > I am trying to work the Witango Tutorial on a Win2000 computer. The > instructions on page 7 suggest installing and using MySQL to be able > to use the tutorial's database called Music. I installed MySQL, and it is > up and running as a service. The tutorial's instructions on page 7 also > say that it includes a script in the ~/Database/Music folder which will > run with MySQL to define the Music database and its data. I have found > 2 files there called music.sql and music_structure.sql. The instructions > don't explain how to run the script. Not having any experience with > MySQL, I have scanned throught its documentation, and tried running > the files as batch files, i.e. mysql < music.sql, but get an error message > Error 1046 at line 12: No Database Selected. Can anyone tell me how > to get this tutorial database set up and running? Thanks! > > Les Barbee > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
