Hi, On Wed, Oct 03, 2001 at 02:32:18PM -0000, fahran wrote: > Author: fahran > Email: [EMAIL PROTECTED] > Message: > when using optimiser.sh i need to pass through the password for root otherwise the >optimiser program cant modify any tables. > > is it possible to pass through a password to the optimiser when i run it?
Just add '-u root --password=secret' (without the quotes) to each line in optimize.sh that starts with either $BINPATH/mysql or $BINPATH/mysqladmin. secret should be replaced by your password obviously. Also make sure you fix the line that contains the sql statement to recreate the tables. 'intag tinyint(4)' should be replaced by 'intag int(11)', otherwise you will lose the word weights. One more piece of advise: it is best to make a backup of your database before using the script. If something goes wrong, you are likely to lose parts of your database. kind regards, Kristof Verniers ___________________________________________ If you want to unsubscribe send "unsubscribe general" to [EMAIL PROTECTED]
