[EMAIL PROTECTED] wrote:
I've installed MySQL, created a database and tables and then loaded fields into them. I use the command line client and can see the fields, use the select command and every thing is OK, but when I look for the table files in the data directory, only the .frm ones appear, not the .MYI or MYD. Where could they be?.
If you see the .frm files but no .MYI/.MYD files, that suggests that your tables are not MyISAM tables. Try "SHOW CREATE TABLE tbl_name" for some value of tbl_name. Look for the ENGINE = option near the end of the statement. Perhaps when you installed MySQL, you selected InnoDB as the default table type.
I've copied the data files in a flash memory and tried to see the tables fields in another computer with the same server version and platform and get the "db_name.tb_name table doesn't exist" error message. However when I run the show tables command, the command line shows me the list of the tables...
I believe SHOW TABLES only needs to see a .frm file to believe that a table exists.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
