Michael, You are very correct - I renamed those fields and boom - it started working like magic, thank you so much.
I have another question - the database in question that got crashed had mysql root password but the guys I took over from forgot the password and didn't do any mysql dump. So, I had to manually copy the files i.e MYD, MYI and frm files to the database directories after creating them. However, the application that is using the database requires a certain user account in the mysql database and I can't get to it without the password, so I had to replace my new server mysl database files from the old server and it worked. However - I can't administer the mysql server without the root password. Anyone has any idea how I can retrieve the root password? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
