Looks like it's the max_allowed_packet variable. Maybe set that to like 2 Megs during the import in case you have any larger ones
How do I change that variable for the import only? Can I add it into the import script somewhere, or should I change it on the MySQL server temporarily?
Express Hosting
"We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
I was able to get a successful import. I changed the max_allowed_packet to 16 meg in the my.ini. I also changed the table creation script to make the post_body, and post_default_body mediumtext to handle these whopping posts (it wasn't the first, and it won't be the last.) I chose to do it there as I've been dropping all the tables, recreating everything, and re-importing, and will be doing so at least one more time when I cut over from the classic to the threads.
But, it definitely looks like the worst part is over (wait... that's not true, the users coming forth with their "but this has changed" will probably be the worst part )
Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Originally Posted By: QSS Tim
(wait... that's not true, the users coming forth with their "but this has changed" will probably be the worst part )
Natives don't like change, which is entertaining... Just explaine that the upgrade was nessessary due to more optimized coding and newer features, tends to calm them down
Amen... Been trying to get a user to switch over from Outlook 2002 client that only supports a 2GB PST file so that I can give him 2003 that supports a 20GB PST file.
He has nearly 30Gb of data on the mail server that I want to take off and place on a normal file server, but he doesn't like the look and feel of Outlook 2003
) 
you, 
Previous Topic
Index
