Repair Tables SOLVED

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

Repair Tables SOLVED

Postby rharvey49 » 16. December 2009 00:01

I have just installed XAMPP on Mac OS X Snow Leopard and need to use some mysql tables that were saved on a backup drive on Leopard before upgrading to Snow Leopard which destroyed my access to my Mysql tables through the former Apache web server and Mysql server through an as yet insoluble DBD:mysql installation problem.. I can see the tables in the phpMyadmin window with XAMPP, but trying to examine the tables results in errors such as this:

#1017 - Can't find file: './alprog/allist.frm' (errno: 13) The file is sitting right there in the directory: allist.frm

I understand that there is a way to repair tables but I have not discovered how to do that with XAMPP. Does anyone have the solution to my problem?

Thank you
Last edited by rharvey49 on 16. December 2009 23:20, edited 1 time in total.
rharvey49
 
Posts: 6
Joined: 15. December 2009 23:42

Re: Repair Tables

Postby Wiedmann » 16. December 2009 00:18

and need to use some mysql tables that were saved on a backup drive ... , but trying to examine the tables results in errors such as this:
Code: Select all
#1017 - Can't find file: './alprog/allist.frm' (errno: 13) The file is sitting right there in the directory: allist.frm

"errno 13" means "permission denied".
--> check the file modes and owner of the files you have copied from the backup drive.
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Repair Tables

Postby rharvey49 » 16. December 2009 15:13

It must me more than a permission issue because I changed ownership on all files to nobody:admin and permissions to 660 and I still get the same error message!
rharvey49
 
Posts: 6
Joined: 15. December 2009 23:42

Re: Repair Tables

Postby Wiedmann » 16. December 2009 15:37

I changed ownership on all files

You have also checked the directories?
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Repair Tables

Postby rharvey49 » 16. December 2009 20:37

Jawohl, mein Herr:

sh-3.2# ls -lR mysql
total 41088
drw-rw---- 10 nobody admin 340 Nov 11 2008 CME
drw-rw---- 27 nobody admin 918 Nov 11 2008 alprog
drwx------@ 6 nobody admin 204 Aug 16 07:36 cdcol
-rw-rw----@ 1 nobody admin 1946 Aug 16 07:36 devmac.err
-rw-rw---- 1 nobody admin 5242880 Dec 16 08:25 ib_logfile0
-rw-rw---- 1 nobody admin 5242880 Dec 15 11:19 ib_logfile1
-rw-rw---- 1 nobody admin 10485760 Dec 16 08:25 ibdata1
drwx------@ 71 nobody admin 2414 Aug 16 07:36 mysql
-rw-rw---- 1 nobody admin 58628 Dec 16 08:25 robert-harveys-imac.local.err
drwx------@ 2 nobody admin 68 Aug 16 07:36 test

mysql/CME:
total 344
-rw-rw----@ 1 nobody admin 6148 Nov 11 2008 .DS_Store
-rw-rw---- 1 nobody admin 37680 Dec 14 03:15 CATI.MYD
-rw-rw---- 1 nobody admin 37888 Dec 14 03:15 CATI.MYI
-rw-rw---- 1 nobody admin 8718 Dec 14 03:15 CATI.frm
-rw-rw---- 1 nobody admin 39764 Dec 14 03:15 CATII.MYD
-rw-rw---- 1 nobody admin 16384 Dec 14 03:15 CATII.MYI
-rw-rw---- 1 nobody admin 9295 Dec 14 03:15 CATII.frm
-rw-rw---- 1 nobody admin 65 Dec 14 03:15 db.opt

