-
Posts
6,956 -
Joined
-
Last visited
-
Days Won
1
Content Type
Downloads
Release Notes
IPS4 Guides
IPS4 Developer Documentation
Invision Community Blog
Development Blog
Deprecation Tracker
Providers Directory
Forums
Events
Store
Gallery
Posts posted by Axel Wers
-
-
You can only optimize MyISAM tables with MySQL, so that's normal.
All right ;)You should be able to export the table.
I want to export whole database, all tables togheter. When I export gzip, file is big about 16 MB. When I exported whole database (ibf_sessions table HEAP included) downloading was suddenly aborted around 3,5 MB. I switched that table to MyIsam and gzip was successfuly exported in right size (16 MB). -
OK, now I have this situation:
ibf_sessions table has been switched to HEAP - when I tried to optimize database and export, in both cases I got error message (I wasn't able optimize nor export) and I had to switch ibf_sessions table back to MyIsam. Is it right procedure or can I optimize (export) database without this table? -
Thanks.
Er... mysql server must be restarted then or not? -
Make sure your ibf_sessions table is type HEAP. You can change it in phpmyadmin.
I am running on shared server. Can I use it too, or it's recommended only for dedicated servers? -
ACP - Support:
There is Diagnostics table. But I think that table could be under Admin section. I think it's better for this. Many time when I would like to run some checker first I go to Admin section, and then I say yourself "ahaa diagnostics are under Support section!"
Those checkers are admin tools too, aren't they?
Server Optimalization
in Classic self-hosted technical help
Posted
OK never mind :)
I switched table to MyIsam, exported whole database and then switched it to Heap again.