Re: repair table priv

2004-12-15 Thread Bgs
up Bgs wrote: Does this silence mean that nobody knows?!? :) I've been trying to find what privilege is needed to 'REPAIR TABLE'. I couldn't find any usefull hint on the net or in the archives. Could anyone help me out? -- MySQL General Mailing List For list archives:

Re: repair table priv

2004-12-15 Thread Goutham S Mohan
I think you need to have root privileges (ALL) on the table to run REPAIR TABLE since this is a disaster recovery sql command. It works only for MyISAM tables in MySQL. I don't think it is supported for all tables. Logically a repair table command would update, insert, delete and alter the

Re: repair table priv

2004-12-15 Thread Bgs
Hi, I think you need to have root privileges (ALL) on the table to run REPAIR TABLE since this is a disaster recovery sql command. It works only for MyISAM tables in MySQL. I don't think it is supported for all tables. I need it because I got a server with big load that sometimes has db

Re: repair table priv

2004-12-03 Thread Bgs
Does this silence mean that nobody knows?!? :) I've been trying to find what privilege is needed to 'REPAIR TABLE'. I couldn't find any usefull hint on the net or in the archives. Could anyone help me out? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

repair table priv

2004-12-01 Thread Bgs
Greetings, I've been trying to find what privilege is needed to 'REPAIR TABLE'. I couldn't find any usefull hint on the net or in the archives. Could anyone help me out? Thanks Bgs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: