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]
