The Arcive of vBulletin Modifications Site.

MySql Packet Size Increase · **Released**: 12-01-2007

Hey

How do i increase the mysql packet size on a linux dedicated server?

im trying to upload a DB and its giving me this error

thanks

Marco van Herwaarden · #2 12-01-2007, 06:13 AM

You get this while restoring a database? Please post the exact message.

Your config file is probably /etc/my.cnf

badboyz · #3 12-02-2007, 01:12 AM

i am trying to re upload my DB which is like 100MB...

on my admin cp it says maximum allowed is 16MB

so i have to increase the packet size in order to import my old database

Marco van Herwaarden · #4 12-02-2007, 08:21 AM

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/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_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/showt...t=mysqlhotcopy

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

Paul M · #5 12-02-2007, 11:49 AM

Quote:

Originally Posted by badboyz

i am trying to re upload my DB which is like 100MB...

on my admin cp it says maximum allowed is 16MB

so i have to increase the packet size in order to import my old database

Those two things are unrelated - Packet size has nothing to do with database size.