Max_Packet_size ! We cannot backup our large forum attachment table
Dear webmasters !
I hope you all are in the best of your spiritual and physical health. We are trying to move our vbulletin forum account from dedicated server to VPS but cannot backup the attachment table. We get error in Max_packet_size regardless of what value we put in.
We run a foriegn language forum and a large number of our members post attachments (we write our language script in inpage software and convert that file into graphic file. We post this graphic file as attachment).
I would very much not advise using the above configuration. The configuration options are incurrect and or outdated and the options really depend upon which version of mysql you are running.
Under what mysql config heading are you placing the directive ? Can you paste your current /etc/my.cnf for us to see so we may recommend something for you. Also, what version of mysql are you running currently.