Mickey
|
Posted: 01/10/2004, 10:00 AM |
|
I'm basically just going through the second tutorial: "Creating a Task Management System with the Application Builder"
I got to the part where it stats: "If you use a language such as PHP and ColdFusion, you will later have to configure the server side connection to connect to MySQL or other database."
sorry, i'm a little lost here. How would I get a database like the example intranet one being used into a MySql database on my server and then connect?
-- WinXP Pro,SP6 + IE 6.0; server - Linux + php 4.3 + mysql 4.1
|
|
|
admin
Posts: 45
|
Posted: 01/10/2004, 1:12 PM |
|
The CodeCharge Studio installation includes MySQL scripts that you can use to create your database, usually:
C:\Program Files\CodeChargeStudio\Examples\Internet\Internet_MySQL.sql
C:\Program Files\CodeChargeStudio\Examples\Intranet\Intranet_MySQL.sql
You can copy or FTP the SQL files to your Web server, then create your databases as described in MySQL manual: http://www.mysql.com/doc/en/Batch_Commands.html
In your case you may need to create an empty MySQL database first, then provide the username and the database name when executing the command, like:
Windows (sample):
c:\mysql\bin\mysql < -u [username] - p -D [database] < [filename].sql
UNIX:
mysql < -u [username] - p -D [database] < [filename].sql
For the list of command-line options refer to: http://www.mysql.com/doc/en/mysql.html
|
|
|
lvalverdeb
Posts: 299
|
Posted: 01/11/2004, 11:50 AM |
|
Mickey,
I went thru the same when I started out. Luckily, a friend recommended mySQLFront which is a nice and simple to use Database Manager for mySQL. With mySQLFront you can reverse-engineer the sample databases via ODBC into a new mySQL database. The last stable release of mySQLFront is 2.5 and can be downloaded from http://www.mysqlfront.de
The steps I followed (I assume you've mySQL up and running):
1) Install mySQLFront 2.5 (Don't use version 3 since It is still in Beta)
2) Create ODBC sources for CCSIntranet and CCSInternet access db.
3) Start mySQLFront and create a new databases i.e. CCSIntranet and CCSInternet.
4) From the im/export menu select ODBC import.
5) The rest is self-explanatory.
Good luck
Luis
_________________
lvalverdeb
CR, GMT-6
XAMPP/Ubuntu/CCS3.2/4 |
|
|
|