X-Cart forums

[Jayk]

Is there a way to modify the php script to log the output of the optimization/repair? Maybe a verbose logging part that could be added?

I know how to do such things in bash, but I'm a total noob when it comes to php.

Thanks,
Jason

[Berto]

Originally Posted by carpeperdiem

Has anyone used this on a 4.1 database? Anything to know about? Thanks!

Jeremy

I tried it on 4.1.7 and it seems to work flawlessly.

[hrothbeorht]

quick question ..

I was hoping that someone could help me with
the values or the Constants.

# Define Constants
define('ERROR_LOG', '/absolute-path-to-your-log-directory/db_optimization_errors.html');
define('DB_LINK', mysql_connect('server_address','sql_login','sql_pa ssword'));

do any of these look right?

/public_html/shop/var/log/db_optimization_errors.html

'server_address' = 'http://www.website.ca'
or
'server_address' = 'localhost'
or
'server_address' = 'www.website.ca/store'

'sql_login' = 'website_db_user_alpha'
this is the username for the db right?
in the config file it's this - $sql_user = 'website_db_user_alpha' right?

thanks!

-hroth

[Patcheah]

Hi

If I understand correctly, I just need to copy the code provided and save inside my x-cart root directly.

To run this program, can I just use my web browser to run by typing www.mydomain.com/store/db_optimizer.php

I am using a shared windowshosting

Any advise is appreciated.

[effour]

How do I know if this is working?

I load the page and it does nothing. Is the file configed properly? What should happen exactly?

Anyone?

# Define Constants
define('ERROR_LOG', '/var/www/vhosts/site.com/httpdocs/var/db_optimization_errors.html');
define('DB_LINK', mysql_connect('localhost','user','password'));

# Define databases to be optimized.
$db_name = array('dbname);

[MichelleT]

Is this like the "optimize tables" in Summary > Tools of the Admin section or something else?

[Ene]

Is this like the "optimize tables" in Summary > Tools of the Admin section

Yes.

[devonkrusich]

I installed the script and cron job. Here is the message the cron sent last night. How can I fix this or is this OK?

X-Powered-By: PHP/5.2.9
Content-type: text/html

<br />
<b>Warning</b>: mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/home2/petsuppl/public_html/db_optimizer.php</b> on line <b>30</b><br />
<br />
<b>Warning</b>: mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/home2/petsuppl/public_html/db_optimizer.php</b> on line <b>30</b><br />