PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Installs and Upgrade - vBulletin 3.0.X (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-0-x/)
-   -   System REBOOT - closing tables - repair (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-0-x/118754-system-reboot-closing-tables-repair.html)

oldengine July 17th, 2005 10:36 AM

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.


All times are GMT -5. The time now is 12:31 AM.

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


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97