error in your sql database

Discussion in 'MySQL' started by MidwestMerchant, Jan 9, 2007.

  1. #1
    can't figure out why this isnt working when i try to load the database via phpmyadmin..any ideas?

    heres the code
     
    MidwestMerchant, Jan 9, 2007 IP
  2. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Remove the  and it should work.
     
    maiahost, Jan 9, 2007 IP
  3. MidwestMerchant

    MidwestMerchant Banned

    Messages:
    804
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thats the strange part.when I open it in notepad and wordpad, thats not in there??
     
    MidwestMerchant, Jan 9, 2007 IP
  4. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I've seen that problem before and it had to do with the .sql file. Can you open it with notepad and insert it as an SQL query to see if you get the same thing?
     
    maiahost, Jan 9, 2007 IP
  5. MidwestMerchant

    MidwestMerchant Banned

    Messages:
    804
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Good idea! Gave me a different error this time

     
    MidwestMerchant, Jan 9, 2007 IP
  6. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #6
    That's cause it's really empty :) How did you export it or where did you get the file from.
     
    maiahost, Jan 9, 2007 IP
  7. MidwestMerchant

    MidwestMerchant Banned

    Messages:
    804
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #7
    dangit..I got it with a script I just purchased..the sql file is over 400kb i cant see how its empty..lol..hmm..i dunno :\
     
    MidwestMerchant, Jan 9, 2007 IP
  8. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Well just download it again. Download might be broken (if it's a direct .sql dl). I don't think that these 7 lines can be 400 k :)
     
    maiahost, Jan 9, 2007 IP
  9. krakjoe

    krakjoe Well-Known Member

    Messages:
    1,795
    Likes Received:
    141
    Best Answers:
    0
    Trophy Points:
    135
    #9
    just remove the set character set lines, and probably the lines for the same on each create table, you'll have created it with whatever the default charset is on your host, so that should get you round it, that is the file is actually more than those few lines posted....once the data is in you can adjust the charet easily at once
     
    krakjoe, Jan 10, 2007 IP