X-Cart forums

[cotc2001]

Just out of interest before i run this, is there any danger of this script screwing up the database???

[NuAlpha]

Originally Posted by cotc2001

Just out of interest before i run this, is there any danger of this script screwing up the database???

Not that I am aware of. Should do just the opposite and correct periodic problems with the database!

[Online Michael]

I'm wondering if someone can tell me whether IБ─≥m doing this correctly.

I created and pasted the first code and saved it as db_optimised.php in the root directory of the cart (as instructed). I edited this file to include my URL with the ' /log' extension. I then opened my browser and entered my URL with the 'db_optimised.php' extension. When I hit enter, all I see is my home page reloading. Does the optimising happen this quickly or am I doing something wrong?

Oh, and regarding cron jobsБ─╕ IБ─≥ve never done them so IБ─≥m just happy to do it this way (manually) once a month or does it have to be done daily for best results?

[NuAlpha]

Originally Posted by Online Michael

I'm wondering if someone can tell me whether IБ─≥m doing this correctly.

I created and pasted the first code and saved it as db_optimised.php in the root directory of the cart (as instructed). I edited this file to include my URL with the ' /log' extension. I then opened my browser and entered my URL with the 'db_optimised.php' extension. When I hit enter, all I see is my home page reloading. Does the optimising happen this quickly or am I doing something wrong?

Oh, and regarding cron jobsБ─╕ IБ─≥ve never done them so IБ─≥m just happy to do it this way (manually) once a month or does it have to be done daily for best results?

You don't want to enter your URL. You should enter absolute path to your files.

After you run this script you won't see anything as it is not designed to show any such output.

If you are going to run it manually I recommend doing so every 5 days or so, depending on how heavy your site traffic is or how often your database tables are modified.

[jdedba]

NuAlpha,

Thank you for sharing your script.

Can you echo the start time and end time into a log file even the script runs sucessfully? In that way, we can monitor the cron job which is usually managed by hosting workers.

Regards,

Jeff

[oracle9i]

in the config.php file

#
# Automatic repair of the broken indexes in mySQL tables
#
$mysql_autorepair = false;

changing that to '=true', would that have a good effect?

[NuAlpha]

Originally Posted by oracle9i

in the config.php file

#
# Automatic repair of the broken indexes in mySQL tables
#
$mysql_autorepair = false;

changing that to '=true', would that have a good effect?

Probably a good idea. That is what we have set.

[metinex]

Don't forget to get your backup before running the scripts mentioned here.

My xcart_languages table turned out to be empty after running one of those scripts.

mysqldump --add-drop-table -u username -ppassword xcart | mysql -u username -ppassword -C xcart_daily

Run this script in the shell to make a backup in the same mysql server. That way you can easily access to your ols data through sql queries.

I would save this command in a file and put that file under /etc/cron.dailly on Linux systems.

Try also cron.weekly, cron.hourly or cron.monthly folder at your convenience.

[patrick24601]

If you are on a cpanel system using the web based cron you don't have to worry about the daily/monthly/hourly crons. Just pic the right times and days and you are done.

I am consider just running an hourly cron php against my system that calls a generic scheduling php script of mine. Then within that control what gets run when (reports, database auto optimize, etc.). Then as all of these cool mods come out there is only script you have to remember running. Helps when it comes to moving and/or upgrading.

P

[mltriebe]

So how can I tell if this is working? I am trying it on my local test copy and can't see any difference in the SQL coding. I have no idea if it is doing anything or not. I know I had some settings wrong in the first few tries but I think I have it all correct now but nothing still seems to be happening.

Thanks