PDA

View Full Version : Configuring Xampp and Dreamweaver 8 on Vista



GlenConaway
01-21-2008, 04:13 AM
I am trying to make PHP pages that connect to a database in Dreamweaver.
Please bear with me as I am a newbee.
I am testing this out so the database for now will be on my computer on localhost.
I turned off IIS and installed XAMPP.
Apache and MySql are running.
I converted a Microsoft access database to SQL (mySQL), using Database Converter from Zen Wrez.
I put the converted database in C:\xampp\htdocs.
In XAMMP under the Apache Admin button, phpMyAdmin (under tools), my database does not show up. How do I set this up and connect it?

tech_support
01-21-2008, 06:39 AM
You need to import the SQL in phpMyAdmin.

GlenConaway
01-21-2008, 07:21 AM
Many Thanks for the reply,
Ok, I am starting to figure this out. I created a database and named it mydb. Then I imported my database and I am getting errors.
I left the Character set of the file at the default of utf8, unselected partial import and tried different options of SQL compatibility mode (what should I use?).
I am getting an error, apparently something is wrong under three of my colums.

Here is my error:
Error

SQL query:

CREATE TABLE CHRISTIANKARAOKE(
PRIMARY KEY ( R_num ) ,
R_num BIGINT,
C_numC_numK_num_I_numD VARCHAR( 40 ) ,
SOFTWARE VARCHAR( 34 ) ,
SOFTWARE__num VARCHAR( 20 ) ,
SERIES VARCHAR( 35 ) ,
VOL VARCHAR( 10 ) ,
TRACK__num VARCHAR( 10 ) ,
SONG_TITLE VARCHAR( 81 ) ,
SONGTITLElowercase VARCHAR( 50 ) ,
SONGTITLEA_Z VARCHAR( 50 ) ,
LEAD_VOCAL VARCHAR( 10 ) ,
ARTIST VARCHAR( 55 ) ,
ARTISTLOWERCASE VARCHAR( 255 ) ,
ARTISTA_Z VARCHAR( 50 ) ,
STYLE VARCHAR( 40 ) ,
CHRISTMAS SMALLINT,
KEY VARCHAR( 15 ) ,
M / F VARCHAR( 21 ) ,
AGE_GROUP VARCHAR( 20 ) ,
MAGAZINE VARCHAR( 19 ) ,
MEGADISK_num BIGINT,
MEGADISCTRACK_num BIGINT,
MEGAID_num VARCHAR( 50 ) ,
DUET SMALLINT,
NEWADITION SMALLINT,
MAG_num_TRACK VARCHAR( 10 )
);

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR(15),
M/F VARCHAR(21),
AGE_GROUP VARCHAR(20),
MAGAZINE ' at line 19



Is there a way to fix this?

tech_support
01-21-2008, 07:41 AM
You'll need to create a database first.

GlenConaway
01-21-2008, 08:28 AM
Thanks for the reply,
read my previous post which I edited before I saw your reply,
thanks

tech_support
01-21-2008, 08:50 AM
CREATE DATABASE `CHRISTIANKAROKE`;
CREATE TABLE `CHRISTIANKAROKE`.`CHRISTIANKARAOKE`(
PRIMARY KEY ( R_num ) ,
R_num BIGINT,
C_numC_numK_num_I_numD VARCHAR( 40 ) ,
SOFTWARE VARCHAR( 34 ) ,
SOFTWARE__num VARCHAR( 20 ) ,
SERIES VARCHAR( 35 ) ,
VOL VARCHAR( 10 ) ,
TRACK__num VARCHAR( 10 ) ,
SONG_TITLE VARCHAR( 81 ) ,
SONGTITLElowercase VARCHAR( 50 ) ,
SONGTITLEA_Z VARCHAR( 50 ) ,
LEAD_VOCAL VARCHAR( 10 ) ,
ARTIST VARCHAR( 55 ) ,
ARTISTLOWERCASE VARCHAR( 255 ) ,
ARTISTA_Z VARCHAR( 50 ) ,
STYLE VARCHAR( 40 ) ,
CHRISTMAS SMALLINT,
KEY VARCHAR( 15 ) ,
M / F VARCHAR( 21 ) ,
AGE_GROUP VARCHAR( 20 ) ,
MAGAZINE VARCHAR( 19 ) ,
MEGADISK_num BIGINT,
MEGADISCTRACK_num BIGINT,
MEGAID_num VARCHAR( 50 ) ,
DUET SMALLINT,
NEWADITION SMALLINT,
MAG_num_TRACK VARCHAR( 10 )
);


Oh wait, didn't read the reply properly. There's something wrong with your table SQL. Just try creating it in phpMyAdmin.

GlenConaway
01-21-2008, 09:28 AM
Many thanks for the reply,
I have a microsoft database table that has many records in it.
I need to get all these records in my database.
Can I do this by creating it in phpMyAdmin?
I was thinking converting it to sql would be easier?
I was using Database Converter from Zen Wrez, but this must have created some errors.

What’s the best way to do this?
Thanks.