problems with mysql database

David Banning david+dated+1186117148.bb0221 at skytracker.ca
Sun Jul 29 05:36:31 UTC 2007


I have recently converted from mysql 4.1 to 5.0 and some of my
tables are not recogized. Using the mysql_upgrade utility is
not effective as -it- does not recognize certain tables. 

On closer examination I see that the tables that are -not- recognize
have the following extensions;

-rw-rw----  1 mysql  mysql  147787 Jul 23 02:44 company.ISD
-rw-rw----  1 mysql  mysql   13312 Jul 23 02:44 company.ISM
-rw-rw----  1 mysql  mysql    9064 Dec  8  2006 company.frm

while the tables that have no problem have different extensions;

-rw-rw----  1 mysql  mysql  3592 Jul 28 23:49 Employees.MYD
-rw-rw----  1 mysql  mysql  1024 Jul 28 23:49 Employees.MYI
-rw-rw----  1 mysql  mysql  9174 Dec 19  2006 Employees.frm

Any idea whats going on here?



More information about the freebsd-questions mailing list