Webtest4444 Posted June 22, 2007 Share Posted June 22, 2007 Greeting, I hope I posted this in the right sub forum As many other I gained a insterest in Php+Mysql but however I have had alot of trouble. For the first I got Xp home edition so In order to be able to run php and mysql on my computer Im useing the Tool Sokkit 3.5. Right basicly I wish to add info do a database by writing mydb.dump file and "merge it" with database. What I have done is to start cmd then write C:\Sokkit\mysql\bin\mysqladmin -u root create mydb Witch goes well and the database has been created. My next step is to make a text file named mydb.dump containing this info; " CREATE TABLE employees ( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT, first varchar(20), last varchar(20), address varchar(255), position varchar(50), PRIMARY KEY (id), UNIQUE id (id));INSERT INTO employees VALUES (1,'Bob','Smith','128 Here St, Cityname','Marketing Manager'); INSERT INTO employees VALUES (2,'John','Roberts','45 There St , Townville','Telephonist'); INSERT INTO employees VALUES (3,'Brad','Johnson','1/34 Nowhere Blvd, Snowston','Doorman'); " The file is saved in mysql/bin folder named mydb.dump My next step is to enter cmd again and execute this command; C:\Sokkit\mysql\bin\mysql -u root mydb < mydb.dump But apperently nothing happend, I recive the error message File not found :/ Any help will be accepted humbly Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.