[gameprogrammer] Re: Anyone know how to fix MySQL problem?

Hello, I had same error but with restoring my sql base backup.
I fixed it by changing max_allowed_packet value both on server and client
computers.
Hope it will help.

On 5/9/08, Kevin Jenkins <gameprogrammer@xxxxxxxxxx> wrote:
>
> Using mysql_stmt_prepare
>
> bind[1].buffer_type= MYSQL_TYPE_LONG_BLOB;
>        bind[1].buffer= (void*) hardDriveData;
>        bind[1].buffer_length= hardDriveDataLength;
>        bind[1].is_null= &falseVar;
>        bind[1].length=&l3;
>
> Fails, with error:
>
> Error: Got a packet bigger than 'max_allowed_packet' bytes
>
> However, previously when I created the table I called SET
> @@max_allowed_packet=1073741824;
>
>
>
> ---------------------
> To unsubscribe go to http://gameprogrammer.com/mailinglist.html
>
>
>

Other related posts: