The user `root` in MySQL is not the same as the Unix `root` user. The user, mysql, or whatever you have selected needs to own the directory and files in the todo directory. chown -R mysql todo chgrp -R mysql todo ... Error 13 means that the user that started the MySQL server does not have permission to access the todo directory.
-----Original Message----- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 1:33 PM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot I have tried logging in as root ( mysql -p -u root todo ) and also as myself and both methods yield the same results, shown below: mysql> SHOW TABLES FROM todo; ERROR 12: Can't read dir of './todo/' (Errcode: 13) mysql> It continues to be curious... -A On Wednesday, September 24, 2003, at 08:22 AM, Victor Pendleton wrote: > Does the user who you start the MySQL Server up with own the directory > and > the files? If the files are there you can try issuing a `show tables > from > todo`. If the tables appear try running `check table tasks` and let us > know > what the output is. > > -----Original Message----- > From: Avram Aelony [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 24, 2003 9:37 AM > To: Victor Pendleton > Cc: [EMAIL PROTECTED] > Subject: Re: MySQL newbie: table gone after reboot > > > > Okay, I had to log in as root to do so. The data seems to be still > extant in tasks.MYD . > The other 2 files, tasks.MYI and tasks.frm, are binary. > -Avram > > [aa:local/mysql/data] aelony# ls -l todo > total 40 > -rw-rw---- 1 mysql wheel 1220 Sep 23 18:11 tasks.MYD > -rw-rw---- 1 mysql wheel 2048 Sep 23 18:46 tasks.MYI > -rw-rw---- 1 mysql wheel 8819 Sep 23 00:56 tasks.frm > > > > > > On Wednesday, September 24, 2003, at 07:15 AM, Victor Pendleton wrote: > >> Can you post the contents from the todo directory? >> >> -----Original Message----- >> From: Avram Aelony [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, September 24, 2003 9:14 AM >> To: Victor Pendleton >> Cc: [EMAIL PROTECTED] >> Subject: Re: MySQL newbie: table gone after reboot >> >> >> >> I am unfamiliar with frm, myd, and myi files, yet perhaps is >> insightful? >> -Avram >> >> [aa:/usr/local/mysql] % ls -l data >> total 41032 >> -rw-rw---- 1 mysql wheel 6362 Sep 23 22:55 aa.local..err >> -rw-rw---- 1 mysql wheel 25088 Sep 8 00:43 >> ib_arch_log_0000000000 >> -rw-rw---- 1 mysql wheel 5242880 Sep 23 22:55 ib_logfile0 >> -rw-rw---- 1 mysql wheel 5242880 Sep 8 00:43 ib_logfile1 >> -rw-rw---- 1 mysql wheel 10485760 Sep 23 22:54 ibdata1 >> drwxr-x--- 20 mysql wheel 680 Sep 8 00:37 mysql/ >> drwx------ 8 mysql wheel 272 Sep 22 23:59 sampdb/ >> drwxr-x--- 5 mysql wheel 170 Sep 10 17:18 test/ >> drwx------ 2 mysql wheel 68 Sep 10 17:11 testdb1/ >> drwx------ 5 mysql wheel 170 Sep 23 00:56 todo/ >> [aa:/usr/local/mysql] % >> >> The aa.local..err file contains lengthy text about starts,stops to the >> server and errors, the other files appear to be binary.. >> >> >> >> >> >> On Wednesday, September 24, 2003, at 06:58 AM, Victor Pendleton >> wrote: >> >>> Are the frm, myd and myi files located in the data directory? What is >>> the >>> data directory? >>> >>> -----Original Message----- >>> From: Avram Aelony [mailto:[EMAIL PROTECTED] >>> Sent: Wednesday, September 24, 2003 8:43 AM >>> To: [EMAIL PROTECTED] >>> Subject: MySQL newbie: table gone after reboot >>> >>> >>> >>> I am new to MySQL and have encountered a problem that probably >>> happens >>> to everyone, yet I have searched for a solution online and elsewhere >>> without success. I created a database and table. Then I populated >>> the >>> table. Everything worked perfectly. Then I shutdown MySQL and >>> rebooted >>> my computer. >>> >>> After starting mysqld, I now find my database, but the table and all >>> its contents seem to be gone. >>> >>> 1.) Can I recover this table? >>> 2.) How can I make sure this does not happen again? What did I do >>> wrong? Is there an FAQ?? >>> >>> Thanks, >>> >>> Avram >>> >>> This is what I did... >>> >>> CREATE DATABASE todo; >>> #Create tasks table for To Do list database >>> CREATE TABLE tasks >>> ( >>> task VARCHAR(60) NOT NULL, >>> date_entered TIMESTAMP(16) NOT NULL, >>> date_due DATE NULL, >>> date_completed DATE NULL, >>> priority ENUM("SOMEDAY", "NOW", "SOON") NOT NULL, >>> description VARCHAR(255) NULL, >>> taskid INT UNSIGNED NOT NULL AUTO_INCREMENT, >>> keywords VARCHAR(100) NULL, >>> PRIMARY KEY (taskid) >>> ); >>> INSERT INTO tasks ( task, date_due, priority, description, keywords) >>> VALUES("set up database","2003-09-24", "SOON", "set up the >>> database", >>> "database"); >>> >>> >>> -- >>> MySQL General Mailing List >>> For list archives: http://lists.mysql.com/mysql >>> To unsubscribe: >>> http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
