1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

how to import .sql file to database, to big for phpmyadmin, no ssh

Discussion in 'MySQL' started by tyggemannen, Aug 30, 2006.

  1. lordlisa

    lordlisa Peon

    Messages:
    58
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #21
    tyggemannen, just contact your host & ask them to do this job its the only better solution for u
     
    lordlisa, Sep 7, 2006 IP
  2. dddougal

    dddougal Well-Known Member

    Messages:
    676
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    108
    #22
    I always get my host to do this, they can do it in seconds.
     
    dddougal, Sep 8, 2006 IP
  3. tyggemannen

    tyggemannen Guest

    Messages:
    842
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #23
    I dont see how the host could do support on my database scripts. As I said I get the error in the browser:
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

    When you say that my host should fix it, do you mean that I get this error because the .sql file is not imported correctly ? Or did you not just read this whole tread ?
     
    tyggemannen, Sep 8, 2006 IP
  4. lordlisa

    lordlisa Peon

    Messages:
    58
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #24
    tyggemannen, please post the error you are getting
     
    lordlisa, Sep 8, 2006 IP
  5. tyggemannen

    tyggemannen Guest

    Messages:
    842
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #25
    Hi again lordlisa. The error I get in the browser is:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
     
    tyggemannen, Sep 8, 2006 IP
  6. lordlisa

    lordlisa Peon

    Messages:
    58
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #26
    tyggemannen, the shows that you are importing MySQL database to a older version of MySQL. Please let me know wht version are you using now ?
     
    lordlisa, Sep 8, 2006 IP
  7. Alvin

    Alvin Notable Member

    Messages:
    2,076
    Likes Received:
    164
    Best Answers:
    0
    Trophy Points:
    210
    #27
    Alvin, Sep 8, 2006 IP
  8. tyggemannen

    tyggemannen Guest

    Messages:
    842
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #28
    My server has 4.1.19-standard
     
    tyggemannen, Sep 9, 2006 IP
  9. Foggy

    Foggy Link and Site Buyer

    Messages:
    924
    Likes Received:
    159
    Best Answers:
    0
    Trophy Points:
    0
    #29
    Maybe I need to change hosts. Some hosts I use don't help even when the fault is clearly theirs! (Sorry for going OT)
     
    Foggy, Sep 12, 2006 IP
  10. Katmassive

    Katmassive Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #30
    worked great trick is to convert ur phpmyadmin export then use the new file to restore if u get that line 1 error :cool:
     
    Katmassive, Aug 31, 2008 IP
  11. bidder

    bidder Active Member

    Messages:
    431
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    60
    #31
    i have 250mb sql (sql text) to import how can i do that?

    thanks.
     
    bidder, Sep 1, 2008 IP
  12. party

    party Peon

    Messages:
    60
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #32
    party, Sep 5, 2008 IP
  13. fletd09

    fletd09 Peon

    Messages:
    320
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #33
    fletd09, Sep 5, 2008 IP
  14. pdtgid

    pdtgid Peon

    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #34
    Bigdump not always works perfectly because of version conflict. i also want to import a large file but it failed to do job. As i contact it suggest to create a small .sql file in your text editor then import them one by one. he more said that his script (bigdump) also use this tecnique
     
    pdtgid, Nov 1, 2008 IP
  15. CodeShop

    CodeShop Active Member

    Messages:
    137
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    #35
    CodeShop, Aug 28, 2009 IP
  16. sibangor

    sibangor Peon

    Messages:
    6
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #36
    i thought you must split query on your file

    or you can ask your admin hosting to restore your database
     
    sibangor, Aug 28, 2009 IP