MyBB Community Forums

I am using wamp server and I tried uploading my 160mb database but I always getting this error:

Quote:#1114 - The table '342536892_sessions' is full

The storage engine is memory on sessions table.

And the php.ini configuration file is:

post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

My backup format is name.sql, is there a way that I can get rid the session table? So I can upload the backup file of my database. Thank You!

Try to upload via bigdump?

(2012-12-28, 07:23 AM)crazy4cs Wrote: [ -> ]Try to upload via bigdump?

Just the same

Try adding this to your mysql config file in wamp (my.cnf) and then restart the wamp server:

tmp_table_size=1G
max_heap_table_size=1G

If it still gives error, try to increase the value from 1G to something higher.

(2012-12-28, 07:55 AM)crazy4cs Wrote: [ -> ]Try adding this to your mysql config file in wamp (my.cnf) and then restart the wamp server:

tmp_table_size=1G
max_heap_table_size=1G

If it still gives error, try to increase the value from 1G to something higher.

Same problem Sir. I've added that on my.ini and tried increasing to a higher value..

Convert your sessions table to InnoDB and upgrade MySQL to at least 5.5 branch.

Strange. There are quite few articles which maybe helpful, doing a quick search:

http://linuxadminzone.com/fix-mysql-memo...e-is-full/
https://www.google.com/search?q=The+tabl...00&bih=799

And btw you don't need to restore the sessions table. You can truncate it.

That will come in handy, thanks! Right now, session tables are in InnoDB and they are working just fine. +REP Both of you guys!