Re: [Phpwebsite-developers] How do I check these things?

[Mike N. <mh...@us...>]

At 2002-03-03 11:12 -0600, bo...@el... wrote:
>Also, if anyone has other ideas of things I could check for.  Please
>include the code snippet to do the check, if you can.

Prior to an upgrade, check for cruft in the database (e.g. tables that are 
obsolete, or not associated with a module). Notify admin if there is a 
problem, and refuse to update.

Prior to upgrading an installation, check all database tables that will be 
modified. If one of the tables is bad notify the admin, and refuse to update.

CHECK TABLE tbl_name
CHECK TABLE tbl2_name
etc.

Optimize tables after changing/modifying their structure.

OPTIMIZE TABLE tbl_name

--
Mike Noyes <mh...@us...>
http://sourceforge.net/users/mhnoyes/
http://leaf.sourceforge.net/content.php?menu=1000&page_id=4