Re: random order by id

2002-05-19 Thread Erik Perrhoe \(Computer Consultant\)
To pick one item at random what you want is Select foo from bar Where ID = rand() * scale To order them randomly, I seem to recall that there was an example of how to do it in the mySQL manual. -- Erik Perrohe - Original Message - From: Per Andreas Buer [EMAIL PROTECTED] To:

Re: Database and all backups lost at same time

2002-05-19 Thread Erik Perrhoe \(Computer Consultant\)
myisamchk -q Does a Quick check of the files... See the manual for the options to do a full repair / recovery of the files. - ??) Perhaps the backup files were already corrupt before the crash??? ??) Perhaps you have some issues with your hard disk? You can buy a CDRW drive for about

Re: newbie mysql install

2002-05-19 Thread Erik Perrhoe \(Computer Consultant\)
Just a guess, could it be that the Mac does not support sockets...?? I dunno, I'm just fishing since I have not yet had an opportunity to play with the OS X. What about permissions? non-the-less... Try changing your config file to use TCP and see if that works. The other thing I ran into

Re: MySql Client fails to connect

2002-05-19 Thread Erik Perrhoe \(Computer Consultant\)
I had the same problem, it drove me up the friggin wall until I finally found the answer... Read the manual very carefully on how to set up user permissions. Pay particular attention to the description of how wild card permissions are applied. That's what was killing me... Also pay particular