Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I followed directions from this page: http://serverfault.com/questions/271367/importing-data-from-myd-back-up-file

I dropped the 3 files ( t2010_08.frm, t2010_08.myd, t2010_08.myi ) into my /var/lib/mysql directory.

Then I changed permission with the "chown mysql:mysql t2010_08.* command". Now, when I go to look at my table ( in HeidiSQL ), it tells me that it is type "View" and I get "Can't find file: 't2010_08' (errno:2) message.

What do I still need to do to gain access to this table?

share|improve this question
    
What exact folder did you put the t2010 table? –  RolandoMySQLDBA Jul 30 '12 at 14:53
    
into a database named bsgtran... so path was /var/lib/mysql/bsgtran, there are other tables there that I can see. I have also changed permissions on the table to 660, but still get the same error message. "ERROR 1017 (HY000): Can't find file: 't2010_08' (errno: 2)" –  DBA_Noob Jul 30 '12 at 15:07
    
I have now also restarted MySQL to no effect. –  DBA_Noob Jul 30 '12 at 15:13
    
Was the folder bsgtran already in existence before you decided to you t2010_08.* in it? –  RolandoMySQLDBA Jul 30 '12 at 15:33
    
Never mind, you answered that in previous comment. –  RolandoMySQLDBA Jul 30 '12 at 15:33

1 Answer 1

up vote 0 down vote accepted

I think I got it.

Here is the table as it appears in Linux from the Chat Session

-rw-rw----. 1 mysql mysql 9478 Jul 30 07:18 /var/lib/mysql/bsgtran/t2010_08.frm 
-rw-rw----. 1 mysql mysql 1882892084 Jul 30 07:21 /var/lib/mysql/bsgtran/t2010_08.myd 
-rw-rw----. 1 mysql mysql 74588160 Jul 30 07:22 /var/lib/mysql/bsgtran/t2010_08.myi

Since the database is on a Linux OS, filenames are case-sensitive.

Here is the solution

mv /var/lib/mysql/bsgtran/t2010_08.myd /var/lib/mysql/bsgtran/t2010_08.MYD
mv /var/lib/mysql/bsgtran/t2010_08.myi /var/lib/mysql/bsgtran/t2010_08.MYI

File extensions must be uppercase for MyISAM tables in Linux

Give it a Try !!!

share|improve this answer
    
Yes, it worked!!! Thank you Thank you Thank you!!! –  DBA_Noob Jul 30 '12 at 19:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.