mysql/alprog:
total 3688
-rw-rw---- 1 nobody admin 1760 Dec 14 03:15 allist.MYD
-rw-rw---- 1 nobody admin 4096 Dec 14 03:15 allist.MYI
-rw-rw---- 1 nobody admin 8594 Dec 14 03:15 allist.frm
-rw-rw---- 1 nobody admin 1044548 Dec 14 03:15 arch_dat.MYD
-rw-rw---- 1 nobody admin 689152 Dec 14 03:15 arch_dat.MYI
-rw-rw---- 1 nobody admin 8742 Dec 14 03:15 arch_dat.frm
-rw-rw---- 1 nobody admin 61 Dec 14 03:15 db.opt
-rw-rw---- 1 nobody admin 7 Dec 14 03:15 run_dat.MYD
-rw-rw---- 1 nobody admin 2048 Dec 14 03:15 run_dat.MYI
-rw-rw---- 1 nobody admin 8596 Dec 14 03:15 run_dat.frm
-rw-rw---- 1 nobody admin 0 Dec 14 03:15 s_grass.MYD
-rw-rw---- 1 nobody admin 1024 Dec 14 03:15 s_grass.MYI
-rw-rw---- 1 nobody admin 8680 Dec 14 03:15 s_grass.frm
-rw-rw---- 1 nobody admin 292 Dec 14 03:15 s_mold.MYD
-rw-rw---- 1 nobody admin 2048 Dec 14 03:15 s_mold.MYI
-rw-rw---- 1 nobody admin 8680 Dec 14 03:15 s_mold.frm
-rw-rw---- 1 nobody admin 0 Dec 14 03:15 s_tree.MYD
-rw-rw---- 1 nobody admin 1024 Dec 14 03:15 s_tree.MYI
-rw-rw---- 1 nobody admin 8680 Dec 14 03:15 s_tree.frm
-rw-rw---- 1 nobody admin 0 Dec 14 03:15 s_weed.MYD
-rw-rw---- 1 nobody admin 1024 Dec 14 03:15 s_weed.MYI
-rw-rw---- 1 nobody admin 8680 Dec 14 03:15 s_weed.frm
-rw-rw---- 1 nobody admin 20 Dec 14 03:15 tot_mold.MYD
-rw-rw---- 1 nobody admin 2048 Dec 14 03:15 tot_mold.MYI
-rw-rw---- 1 nobody admin 8636 Dec 14 03:15 tot_mold.frm

mysql/cdcol:
total 48
-rw-rw----@ 1 nobody admin 148 Aug 16 07:36 cds.MYD
-rw-rw----@ 1 nobody admin 2048 Aug 16 07:36 cds.MYI
-rw-rw----@ 1 nobody admin 8658 Aug 16 07:36 cds.frm
-rw-rw----@ 1 nobody admin 65 Aug 16 07:36 db.opt

