When I run db_optimizer.php, I get the following mySQL error:
Code:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/apache/htdocs/db_optimizer.php on line 21
I've tried the variations of db_optimizer.php given here, but they both result in the same error.
I would prefer to run the bash script rather than the php anyway, and I have access to bash, but I have no idea how set up and run bash scripts.
Any help on getting either method to work is much appreciated. Thanks!
===========
mySQL: 4.1.11
Apache/1.3.33 (Unix) PHP/4.3.11 mod_perl/1.29
xcart: 4.0.15