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
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
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
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
, 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
[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
-
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
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
]
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