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]