datafile.MYI has been destroyed & can't recover

2002-03-23 Thread Andy Woolley
Hi, I've got a 300 MB database file with a useless MYI file and I cant seem to reconstruct it. Anyone know how I can get the data back. if I use myisamchk -o it destroys all the data in the file so I'm kinda stumped. Cheers Andy PS I need to enter SQL and Query cos this mail bouced at first.

Re: MySQL.org

2001-12-30 Thread Andy Woolley
Hi, Well, it certainly seems to be pointing to MySQL.com alright. Although the domain name registrant is still NuSphere and DNS still appears to be handled by NuSphere's command the IPAddress it resolves to is definitely that of MySQL.com. Hmmm, I certainly hope this is justice and not just car

Re: Nusphere is spamming me (Interesting Stuff)

2001-11-20 Thread Andy Woolley
ey've decided to strangle us in legal paperwork," said Lorne Cooper, president of NuSphere, distributor of the MySQL open source database system. So, what do you think we should do about all this. Regards Andy Woolley. - Original Message - From: "Michael A. Peters"

Re: mysql.org

2001-07-15 Thread Andy Woolley
> I see one HUGE difference between these support sites and .net, > in regards to .com: Every one but .net clearly state that > this is a product of MySQL AB, tell people about and make > very explicit links mysql.com. The impression I get from the .org site, is that they are promoting a product

Inserting Date Formats ??

2001-05-03 Thread Andy Woolley
in advance. Andy Woolley. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To uns

Re: TheCasino.com: Registration Confirmation

2001-04-04 Thread Andy Woolley
Unfortunately not it's plain old SPAM! It's on other lists as well. Andy Woolley www.databasewatch.com - Original Message - From: "Nathan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 04, 2001 5:19 PM Subject: Re: TheCasino.com:

Re: DROP COLUMN

2001-02-16 Thread Andy Woolley
Werner, Your syntax is correct and valid for MySQL. The problem could lie with your ODBC driver. What version are you on? Try downloading a utility for administering MySQL. UrbSQL is good from www.urbanresearch.com and see if that can drop the column. Good luck. Andy Woolley

Re: Virus Alert - For Your Info.

2001-02-13 Thread Andy Woolley
idance is not to open the damn thing at all just delete it, but its easier said than done. Hope this helps Andy Woolley www.databasewatch.com - Original Message - From: "William R. Mussatto" <[EMAIL PROTECTED]> To: "Ashley M. Kirchner" <[EMAIL PROTECTED]> C

Is WHEN a reserved word in MySQL?

2001-02-08 Thread Andy Woolley
Hi All, Does anyone know if a field called WHEN could cause trouble with queries? Many Thanks Andy Woolley www.databasewatch.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http