MYISAMCHK

2001-07-30 Thread Andy Tanner
Hi, can someone clarify the myisamchk -R (to re-sort the table) parameters for me.. $ myisamchk -R shop_registration The value of the sort key is bigger than max key: 32. $ myisamchk -R shop_registration -O sort_key=31M The value of the sort key is bigger than max key: 32. I have t

RE: About safe_mysqld - another problem

2001-07-21 Thread Andy Tanner
you may find that the permissions for the mysql tables are set to root... I had to chown mysql:mysql the tables in /data/mysql/* before I could start mysqld check the permissions -Original Message- From: Ajay Nagarkar [mailto:[EMAIL PROTECTED]] Sent: 21 July 2001 08:05 To: [EMAIL PRO

RE: AW: password-recovery for root-user?

2001-07-18 Thread Andy Tanner
Similarly - how about - take a copy of you original mysql database tables - overwrite the mysql database tables with the original installation tables - login as root (the password will be blank) - import your orignial tables back into the mysql database good luck Andy -Original Mess