Lost connection to MySQL server during query

Discussion in 'MySQL' started by phgonline, Jul 7, 2007.

0
  1. #1
    How do I fix this MySQL error?

    Query error:
    INSERT INTO `videos` (`title`, `videourl`, `thumb`, `added`, `status`, `useraw`) VALUES
    ('t_thesettlers_ds_gr.flv', 'e2cf630a4f3e188a16e7d87a5dd82575_tthesettlersdsgr.flv', 'e2cf630a4f3e188a16e7d87a5dd82575_tthesettlersdsgr.flv', '1183829954', 'imported', 'false');

    Lost connection to MySQL server during query

    The website that is getting this error is a video streaming/uploading website. btw the host for this website is godaddy...
    is this a php.ini problem or host?
     
    phgonline, Jul 7, 2007 IP
  2. demacro

    demacro Peon

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    i too had same problem...
     
    demacro, Jul 8, 2007 IP
  3. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #3
    just a timeout on mysql server settings.
     
    gibex, Jul 9, 2007 IP
  4. cabron

    cabron Peon

    Messages:
    324
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #4
    it is possible that the server you are on is overloaded...
     
    cabron, Jul 9, 2007 IP
  5. Mike.

    Mike. Peon

    Messages:
    44
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    If all else fails restart mysql
     
    Mike., Jul 9, 2007 IP
  6. phgonline

    phgonline Peon

    Messages:
    333
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #6
    How do I restart mysql? Also, are there any settings in the php.ini that I need to change
     
    phgonline, Jul 10, 2007 IP
  7. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #7
    linux : service mysqld restart
    windows: go in control panel -> admin -> services -> search for mysql service

    that is a mysql error, not related with php.ini.
     
    gibex, Jul 10, 2007 IP
  8. phgonline

    phgonline Peon

    Messages:
    333
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #8
    It is a linux server but I don't understand your instructions...
     
    phgonline, Jul 10, 2007 IP
  9. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #9
    what distribution you have?
     
    gibex, Jul 10, 2007 IP
  10. phgonline

    phgonline Peon

    Messages:
    333
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Erm, I know nothing about mysql... host is godaddy and server is linux. I am willing to pay if you can fix the errors. I usually get the errors on larger files like 15+ mb
     
    phgonline, Jul 10, 2007 IP
  11. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #11
    are u trying to restore a DB via phpMyAdmin? do you have SSH on that account?
    I can help you to restore it if you have SSH (no charge) , should be a small task for me. send me a pm.
     
    gibex, Jul 10, 2007 IP
  12. phgonline

    phgonline Peon

    Messages:
    333
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #12
    phpmyadmin
     
    phgonline, Jul 10, 2007 IP
  13. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #13
    :) do you have ssh access ?
     
    gibex, Jul 10, 2007 IP
  14. phgonline

    phgonline Peon

    Messages:
    333
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #14
    Do I need ssh access, can I just do it from phpMyAdmin?
     
    phgonline, Jul 10, 2007 IP
  15. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #15
    if script (phpmyadmin) takes more than X minutes(seconds) (you can't remove this limit - server wide on shared hosting), you have to do it via ssh.
     
    gibex, Jul 10, 2007 IP
  16. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #16
    any luck with that issue?
     
    gibex, Jul 11, 2007 IP
  17. phgonline

    phgonline Peon

    Messages:
    333
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #17
    No ssh access with godaddy shared hosting, only with vds or dedicated.
     
    phgonline, Jul 11, 2007 IP