Newbie needs help inserting data into database

Discussion in 'MySQL' started by larryweiss, Sep 11, 2010.

  1. #1
    Following is a file to be used to add sales tax data to a zen cart database.

    The problem is, I don't understand it's use. It is probably a simple cut and past using phpMyAdmin. Can anyone advise me.

    The file begins with:


    And then goes on with hundreds of similar lines.

    Can someone tell me EXACTLY what to do here?
     
    larryweiss, Sep 11, 2010 IP
  2. blackburn2413

    blackburn2413 Member

    Messages:
    45
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #2
    Hey, all those lines of commands are a simple copy and paste into phpmyadmin. Once logged into phpmyadmin create a new database that you are going to use for this. Then select the SQL tab. From there, copy all the commands into there as they are listed. That is where you can run them all and modify \ add things to the database.

    Hoep that helps!
     
    blackburn2413, Sep 12, 2010 IP
  3. bartolay13

    bartolay13 Active Member

    Messages:
    735
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    98
    #3
    ok.. if your not a mysql user, DO NOT edit anything within those file.

    1. access your phpmyadmin, (or any console of mysql)
    2. create a database (you can see this in the home page of phpmyadmin)
    3. open your created database (left side of the gui)
    4. on the tab on top, look for import.
    5. browse that .sql file and import it to your created database
     
    bartolay13, Sep 17, 2010 IP