> > I've copied the data files in a flash memory and tried to > see the tables
> [EMAIL PROTECTED] and then [EMAIL PROTECTED] wrote: > > 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. Having experienced these problems, and more, related to copying InnoDB files around I'd like to add a few other things. At a minimum, for an InnoDB database you also need to copy the ibdata1 file from the parent directory of where your .frm files are located. Also, the .frm files and ibdata1 files for the InnoDB should be from the same CREATE. I believe the ibdata1 file as well as the .frm files contain -- ironically, since the whole point of databases is to avoid redundant data -- redundant schema-related information. If they are not in sync the mapping between the .frm and ibdata1 information will probably thoroughly mess up your access to the underlying stored database data. Fred > -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 07, 2006 5:49 PM > To: [EMAIL PROTECTED] > Cc: mysql@lists.mysql.com > Subject: Re: where are the .MYI and .MYD files? > > [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. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
