[TriLUG] mysql db messed up

[Ian Kilgore]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jason Tower wrote:
| got a client with a mysql problem as described below.  if anyone thinks
| they can rectify the problem please contact me offline asap.
|
| jason
| ------------------------------------------
| Issue is... there are several tables that are reporting with 0 rows, but
| are the size of their regular table size with hundreds of thousands of
| rows.  in particular -     products, product_groups, product_categories
| are affected.
|
| You can login to the db via phpMyAdmin here <snip>
|
| As you can see, products says it has no rows, but is 6.8 MB in size.
| if you look at the file contents of  products.MYD - you can see that it
| has a ton of data in it, but somehow the index is corrupted or
| whatever...

REPAIR TABLE products
REPAIR TABLE product_groups
and so on...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQFB5rxtwsRpgTiXSOERAuuGAKCr1x65t2Ptut8A121qeeOVPoSWnACfRoZJ
cAefy9v4Q/KEyRGyXDHjcH8=
=nljQ
-----END PGP SIGNATURE-----