LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 04-04-2011, 09:58 AM   #1
ilvista
Member
 
Registered: Nov 2010
Location: Ghazaouet
Distribution: Fedora OpenSuse
Posts: 150

Rep: Reputation: 21
mysql .MYD .MYI are missing


hi

I've mysql server running ,and i have one single database. everything is working fine but I cant find .MYD and .MYI of one of my tables .and now when i tried to make a backup mysqldump fails because .MYI et .MYI are not found.

I tried locate my_table.MYD my_table.MYI
BUT no chance


any help will be appreciated.
thx
 
Old 04-04-2011, 10:05 AM   #2
chickenjoy
Member
 
Registered: Apr 2007
Distribution: centos,rhel, solaris
Posts: 200

Rep: Reputation: 30
try the find command instead

Code:
# find / my_table.MYD my_table.MYI
locate relies on a database itself that (most often) is not updated.
 
Old 04-05-2011, 06:52 AM   #3
ilvista
Member
 
Registered: Nov 2010
Location: Ghazaouet
Distribution: Fedora OpenSuse
Posts: 150

Original Poster
Rep: Reputation: 21
thx for the reply.

I figured it out !!!!!!


I'm using InnoDB engine ,i didn't know that it doesn't need .MYD and .MYI.
in the contrary MyISAM use .MYD and .MYI .


Best regards
 
Old 04-05-2011, 09:21 PM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,260

Rep: Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328
InnoDB is the RRDBMS engine (think Oracle), whereas MyISAM is Indexed Sequential Access Method i.e. indexed flat files; a completely different and non-relational engine.
That's why it uses different files.
 
Old 04-06-2011, 04:07 AM   #5
ilvista
Member
 
Registered: Nov 2010
Location: Ghazaouet
Distribution: Fedora OpenSuse
Posts: 150

Original Poster
Rep: Reputation: 21
thanks for the useful clarification.

Best regards
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql MyISAM table doesn't have .MYD and MYI files. celeron Linux - Server 2 02-01-2011 08:35 AM
location of .MYD files chetanmadaan Linux - Newbie 1 06-30-2010 12:12 AM
Application to convert MySQL files MYD, MYI, FRM to SQL text files ? SethShannon Linux - Newbie 1 09-28-2007 07:03 PM
MYSQL help - mysql database missing eloviyandhi Linux - Software 1 03-20-2004 10:20 PM
MySQL command prompt (/usr/local/mysql missing) sankar555 Linux - Software 3 03-22-2003 01:48 PM


All times are GMT -5. The time now is 04:13 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration