Newbie to PHP/ Mysql - simple problem..

[johnmak]

I have a file named exampledb.dump which is in the apache\mysql\bin folder and i cant get it to insert the table data into my exampledb database. heres a pic.

I keep getting an error and i have checked my actual text file 3 times but i will post it below just incase.

CREATE TABLE clients ( id int NOT NULL AUTO_INCREMENT, firstname text, lastname text, userid text, password text, PRIMARY KEY (id), UNIQUE id (id));
INSERT INTO clients VALUES
(1,'Liz','Hall','lhall','sweatpea');
INSERT INTO clients VALUES
(2,'William','Lee','wlee','tulip');
INSERT INTO clients VALUES
(3,'Kevin','Hinds','khinds','daisy');

Any ideas???

 

[sleipnir214]

How are you trying to perform the inserts? Does your PHP code trap and report errors?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[johnmak]

This is done through the DOS panel.

I am simply trying to insert some tables and entrys into the exampledb database on my local machine.

 

[sleipnir214]

Then this isn't a PHP question at all, but rather a MySQL question. I recommend that you post this question to the MySQL forum: forum436

Want the best answers? Ask the best questions!

TANSTAAFL!!