Hi everyone! I recently bought Mr. DuBois' MySQL book and got through the tutorials just fine. Since I wanted to venture into the wild without the help of the tutorials, I decided to make a project of my own. I have a guitar magazine collection with song transcriptions and all; I own around 60 so everytime I want to look up a song I have to go through most of the mags to find the song I'm looking for. Enter MySQL! I created a DB called 'tabs' and three tables: 'artist', 'song' and 'mag'. On the 'artist' table I have two columns: artist_name and artist_id, the latter is not null by default and auto incremented. On 'mag', I have five columns: mag_name, month, year, song_id and artist_id. And on 'song', song_name and song_id. As you can see, 'mag' is the link between 'artist' and 'song'. I started going through every magazine adding rows to every table succesfully. I ran test queries using the 'source' command and a text file. Everything was working just fine at that point. On day 3, I was almost done adding all the records to the tables when I ran a test query and all off a sudden I get a "ERROR 1030: Got error 127 from table handler" error message. I hadn't experienced ANY errors up to this point. The weird thing is I only got this type of message on the 'mag' and 'song' tables; 'artist' works just fine. I get this error message even with ordinary 'SELECT * FROM mag;' queries. As far as I know, all the tables are of the same kind: MySQL standard table type. So, MySQL gurus out there... what can I do to solve this problem? Is there a way I can recover all the info I added on the 'mag' and 'song' tables? Thanx in advance!
--------------------------------- Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!