I do know thw internals,
but i guess having select only would be enough if you drop the auto-repair
feature.
a repair always requires changes (=write).
maybe you can use mysqlldump instead ?
re,
wh
René Fournier schrieb:
Just wondering what they are. I'd rather not use the MySQL root user for
Just wondering what they are. I'd rather not use the MySQL root user for a
backup script, if I can get away with MySQL user with reduced privileges, for
the following command:
mysqlcheck -ao --auto-repair --all-databases -u someuserotherthanroot -pPASSWORD
...Rene
--
MySQL General Mailing