"???" <[EMAIL PROTECTED]> wrote: > I have a problem in using mysql in my server: Redhat 8. > when i use the database ,i get the err message: > > mysql> use db00010 > Reading table information for completion of table and column= > names > You can turn off this feature to get a quicker startup with -A > > Didn't find any fields in table 't00060' > Didn't find any fields in table 't00061' > Didn't find any fields in table 't00063' > Didn't find any fields in table 't00064' > Didn't find any fields in table 't00067' > > and when i select the t00060: > mysql> select * from t00060; > ERROR 1033: Incorrect information in file:= > './db00010/t00060.frm' > > but the t00060.frm is really at the directory...
What is the type of the above tables? InnoDB? > > I don't know why . And it happens often. In old times i copy= > backup file to overwrite it.(This way i lost many data) > But today i have no backup files. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]