Announcement

Collapse
No announcement yet.

Incorrect information in file: './*****/aaggregate_temp_1231999800.frm'

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

  • Incorrect information in file: './*****/aaggregate_temp_1231999800.frm'

    When trying to backup my DB through VB, I've been getting this SQL error. If I try to back it up through cpanel, it gives me a 300 byte download when my database is 570+mb.

    The problem is in the aaggregate_temp_1231999800 table. Can anyone tell me what this table is for, and possibly the SQL query to go about dropping/re-creating? The only reason I haven't done it yet is because I don't know what keys were in the table (so I can't re-create) and what it's used for.

    Forum version is 3.7.2, trying to back up so I can upgrade to 3.8 :-/

  • #2
    The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.

    Please see the instructions here:

    Backup:
    http://www.vbulletin.com/docs/html/m...nce_ssh_backup

    Restore:
    http://www.vbulletin.com/docs/html/m...ce_ssh_restore

    If you don't have telnet or SSH access, some people have reported success with these scripts:

    MySQLDumper:
    http://www.mysqldumper.de/en/index.php

    MySQLHotxcopy:
    http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

    You can delete any aaggregate_temp* tables.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Thanks for the response, Steve.

      I'm on a managed VPS, and my support team tried to back it up a couple of ways and just said every way failed and that table appeared to be corrupted.

      So, I guess I'll just drop the table. There won't be any ill effects from this? Will I need to re-create it?

      Comment


      • #4
        Juts drop it. That will not produce any problems.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Seems to have worked, I am able to backup now. Thanks again!

          Comment


          • #6
            You're welcome.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              same problem

              I've got the file exactly by the same name.

              I use mysqlhotcopy for back-up. "aaggregate_temp_1239973800.frm" will get copied OK. It is TYPE MEMORY and backed-up it has 0 records.

              Is it safe to drop. Does it do any harm if I keep it in the back-up. I never had to restore, yet.

              Comment

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