PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |
Old July 17th, 2005, 10:36 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Oct 2004
Location: Florida
Posts: 318
System REBOOT - closing tables - repair

Everything is functioning properly, but when my server goes through a REBOOT for maintenance updates automated or otherwise, I encounter the following situation:

After the REBOOT, running a MySQL check on the vBulletin database brings up several tables with the following error:

myuser_vbul.adv_gallery_categories
warning : 1 client is using or hasn't closed the table properly

myuser_vbul.adv_gallery_customfields_entries
warning : 1 client is using or hasn't closed the table properly

myuser_vbul.adv_gallery_images
warning : 2 clients are using or haven't closed the table properly

Is there a way to prevent this other than a ***MANUAL*** repair of the databases throughMySQL Account Maintenance?

Is there a proper way to gracefully shut down MySQL prior to a reboot?

A MySQL "repair" fixes everthing, but not until I manually intercept the situation.
oldengine is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
question about closing images Ramses How Do I? - vBulletin 3.5.X 4 October 2nd, 2005 05:32 PM
Closing / Hiding categories in PP NSXTC General Discussion 1 December 15th, 2004 02:28 PM
How many Tables kevinrstruck General Discussion 3 October 19th, 2004 07:02 PM


All times are GMT -5. The time now is 10:33 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0