Problem while importing database

[newmasalaboard]

Hello,

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.

[Lautaro]

I don't really know what that problem means, but i always got erros when trying to upload a very large database so now I use bigdump.

download here:
http://www.ozerov.de/bigdump.php

Open the file with a text editor, add your forum database login info etc then just upload the .php file to your ftp ( any location ).

upload your forum's .sql file to any directory you want ( if you do it outside of public_html it will be more secure ) and remember to edit the path of the .sql file in the bigdump.php..

then run the script and done, it will import the backup to your database very fast ..

[theFM]

as laut said

use bigdump or mysqldumper which ever u like ( google it)

or if you are going to use SSH see this please
http://www.vbulletin.com/docs/html/main/maintenance_ssh_restore

will help you more even if i say what is this and that^^

more info on your problem :-
http://lists.mysql.com/mysql/204022