[SOLVED] repairing a corrupted mysql table on a shared hosting server

frieza · 02-21-2011, 12:56 PM

i was trying to do some maintenance on the database and i have the following problem when looking at the database with phpmyadmin on the site

Code:

              Table                             Ation                                         Records   Type  Collation  Size    Overhead
	uc_order_products_pair_vw 	Browse 	Structure 	Search 	Insert 	Empty 	Drop 	~01 	View 	--- 	unknown 	-
	uc_order_products_qty_vw 	Browse 	Structure 	Search 	Insert 	Empty 	Drop 	~01 	View 	--- 	unknown 	-
	uc_order_products_user_vw 	Browse 	Structure 	Search 	Insert 	Empty 	Drop 	~01 	View 	--- 	unknown 	-

and trying to repair the tables by select all/repair gives the following error

Code:

Table 	                                  Op 	Msg_type 	Msg_text 
dsystems.uc_order_products_pair_vw 	repair 	Error 	'dsystems.uc_order_products_pair_vw' is not BASE T...
dsystems.uc_order_products_pair_vw 	repair 	error 	Corrupt
dsystems.uc_order_products_qty_vw 	repair 	Error 	'dsystems.uc_order_products_qty_vw' is not BASE TA...
dsystems.uc_order_products_qty_vw 	repair 	error 	Corrupt
dsystems.uc_order_products_user_vw 	repair 	Error 	'dsystems.uc_order_products_user_vw' is not BASE T...
dsystems.uc_order_products_user_vw 	repair 	error 	Corrupt

how can i fix this? i don't have access to any command line utilities

Guttorm · 02-22-2011, 07:06 AM

Hi

These are not tables, they are views. There seems to be a bug in phpmyadmin which lets you select a view (among the tables) and then do "repair table" on them. But it's not critical, MySql just gives an error message about it.

If you click on a view to select it, you will see there is no "Operations" tab, as they are meaningless on views.

frieza · 02-22-2011, 12:23 PM

thanks, i had begun to suspect this might be the case after posting this, now i know for sure