Announcement

Collapse
No announcement yet.

MySQL client run out of memory

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL client run out of memory

    Every time I try to back up my database I get the following (pulled this from the file generated) error. So far I have not been able to back up the DB properly, and my web host has told me it's vBulletin, and I called them on it a couple times but they are sticking to their story.

    ANY HELP IS APPRECIATED!!!

    INSERT INTO pollvote VALUES('67','4','11585','989445968','1');
    INSERT INTO pollvote VALUES('68','4','9606','989446500','4');
    INSERT INTO pollvote VALUES('69','4','9528','989446917','4');
    INSERT INTO pollvote VALUES('70','4','9671','989456363','4');



    <br>
    <b>Warning</b>: MySQL: Unable to save result set in <b>/home/www/clubcobra/forums/admin/db_mysql.php</b> on line <b>92</b><br>

    <!-- Database error in vBulletin Control Panel: Invalid SQL: SELECT * FROM post
    mysql error: MySQL client run out of memory
    mysql error number: 2008
    Date: Wednesday 09th of May 2001 10:20:52 PM
    Script: /forums/admin/backup.php
    Referer: http://www.clubcobra.com/forums/admi...&action=choose
    -->
    </td></tr></table>
    <p>There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>
    <!-- Database error in vBulletin Control Panel: Invalid SQL: UPDATE session SET lastactivity=989464828 WHERE sessionhash='0c4970f43716acee1f2b22ecc74d66f9'
    mysql error: Lost connection to MySQL server during query
    mysql error number: 2013
    Date: Wednesday 09th of May 2001 10:20:52 PM
    Script: /forums/admin/backup.php
    Referer: http://www.clubcobra.com/forums/admi...&action=choose
    -->
    </td></tr></table>
    <p>There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.</

  • #2
    If you have telnet/ssh access do a backup from the command line.
    1. telnet into your system
    2. from the root directory, type mysqldump -uUSERNAME -pPASSWORD databasename > /path/to/dump.txt;
    3. this should only take no more than 30 seconds
    4. when it is completed, it will bring you back to the prompt
    5. verify that you have a dump.txt in the /path/to area you specified


    If you get the same error, your host needs to update their MySQL configuration.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      Thank you very much for the quick response. I'll give it a whirl tonight!

      Cheers!


      -Brent

      Comment


      • #4
        Is this a vBulletin bug then?

        Ok, so doing as you suggested via telnet created the file fine, and it's 125mb big.

        Thank you very much!


        Since this worked, does it mean there's a bug in vBulletin?

        Comment


        • #5
          Not necessarily a bug in vBulletin. It is most likely a combination of constraints put on you by your hosting company to prevent rogue scripts from taking down a server. 125 MB is an awful lot to try and backup through the browser.

          There is a script in the following thread that you can set up to backup your database automatically and either FTP or email it to you. This is actually more efficient than the built in backup and better suited for larger installations like yours.

          http://www.vbulletin.com/forum/showt...ghlight=backup
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X