for me it's as easy as:
Code
[root@vnc ~]# ./optimize.sh
Table   Op      Msg_type        Msg_text
ubbage.ubb7_ADDRESS_BOOK        optimize        status  Table is already up to date
ubbage.ubb7_ADMIN_SEARCHES      optimize        status  Table is already up to date
ubbage.ubb7_ANNOUNCEMENTS       optimize        status  Table is already up to date
ubbage.ubb7_BANNED_EMAILS       optimize        status  Table is already up to date
ubbage.ubb7_BANNED_HOSTS        optimize        status  Table is already up to date
ubbage.ubb7_BANNED_USERS        optimize        status  Table is already up to date
ubbage.ubb7_CACHE       optimize        status  Table is already up to date
ubbage.ubb7_CACHED_PERMISSIONS  optimize        status  Table is already up to date
ubbage.ubb7_CALENDAR_EVENTS     optimize        status  Table is already up to date
ubbage.ubb7_CAPTCHA     optimize        status  Table is already up to date
ubbage.ubb7_CATEGORIES  optimize        status  Table is already up to date
ubbage.ubb7_CENSOR_LIST optimize        status  Table is already up to date
ubbage.ubb7_DISPLAY_NAMES       optimize        status  Table is already up to date
ubbage.ubb7_fc_bans     optimize        status  Table is already up to date
ubbage.ubb7_fc_config   optimize        status  Table is already up to date
ubbage.ubb7_fc_config_chats     optimize        status  Table is already up to date
ubbage.ubb7_fc_config_instances optimize        status  Table is already up to date
ubbage.ubb7_fc_config_values    optimize        status  Table is already up to date
ubbage.ubb7_fc_connections      optimize        status  Table is already up to date
ubbage.ubb7_fc_ignors   optimize        status  Table is already up to date
ubbage.ubb7_fc_messages optimize        status  Table is already up to date
ubbage.ubb7_fc_rooms    optimize        status  Table is already up to date
ubbage.ubb7_FILES       optimize        status  Table is already up to date
ubbage.ubb7_FORUMS      optimize        status  Table is already up to date
ubbage.ubb7_FORUM_LAST_VISIT    optimize        status  Table is already up to date
ubbage.ubb7_FORUM_PERMISSIONS   optimize        status  Table is already up to date
ubbage.ubb7_GRAEMLINS   optimize        status  Table is already up to date
ubbage.ubb7_GROUPS      optimize        status  Table is already up to date
ubbage.ubb7_IMPORT_MAP  optimize        status  Table is already up to date
ubbage.ubb7_LANGUAGES   optimize        status  Table is already up to date
ubbage.ubb7_MAILER      optimize        status  Table is already up to date
ubbage.ubb7_MEMBER_SEARCHES     optimize        status  Table is already up to date
ubbage.ubb7_MODERATORS  optimize        status  Table is already up to date
ubbage.ubb7_MODERATOR_NOTIFICATIONS     optimize        status  Table is already up to date
ubbage.ubb7_MODERATOR_PERMISSIONS       optimize        status  Table is already up to date
ubbage.ubb7_ONLINE      optimize        note    The storage engine for the table doesn't support optimize
ubbage.ubb7_POINTER_DELETE      optimize        status  Table is already up to date
ubbage.ubb7_POLL_DATA   optimize        status  Table is already up to date
ubbage.ubb7_POLL_OPTIONS        optimize        status  Table is already up to date
ubbage.ubb7_POLL_VOTES  optimize        status  Table is already up to date
ubbage.ubb7_PORTAL_BOXES        optimize        status  Table is already up to date
ubbage.ubb7_POSTS       optimize        status  Table is already up to date
ubbage.ubb7_PRIVATE_MESSAGE_POSTS       optimize        status  Table is already up to date
ubbage.ubb7_PRIVATE_MESSAGE_TOPICS      optimize        status  Table is already up to date
ubbage.ubb7_PRIVATE_MESSAGE_USERS       optimize        status  Table is already up to date
ubbage.ubb7_RATINGS     optimize        status  Table is already up to date
ubbage.ubb7_REGISTRATION_FIELDS optimize        status  Table is already up to date
ubbage.ubb7_RESERVED_NAMES      optimize        status  Table is already up to date
ubbage.ubb7_RSS_FEEDS   optimize        status  Table is already up to date
ubbage.ubb7_SAVED_QUERIES       optimize        status  Table is already up to date
ubbage.ubb7_SEARCH_AGENTS       optimize        status  Table is already up to date
ubbage.ubb7_SEARCH_RESULTS      optimize        status  Table is already up to date
ubbage.ubb7_SHOUT_BOX   optimize        status  Table is already up to date
ubbage.ubb7_STYLES      optimize        status  Table is already up to date
ubbage.ubb7_TOPICS      optimize        status  Table is already up to date
ubbage.ubb7_TOPIC_VIEWS optimize        note    The storage engine for the table doesn't support optimize
ubbage.ubb7_USERS       optimize        status  Table is already up to date
ubbage.ubb7_USER_DATA   optimize        status  Table is already up to date
ubbage.ubb7_USER_GROUPS optimize        status  Table is already up to date
ubbage.ubb7_USER_NOTES  optimize        status  Table is already up to date
ubbage.ubb7_USER_PROFILE        optimize        status  Table is already up to date
ubbage.ubb7_USER_TITLES optimize        status  Table is already up to date
ubbage.ubb7_VERSION     optimize        status  Table is already up to date
ubbage.ubb7_WATCH_LISTS optimize        status  Table is already up to date

mmmm, yummy homebrew

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!