-----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----- -- TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ : http://trilug.org/faq/ TriLUG Member Services FAQ : http://members.trilug.org/services_faq/ TriLUG PGP Keyring : http://trilug.org/~chrish/trilug.asc
