Jump to content

Webtest4444

New Members
  • Posts

    5
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Webtest4444's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Meh I should have been able to figure out that myself > <, mydb.dump.txt , addig the txt part worked and the database now have the info. many times thanks for the help Bubble and Wildbug
  2. Thanks for the reply Did as you asked and upload the result as a picture. Ah and another thing is that I deleted mydb.dump file and made a new one named mydp.dump just to test if it was somthing about the name [attachment deleted by admin]
  3. Currently my logon is default witch means the user name= root and with no password Could it be that Imade the mydb.dump file wrong?, should the file still looklike a notpad icon or should it be somthing else?
  4. Thanks for the reply bubblegum. Tryed your suggestion but it didnt work. Still getting the same error message, should i replace the < symbol with somthing else?
  5. 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
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.