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 todo )
and also as myself and both methods yield the same results, shown
below:
mysql> SHO
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
-Original Message-
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.MY
[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, are
, 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
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
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_00
-rw-rw 1 mysql wheel
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 an
