Is there any difference between optimizing like this and just clicking repair for the database -- from the mysql section in cpanel?

optimizer for litecommerce?
 

Hello,

would this work for a litecommerce installation? Could it be made to work or is there something like this out there for litecommerce?

It should work for no matter what shopping cart system you are using.

currently using this on my site, thank you very much!

Is there a difference between optimizing a database and repairing a database??

Repairing tables instead of optimizing them can be signifigant slower in some cases.

An example of this happening can be seen in the comments on this MySQL documentation page:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html

Can this script crash your database in any way?

Re: Database Auto-Optimizer
 

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

Jeremy

Re: Database Auto-Optimizer
 

Anyone want to make $20 to add this to my site? I am on a VPS with Plesk control panel. I don't think I have it right and it seems like a very useful script to run.

Re: Database Auto-Optimizer
 

Same here. when I put this "http://localhost/inspa/db_optimizer.php" in the browser i just get a blank page - I have a test site on my localhost, so this is how I have the db_optomizer.php set up:
-----------------------------------------------
# Ensure the script execution request is by the server.
if (empty($_SERVER['REMOTE_ADDR']) && empty($_SERVER['SERVER_ADDR'])) {

# Define Constants
define('ERROR_LOG', 'http://localhost/inspa/log/db_optimization_errors.html');
define('DB_LINK', mysql_connect('localhost','',''));
define('DB_NAME', 'inspa');
----------------------------------------------
also, do I need to create this file? db_optimization_errors.html or does the optimizer do it for you? I don't want to run it on my live site until I make sure I'm doing it correctly.
What am I doing wrong?