database import error

[mannaraja]

Hi

I am changing my forum to new server

Import my database in new server via SSH

I am got following error in ssh.
ERROR 1153 (08S01) at line 32210: Got a packet bigger than 'max_allowed_packet' bytes

How to solve this error.Please any one help me

[chennairam]

Hi

I am changing my forum to new server

Import my database in new server via SSH

I am got following error in ssh.
ERROR 1153 (08S01) at line 32210: Got a packet bigger than 'max_allowed_packet' bytes

How to solve this error.Please any one help me


Brother mannaraja

1st Move Your Files To File System (if it in database ) And album also

So database Size will reduce To below 100mb

i hope You can move Your database Via phpmyadmin



Good luck

may be i am Right or may be i am Wrong


Br.,
Ram

[Marco van Herwaarden]

The only 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 timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

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

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php