mysql/mysql:
total 1904
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 columns_priv.MYD
-rw-rw----@ 1 nobody admin 4096 Aug 16 07:36 columns_priv.MYI
-rw-rw----@ 1 nobody admin 8820 Aug 16 07:36 columns_priv.frm
-rw-rw----@ 1 nobody admin 880 Aug 16 07:36 db.MYD
-rw-rw----@ 1 nobody admin 5120 Aug 16 07:36 db.MYI
-rw-rw----@ 1 nobody admin 9582 Aug 16 07:36 db.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 event.MYD
-rw-rw----@ 1 nobody admin 2048 Aug 16 07:36 event.MYI
-rw-rw----@ 1 nobody admin 10223 Aug 16 07:36 event.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 func.MYD
-rw-rw----@ 1 nobody admin 1024 Aug 16 07:36 func.MYI
-rw-rw----@ 1 nobody admin 8665 Aug 16 07:36 func.frm
-rw-rw----@ 1 nobody admin 35 Dec 16 08:06 general_log.CSM
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 general_log.CSV
-rw-rw----@ 1 nobody admin 8776 Aug 16 07:36 general_log.frm
-rw-rw----@ 1 nobody admin 21497 Aug 16 07:36 help_category.MYD
-rw-rw----@ 1 nobody admin 3072 Aug 16 07:36 help_category.MYI
-rw-rw----@ 1 nobody admin 8700 Aug 16 07:36 help_category.frm
-rw-rw----@ 1 nobody admin 88650 Aug 16 07:36 help_keyword.MYD
-rw-rw----@ 1 nobody admin 16384 Aug 16 07:36 help_keyword.MYI
-rw-rw----@ 1 nobody admin 8612 Aug 16 07:36 help_keyword.frm
-rw-rw----@ 1 nobody admin 8892 Aug 16 07:36 help_relation.MYD
-rw-rw----@ 1 nobody admin 16384 Aug 16 07:36 help_relation.MYI
-rw-rw----@ 1 nobody admin 8630 Aug 16 07:36 help_relation.frm
-rw-rw----@ 1 nobody admin 416928 Aug 16 07:36 help_topic.MYD
-rw-rw----@ 1 nobody admin 20480 Aug 16 07:36 help_topic.MYI
-rw-rw----@ 1 nobody admin 8770 Aug 16 07:36 help_topic.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 host.MYD
-rw-rw----@ 1 nobody admin 2048 Aug 16 07:36 host.MYI
-rw-rw----@ 1 nobody admin 9510 Aug 16 07:36 host.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 ndb_binlog_index.MYD
-rw-rw----@ 1 nobody admin 1024 Aug 16 07:36 ndb_binlog_index.MYI
-rw-rw----@ 1 nobody admin 8778 Aug 16 07:36 ndb_binlog_index.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 plugin.MYD
-rw-rw----@ 1 nobody admin 1024 Aug 16 07:36 plugin.MYI
-rw-rw----@ 1 nobody admin 8586 Aug 16 07:36 plugin.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 proc.MYD
-rw-rw----@ 1 nobody admin 2048 Aug 16 07:36 proc.MYI
-rw-rw----@ 1 nobody admin 9996 Aug 16 07:36 proc.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 procs_priv.MYD
-rw-rw----@ 1 nobody admin 4096 Aug 16 07:36 procs_priv.MYI
-rw-rw----@ 1 nobody admin 8875 Aug 16 07:36 procs_priv.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 servers.MYD
-rw-rw----@ 1 nobody admin 1024 Aug 16 07:36 servers.MYI
-rw-rw----@ 1 nobody admin 8838 Aug 16 07:36 servers.frm
-rw-rw----@ 1 nobody admin 35 Dec 16 08:06 slow_log.CSM
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 slow_log.CSV
-rw-rw----@ 1 nobody admin 8976 Aug 16 07:36 slow_log.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 tables_priv.MYD
-rw-rw----@ 1 nobody admin 4096 Aug 16 07:36 tables_priv.MYI
-rw-rw----@ 1 nobody admin 8955 Aug 16 07:36 tables_priv.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 time_zone.MYD
-rw-rw----@ 1 nobody admin 1024 Aug 16 07:36 time_zone.MYI
-rw-rw----@ 1 nobody admin 8636 Aug 16 07:36 time_zone.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 time_zone_leap_second.MYD
-rw-rw----@ 1 nobody admin 1024 Aug 16 07:36 time_zone_leap_second.MYI
-rw-rw----@ 1 nobody admin 8624 Aug 16 07:36 time_zone_leap_second.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 time_zone_name.MYD
-rw-rw----@ 1 nobody admin 1024 Aug 16 07:36 time_zone_name.MYI
-rw-rw----@ 1 nobody admin 8606 Aug 16 07:36 time_zone_name.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 time_zone_transition.MYD
-rw-rw----@ 1 nobody admin 1024 Aug 16 07:36 time_zone_transition.MYI
-rw-rw----@ 1 nobody admin 8686 Aug 16 07:36 time_zone_transition.frm
-rw-rw----@ 1 nobody admin 0 Aug 16 07:36 time_zone_transition_type.MYD
-rw-rw----@ 1 nobody admin 1024 Aug 16 07:36 time_zone_transition_type.MYI
-rw-rw----@ 1 nobody admin 8748 Aug 16 07:36 time_zone_transition_type.frm
-rw-rw----@ 1 nobody admin 328 Dec 15 14:20 user.MYD
-rw-rw----@ 1 nobody admin 2048 Dec 16 08:00 user.MYI
-rw-rw----@ 1 nobody admin 10466 Aug 16 07:36 user.frm
rharvey49
 
Posts: 6
Joined: 15. December 2009 23:42

Re: Repair Tables

Postby Wiedmann » 16. December 2009 21:12

These are the databases (directories) provided by XAMPP:
Code: Select all
drwx------@ 6 nobody admin 204 Aug 16 07:36 cdcol
drwx------@ 71 nobody admin 2414 Aug 16 07:36 mysql
drwx------@ 2 nobody admin 68 Aug 16 07:36 test


Looks different then:
Code: Select all
drw-rw---- 10 nobody admin 340 Nov 11 2008 CME
drw-rw---- 27 nobody admin 918 Nov 11 2008 alprog


"drwx------" vs. "drw-rw----"

Additionally:
I don't know the meaning of "@", but the XAMPP database files (.MYD, .MYI, .frm) and dirs all have this, not yours.
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Repair Tables SOLVED

Postby rharvey49 » 16. December 2009 23:23

You hit the nail right on the head! Changing the directory permissions fixed the problem. Nothing changed with the lack of the "@" notation on my directories, though. That persists.

Thanks very much.
rharvey49
 
Posts: 6
Joined: 15. December 2009 23:42


Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 12 guests