RE: where are the .MYI and .MYD files?
To Jimmy Guerrero, Paul DuBois and Fred Ballard, Your information was very valuable, I already solved the problem, thank you. Misingo :-) Hello, A default install should drop data and databases into C:\Program Files\MySQL\MySQL Server 5.0.\data If you run something like: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: where are the .MYI and .MYD files?
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]
RE: where are the .MYI and .MYD files?
Hello, A default install should drop data and databases into C:\Program Files\MySQL\MySQL Server 5.0.\data If you run something like: mysql CREATE DATABASE test1; Query OK, 1 row affected (0.00 sec) mysql USE test1; Database changed mysql CREATE TABLE t (i INT) ENGINE = MYISAM; Query OK, 0 rows affected (0.10 sec) Then go to C:\Program Files\MySQL\MySQL Server 5.0.\data\test1 Do you see the following in that directory? T.frm T.myd T.myi The files aren't hidden or anything. If you are trying to copy a database/tables from one machine to another, check out: http://dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 4:32 PM To: mysql@lists.mysql.com Subject: where are the .MYI and .MYD files? 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?. 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... In summary, I only can work with my database meanwhile don't restart Windows. Can anybody help me? Thanks in advance. MySQL server version: 5.0.19-nt Microsoft Windows Xp Professional version 2002 SP2. Misingo -- 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]
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. 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]