MySQL newbie: table gone after reboot

[Avram Aelony]

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]