If you have direct MySQL tool access to your existing data you could re-export your data using the mysqldump tool and set the "--max_allowed_packet" option to the same value as the max_allowed_packet size for your new server. That way, if you "source" the resulting dump file into your new server, you will not get the 1153 error because mysqldump would have broken the INSERT statement into chunks small enough for the new server to handle.
I have no idea how to do the same adjustment to an export through phpMyAdmin, sorry. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Michel RENON <[EMAIL PROTECTED]> wrote on 12/01/2004 07:15:24 PM: > Hi, > > Here is my problem : > I want to copy datas from an existing website to my local website. > The website is a collection of images with thumbnails. > With phpMyAdmin, i made an export of the image table and i have a 16 MB > file 'image.sql' containing sql orders to create table and insert > values. > > With phpMyAdmin of local website, I tried to execute that sql file but > got errors related to memory allowed to php (2 MB max). > I tried to modify 'memory_limit', 'upload_max_filesize' in > "/etc/php.ini" but still got errors. > > So I tried with mysql tools. > with "source /path/image.sql;" the table is created but i got the > following error : > ERROR 1153: Got a packet bigger than 'max_allowed_packet' > > I've seen threads in this list about same error, but I feel i'm in a > wrong way... > > What would be a "good" way of doing that export/import of datas ? > What to do if I want to upload bigger datas on the existing website ? > (I only have a phpMyAdmin access) > > Sorry if the answer is obvious, but I'm new to MySQL, phpMyAdmin. > > My local config is PowerMac G4, Mac OS X 10.3.5, MySQL 4.0.21 > > Thanks in advance > > Michel RENON > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
