[gameprogrammer] Re: Anyone know how to fix MySQL problem?
- From: "Roman Hwang" <hwang.roman@xxxxxxxxx>
- To: gameprogrammer@xxxxxxxxxxxxx
- Date: Sun, 11 May 2008 12:11:04 +0300
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:
