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

Problems with the Windows version of XAMPP, questions, comments, and anything related.

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

Postby redhuneeru » 21. June 2013 07:13

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
redhuneeru
 
Posts: 3
Joined: 21. June 2013 07:05
XAMPP Version: 5.6.3
Operating System: windows

Re: only .opt and .frm files are present, the .MYI and .MYD

Postby redhuneeru » 21. June 2013 07:48

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
redhuneeru
 
Posts: 3
Joined: 21. June 2013 07:05
XAMPP Version: 5.6.3
Operating System: windows

Re: only .opt and .frm files are present, the .MYI and .MYD

Postby Altrea » 21. June 2013 08:17

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6583
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: only .opt and .frm files are present, the .MYI and .MYD

Postby redhuneeru » 22. June 2013 04:15

thank you Altrea
yea I was using innoDB for storage but after using MylSAM i no longer have any problem.
thank you again
redhuneeru
 
Posts: 3
Joined: 21. June 2013 07:05
XAMPP Version: 5.6.3
Operating System: windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 46 guests