Re: MySQL newbie: table gone after reboot

Avram Aelony Wed, 24 Sep 2003 07:16:29 -0700

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]

Re: MySQL newbie: table gone after reboot

Reply via email to