No announcement yet.

Problem while importing database

  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem while importing database


    I am trying to import a vbulletin database but when importing it I see "ERROR 1114 (HY000) at line 3963: The table 'session' is full" and I can't go further with the import (it stops at table "session")

    BTW i took a backup of my database with SSH and the size of database is around 550mb.

    Please guide me.

    Actually i am transferring my site from one server to another. I took a backup at old server and this problem is arising while restoring backup into new server.

  • #2
    Run this query:

    DELETE FROM session;

    Then revert your footer template. You made a change somewhere that stopped the Scheduled Tasks from running and clearing out this table on a regular basis.
    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.


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