Alphazeiko
|
| Posted: 09/08/2002, 8:45 AM |
|
Hi there,
first of all: This software is just great!
Well, but i got on question: When i open the portal example, convert it to php, configure my databse connection, which is a MySQL Server, i don't know how the tables are created. I noticed that there is a file *.mdb, which is an Access databse file, but this wouldn't help me create the mysql tables.
So, how would i create the tables in my mysql database....i know i could do it by hand, but *puhh*... :)
Thanks for your answer,
Thomas - Alphazeiko
|
|
|
 |
Alphazeiko
|
| Posted: 09/08/2002, 9:05 AM |
|
well, found *.sql files, did not include them, sorry :)
|
|
|
|
Rob
|
| Posted: 09/08/2002, 4:04 PM |
|
I enjoy cc very much also. I'm new at this as well, and ran across a wonderful php webpage tool that can really save alot of time administering mysql. It's called something like - and get it from: "www.phpMyadmin.net". It needs to be on the webserver, needs security considerations and needs mysql root privleges for it to work. You can load "yourdata.sql" files from it as well -(if you got them, and if you don't- then the db and table creation is very simple within the tool). I suggest that you do not experiment with this tool on a production machine! *The cc portal example I got does have a .sql file - maybe you can find one on the cc website.
Take Care
|
|
|
|
Alphazeiko
|
| Posted: 09/09/2002, 4:36 AM |
|
Dear Rob,
yes, i use phpmyadmin which has the wonderful feature to import *.sql files.
Is it possible to generate *.sql files with CCS, because i only found *.mdb files up to now?
Thx, Thomas
|
|
|
|
Robert
|
| Posted: 09/09/2002, 8:54 AM |
|
Hi again,
I have not seen that cc generates any database, or database tables - you need these already created.
Did you look here: C:\Program Files\CodeCharge\Examples\Portal\SQL\ ...and did not find the .sql file ?? That's where cc installs it by default. If it's not there then maybe you can download the example from this page: http://www.gotocode.com/apps.asp?app_id=11 (and choose your language)...I just downloaded the php4T example to verify, and there is a .sql file in there for you to use (assuming you use php4). Maybe your unzipper is not unzipping it completely?
Take Care.
|
|
|
|
|
