jedgalbraith

# 'backups/' dir must exist previously.

# Removes backup files older than 7 days, 
Command: find backups/* -mtime +7 -exec rm {} \;
# Every day at midnight
UNIX cron schedule: 0 0 * * *

# Creates backups in the 'backups/' writable directory.
Command: mysqldump -h $DB1_HOST -P $DB1_PORT -u $DB1_USER -p$DB1_PASS $DB1_NAME > backups/$DB1_NAME-"$(date +"%m_%d_%Y")".sql
# Every day at 1AM

jedgalbraith

SELECT
    ce.sku,
    ea.attribute_id,
    ea.attribute_code,
    CASE ea.backend_type
       WHEN 'varchar' THEN ce_varchar.value
       WHEN 'int' THEN ce_int.value
       WHEN 'text' THEN ce_text.value
       WHEN 'decimal' THEN ce_decimal.value
       WHEN 'datetime' THEN ce_datetime.value

jedgalbraith

# First set the custom error handler at the beginning of the script: 
# php docs: http://php.net/manual/en/function.set-error-handler.php
set_error_handler('workerErrorHandler');

# Next define the workerErrorHandler function:

function workerErrorHandler($errno, $errstr, $errfile, $errline)
{
    if (!(error_reporting() & $errno)) {
        // This error code is not included in error_reporting

jedgalbraith

<frontend>
        <events>
            <!-- logs -->
            <controller_action_predispatch>
                <observers><log><type>disabled</type></log></observers>
            </controller_action_predispatch>
            <controller_action_postdispatch>
                <observers><log><type>disabled</type></log></observers>
            </controller_action_postdispatch>
            <customer_login>