Apache Friends Support Forum

hi i recently start using xampp mysql for database creation i created a database set global privileges, login as root and then start creating a table under this database, when i am doing this table is created and ad data entered in the table is also can be visualized but after sometime when we open this database it shows message "No table found"

also in C:\xampp\mysql\data\mydatabse

there are only .opt and .frm files are present, the .MYI and .MYD files are not present

Can anyone please help me

does .MYI and .MYD files save on any different locations then .opt and .frm. Also the problem of NO TABLE FOUND occurs after i transfer database from a server where its is created or when i rename the database

please if anyone can help ...HELP me

Which files and how the data is saved is dependend on the storage engine.

MyISAM saves it using MYI (Indexes) and MYD (Data), .frm (table definition) and .opt (table options) files, InnoDB saves all Indexes and data from all InnoDB Databases in the ibdata1 file.
So for InnoDB it is not possible to save all needed data of one single database by just copying files.

thank you Altrea
yea I was using innoDB for storage but after using MylSAM i no longer have any problem.
thank you again