some files created automatically in mysql database folder

[vishal]

i have created one database in mysql. first i have created all tables
are of innodb type then i converted all tables to myisam type. i know
that for each myisam type table three files are created tablename.frm
tablename.myi and tablename.myd.

i have created database before one month. today i checked database and
i show somefiles exist in database folder named
(1)#sql-644_27.frm
(2)#sql-644_1.frm
(3)#sql-638_1.MYI
(4)#sql-638_1.MYD
(5)#sql-638_1.frm
(6)#sql-478_5.frm

can anyone tell me what is these files and why is these files???

thxs for your reply in advance.

[R. Rajesh Jeba Anbiah]

[OT]Re: some files created automatically in mysql database folder

vishal wrote:[color=blue]
> i have created one database in mysql. first i have created all tables
> are of innodb type then i converted all tables to myisam type. i know
> that for each myisam type table three files are created tablename.frm
> tablename.myi and tablename.myd.
>
> i have created database before one month. today i checked database[/color]
and[color=blue]
> i show somefiles exist in database folder named
> (1)#sql-644_27.frm
> (2)#sql-644_1.frm
> (3)#sql-638_1.MYI
> (4)#sql-638_1.MYD
> (5)#sql-638_1.frm
> (6)#sql-478_5.frm
>
> can anyone tell me what is these files and why is these files???[/color]

What's your PHP question? BTW, don't you have MySQL manual?

--
<?php echo 'Just another PHP saint'; ?>
Email: rrjanbiah-at-Y!com Blog: http://rajeshanbiah.blogspot.com/

[Alvaro G. Vicario]

Re: some files created automatically in mysql database folder

*** vishal escribió/wrote (11 Mar 2005 23:05:18 -0800):[color=blue]
> i have created database before one month. today i checked database and
> i show somefiles exist in database folder named
> (1)#sql-644_27.frm
> (2)#sql-644_1.frm
> (3)#sql-638_1.MYI
> (4)#sql-638_1.MYD
> (5)#sql-638_1.frm
> (6)#sql-478_5.frm
>
> can anyone tell me what is these files and why is these files???[/color]

If that happened to me my first approach would be browsing these tables
from my favourite MySQL client.


--
-+ Álvaro G. Vicario - Burgos, Spain
+- http://www.demogracia.com (la web de humor barnizada para la intemperie)
++ Manda tus dudas al grupo, no a mi buzón
-+ Send your questions to the group, not to my mailbox
--

[Gordon Burditt]

Re: some files created automatically in mysql database folder

>i have created database before one month. today i checked database and[color=blue]
>i show somefiles exist in database folder named
>(1)#sql-644_27.frm
>(2)#sql-644_1.frm
>(3)#sql-638_1.MYI
>(4)#sql-638_1.MYD
>(5)#sql-638_1.frm
>(6)#sql-478_5.frm
>
>can anyone tell me what is these files and why is these files???[/color]

Temporary tables. These might be from CREATE TEMPORARY TABLE, or
they might be from a sorting operation (ORDER BY or GROUP BY),
or a copy-and-make-changes operation on a table (ALTER TABLE,
REPAIR TABLE, OPTIMIZE TABLE), or something else.

Normally these are deleted when they are no longer needed. If the
dates on these files are old, perhaps the server crashed while
they were in use.

Gordon L. Burditt