Skip to content

Instantly share code, notes, and snippets.

@redesigned

redesigned/magento upgrade

Last active February 11, 2025 20:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save redesigned/6169208 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save redesigned/6169208 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. redesigned revised this gist Oct 19, 2016. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -21,11 +21,11 @@ Backup:
    Upgrade or Install:
    cp .htaccess .htaccess.PreUpgrade
    cp index.php index.php.PreUpgrade
    wget http://redesigned.com/magento/magento-1.9.2.4.tar.gz
    tar -zxvf magento-1.9.2.4.tar.gz
    wget http://redesigned.com/magento/magento-1.9.3.0.tar.gz
    tar -zxvf magento-1.9.3.0.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.9.2.4.tar.gz
    rm magento-1.9.3.0.tar.gz
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/* ./var/cache/* ./var/session/* ./var/report/* ./media/tmp/* ./app/code/core/Zend/Cache/*
    find . -type d -exec chmod 755 {} \;
    find . -type f -exec chmod 644 {} \;
  2. redesigned revised this gist May 4, 2016. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -21,11 +21,11 @@ Backup:
    Upgrade or Install:
    cp .htaccess .htaccess.PreUpgrade
    cp index.php index.php.PreUpgrade
    wget http://redesigned.com/magento/magento-1.9.2.3.tar.gz
    tar -zxvf magento-1.9.2.3.tar.gz
    wget http://redesigned.com/magento/magento-1.9.2.4.tar.gz
    tar -zxvf magento-1.9.2.4.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.9.2.3.tar.gz
    rm magento-1.9.2.4.tar.gz
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/* ./var/cache/* ./var/session/* ./var/report/* ./media/tmp/* ./app/code/core/Zend/Cache/*
    find . -type d -exec chmod 755 {} \;
    find . -type f -exec chmod 644 {} \;
  3. redesigned revised this gist Feb 17, 2016. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -21,11 +21,11 @@ Backup:
    Upgrade or Install:
    cp .htaccess .htaccess.PreUpgrade
    cp index.php index.php.PreUpgrade
    wget http://redesigned.com/magento/magento-1.9.2.1.tar.gz
    tar -zxvf magento-1.9.2.1.tar.gz
    wget http://redesigned.com/magento/magento-1.9.2.3.tar.gz
    tar -zxvf magento-1.9.2.3.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.9.2.1.tar.gz
    rm magento-1.9.2.3.tar.gz
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/* ./var/cache/* ./var/session/* ./var/report/* ./media/tmp/* ./app/code/core/Zend/Cache/*
    find . -type d -exec chmod 755 {} \;
    find . -type f -exec chmod 644 {} \;
  4. redesigned revised this gist Aug 4, 2015. 1 changed file with 4 additions and 3 deletions.
    7 changes: 4 additions & 3 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -20,11 +20,12 @@ Backup:

    Upgrade or Install:
    cp .htaccess .htaccess.PreUpgrade
    wget http://redesigned.com/magento/magento-1.9.2.0.tar.gz
    tar -zxvf magento-1.9.2.0.tar.gz
    cp index.php index.php.PreUpgrade
    wget http://redesigned.com/magento/magento-1.9.2.1.tar.gz
    tar -zxvf magento-1.9.2.1.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.9.2.0.tar.gz
    rm magento-1.9.2.1.tar.gz
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/* ./var/cache/* ./var/session/* ./var/report/* ./media/tmp/* ./app/code/core/Zend/Cache/*
    find . -type d -exec chmod 755 {} \;
    find . -type f -exec chmod 644 {} \;
  5. redesigned revised this gist Jul 9, 2015. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -19,6 +19,7 @@ Backup:
    mysqldump --add-drop-table --user username --password=XXXXXX databasename | gzip > backup_database.sql.gz

    Upgrade or Install:
    cp .htaccess .htaccess.PreUpgrade
    wget http://redesigned.com/magento/magento-1.9.2.0.tar.gz
    tar -zxvf magento-1.9.2.0.tar.gz
    cp -rf magento/* magento/.htaccess .
  6. redesigned revised this gist Jul 9, 2015. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion shell
    View file
    Original file line number Diff line number Diff line change
    @@ -19,7 +19,7 @@ Backup:
    mysqldump --add-drop-table --user username --password=XXXXXX databasename | gzip > backup_database.sql.gz

    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.9.2.0/magento-1.9.2.0.tar.gz
    wget http://redesigned.com/magento/magento-1.9.2.0.tar.gz
    tar -zxvf magento-1.9.2.0.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
  7. redesigned revised this gist Jul 8, 2015. 1 changed file with 9 additions and 3 deletions.
    12 changes: 9 additions & 3 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -19,11 +19,11 @@ Backup:
    mysqldump --add-drop-table --user username --password=XXXXXX databasename | gzip > backup_database.sql.gz

    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.9.1.1/magento-1.9.1.1.tar.gz
    tar -zxvf magento-1.9.1.1.tar.gz
    wget http://www.magentocommerce.com/downloads/assets/1.9.2.0/magento-1.9.2.0.tar.gz
    tar -zxvf magento-1.9.2.0.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.9.1.1.tar.gz
    rm magento-1.9.2.0.tar.gz
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/* ./var/cache/* ./var/session/* ./var/report/* ./media/tmp/* ./app/code/core/Zend/Cache/*
    find . -type d -exec chmod 755 {} \;
    find . -type f -exec chmod 644 {} \;
    @@ -45,6 +45,12 @@ Alternate:
    php shell/indexer.php reindexall

    Previous Versions:
    wget http://www.magentocommerce.com/downloads/assets/1.9.1.1/magento-1.9.1.1.tar.gz
    tar -zxvf magento-1.9.1.1.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.9.1.1.tar.gz

    wget http://www.magentocommerce.com/downloads/assets/1.9.0.1/magento-1.9.0.1.tar.gz
    tar -zxvf magento-1.9.0.1.tar.gz
    cp -rf magento/* magento/.htaccess .
  8. redesigned revised this gist May 7, 2015. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion shell
    View file
    Original file line number Diff line number Diff line change
    @@ -19,7 +19,7 @@ Backup:
    mysqldump --add-drop-table --user username --password=XXXXXX databasename | gzip > backup_database.sql.gz

    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.9.1.0/magento-1.9.1.1.tar.gz
    wget http://www.magentocommerce.com/downloads/assets/1.9.1.1/magento-1.9.1.1.tar.gz
    tar -zxvf magento-1.9.1.1.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
  9. redesigned revised this gist May 7, 2015. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -19,11 +19,11 @@ Backup:
    mysqldump --add-drop-table --user username --password=XXXXXX databasename | gzip > backup_database.sql.gz

    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.9.1.0/magento-1.9.1.0.tar.gz
    tar -zxvf magento-1.9.1.0.tar.gz
    wget http://www.magentocommerce.com/downloads/assets/1.9.1.0/magento-1.9.1.1.tar.gz
    tar -zxvf magento-1.9.1.1.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.9.1.0.tar.gz
    rm magento-1.9.1.1.tar.gz
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/* ./var/cache/* ./var/session/* ./var/report/* ./media/tmp/* ./app/code/core/Zend/Cache/*
    find . -type d -exec chmod 755 {} \;
    find . -type f -exec chmod 644 {} \;
  10. redesigned revised this gist Feb 4, 2015. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion shell
    View file
    Original file line number Diff line number Diff line change
    @@ -19,7 +19,7 @@ Backup:
    mysqldump --add-drop-table --user username --password=XXXXXX databasename | gzip > backup_database.sql.gz

    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.9.0.1/magento-1.9.0.1.tar.gz
    wget http://www.magentocommerce.com/downloads/assets/1.9.1.0/magento-1.9.1.0.tar.gz
    tar -zxvf magento-1.9.1.0.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
  11. redesigned revised this gist Nov 30, 2014. 1 changed file with 9 additions and 3 deletions.
    12 changes: 9 additions & 3 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -20,10 +20,10 @@ Backup:

    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.9.0.1/magento-1.9.0.1.tar.gz
    tar -zxvf magento-1.9.0.1.tar.gz
    tar -zxvf magento-1.9.1.0.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.9.0.1.tar.gz
    rm magento-1.9.1.0.tar.gz
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/* ./var/cache/* ./var/session/* ./var/report/* ./media/tmp/* ./app/code/core/Zend/Cache/*
    find . -type d -exec chmod 755 {} \;
    find . -type f -exec chmod 644 {} \;
    @@ -44,7 +44,13 @@ Alternate:
    rm -rf downloader/.cache/* downloader/pearlib/cache/* downloader/pearlib/download/* var/cache/*
    php shell/indexer.php reindexall

    Previous Version:
    Previous Versions:
    wget http://www.magentocommerce.com/downloads/assets/1.9.0.1/magento-1.9.0.1.tar.gz
    tar -zxvf magento-1.9.0.1.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.9.0.1.tar.gz

    wget http://www.magentocommerce.com/downloads/assets/1.8.1.0/magento-1.8.1.0.tar.gz
    tar -zxvf magento-1.8.1.0.tar.gz
    cp -rf magento/* magento/.htaccess .
  12. redesigned revised this gist Sep 30, 2014. 1 changed file with 4 additions and 0 deletions.
    4 changes: 4 additions & 0 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -14,6 +14,10 @@ Fix Permissions:
    chmod -R o+w media
    chmod 550 ./mage

    Backup:
    tar cvfz backup_files.tar.gz ./domainname.com
    mysqldump --add-drop-table --user username --password=XXXXXX databasename | gzip > backup_database.sql.gz

    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.9.0.1/magento-1.9.0.1.tar.gz
    tar -zxvf magento-1.9.0.1.tar.gz
  13. redesigned revised this gist Sep 22, 2014. 1 changed file with 10 additions and 1 deletion.
    11 changes: 10 additions & 1 deletion shell
    View file
    Original file line number Diff line number Diff line change
    @@ -30,7 +30,16 @@ Upgrade or Install:
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/*
    rm -rf ./var/cache/* ./var/session/* ./var/report/* ./var/log/*
    rm -rf ./media/tmp/* ./app/code/core/Zend/Cache/* ./var/tmp/*


    Alternate:
    chmod 550 ./mage
    ./mage mage-setup .
    ./mage sync
    ./mage install http://connect20.magentocommerce.com/community Mage_All_Latest --force
    ./mage upgrade-all --force
    rm -rf downloader/.cache/* downloader/pearlib/cache/* downloader/pearlib/download/* var/cache/*
    php shell/indexer.php reindexall

    Previous Version:
    wget http://www.magentocommerce.com/downloads/assets/1.8.1.0/magento-1.8.1.0.tar.gz
    tar -zxvf magento-1.8.1.0.tar.gz
  14. redesigned revised this gist Aug 9, 2014. 1 changed file with 5 additions and 1 deletion.
    6 changes: 5 additions & 1 deletion magento upgrade
    View file
    Original file line number Diff line number Diff line change
    @@ -11,4 +11,8 @@ go to /app/design/frontend/base/default/template/checkout/onepage/ file payment.
    </fieldset>

    If their theme overrides /checkout/cart.php add the formkey to the top of the cart form:
    <?php echo $this->getChildHtml('form_before') ?>
    <?php echo $this->getChildHtml('form_before') ?>
    <?php echo $this->getBlockHtml('formkey'); ?>

    In fact add the formkey block to the top of any form their template overrides.
    <?php echo $this->getBlockHtml('formkey'); ?>
  15. redesigned revised this gist Jul 21, 2014. 1 changed file with 5 additions and 0 deletions.
    5 changes: 5 additions & 0 deletions upgrade_table_drops.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -7,6 +7,11 @@ AND `ENGINE` = 'MyISAM'
    AND `TABLE_TYPE` = 'BASE TABLE'
    ORDER BY table_name;

    /* If Pre 1.6 run this */
    ALTER TABLE sales_flat_order_item DROP INDEX IDX_ORDER , ADD INDEX IDX_SALES_FLAT_ORDER_ITEM_ORDER_ID ( order_id )
    ALTER TABLE sales_flat_order_item DROP INDEX IDX_STORE_ID , ADD INDEX IDX_SALES_FLAT_ORDER_ITEM_STORE_ID ( store_id )
    ALTER TABLE sales_flat_order_item DROP INDEX IDX_PRODUCT_ID

    /* Run this */
    SET NAMES utf8;
    SET FOREIGN_KEY_CHECKS=0;
  16. redesigned revised this gist Jun 14, 2014. No changes.
  17. redesigned revised this gist Jun 14, 2014. 1 changed file with 4 additions and 1 deletion.
    5 changes: 4 additions & 1 deletion magento upgrade
    View file
    Original file line number Diff line number Diff line change
    @@ -8,4 +8,7 @@ go to /app/design/frontend/base/default/template/checkout/onepage/ file payment.
    (add this id to the fieldset)
    <fieldset id="checkout-payment-method-load">
    <?php echo $this->getChildHtml('methods') ?>
    </fieldset>
    </fieldset>

    If their theme overrides /checkout/cart.php add the formkey to the top of the cart form:
    <?php echo $this->getChildHtml('form_before') ?>
  18. redesigned revised this gist Jun 2, 2014. 1 changed file with 9 additions and 1 deletion.
    10 changes: 9 additions & 1 deletion magento upgrade
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,11 @@
    After upgrading:
    delete all files except config.xml from the following directory:
    /app/code/core/Mage/GoogleCheckout/etc
    /app/code/core/Mage/GoogleCheckout/etc

    go to www.mywebsite/downloader then reinstall the package called Lib_Varien

    go to /app/design/frontend/base/default/template/checkout/onepage/ file payment.phtml
    (add this id to the fieldset)
    <fieldset id="checkout-payment-method-load">
    <?php echo $this->getChildHtml('methods') ?>
    </fieldset>
  19. redesigned revised this gist Jun 2, 2014. 1 changed file with 3 additions and 0 deletions.
    3 changes: 3 additions & 0 deletions upgrade_table_drops.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -27,6 +27,9 @@ Truncate table log_visitor_online;
    Truncate table report_viewed_product_index;
    Truncate table report_compared_product_index;
    Truncate table report_event;
    Truncate table index_event;
    Truncate table catalog_compare_item;


    DROP TABLE `catalog_product_index_website`;
    CREATE TABLE `catalog_product_index_website` (
  20. redesigned revised this gist May 23, 2014. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -15,11 +15,11 @@ Fix Permissions:
    chmod 550 ./mage

    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.9.0.0/magento-1.9.0.0.tar.gz
    tar -zxvf magento-1.9.0.0.tar.gz
    wget http://www.magentocommerce.com/downloads/assets/1.9.0.1/magento-1.9.0.1.tar.gz
    tar -zxvf magento-1.9.0.1.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.9.0.0.tar.gz
    rm magento-1.9.0.1.tar.gz
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/* ./var/cache/* ./var/session/* ./var/report/* ./media/tmp/* ./app/code/core/Zend/Cache/*
    find . -type d -exec chmod 755 {} \;
    find . -type f -exec chmod 644 {} \;
  21. redesigned revised this gist May 23, 2014. 1 changed file with 10 additions and 3 deletions.
    13 changes: 10 additions & 3 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -15,11 +15,11 @@ Fix Permissions:
    chmod 550 ./mage

    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.8.1.0/magento-1.8.1.0.tar.gz
    tar -zxvf magento-1.8.1.0.tar.gz
    wget http://www.magentocommerce.com/downloads/assets/1.9.0.0/magento-1.9.0.0.tar.gz
    tar -zxvf magento-1.9.0.0.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.8.1.0.tar.gz
    rm magento-1.9.0.0.tar.gz
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/* ./var/cache/* ./var/session/* ./var/report/* ./media/tmp/* ./app/code/core/Zend/Cache/*
    find . -type d -exec chmod 755 {} \;
    find . -type f -exec chmod 644 {} \;
    @@ -30,4 +30,11 @@ Upgrade or Install:
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/*
    rm -rf ./var/cache/* ./var/session/* ./var/report/* ./var/log/*
    rm -rf ./media/tmp/* ./app/code/core/Zend/Cache/* ./var/tmp/*

    Previous Version:
    wget http://www.magentocommerce.com/downloads/assets/1.8.1.0/magento-1.8.1.0.tar.gz
    tar -zxvf magento-1.8.1.0.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.8.1.0.tar.gz

  22. redesigned renamed this gist May 19, 2014. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions after upgrade → magento upgrade
    View file
    Original file line number Diff line number Diff line change
    @@ -1,2 +1,3 @@
    After upgrading:
    delete all files except config.xml from the following directory:
    /app/code/core/Mage/GoogleCheckout/etc
  23. redesigned revised this gist Apr 25, 2014. 1 changed file with 10 additions and 0 deletions.
    10 changes: 10 additions & 0 deletions upgrade_table_drops.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -28,6 +28,16 @@ Truncate table report_viewed_product_index;
    Truncate table report_compared_product_index;
    Truncate table report_event;

    DROP TABLE `catalog_product_index_website`;
    CREATE TABLE `catalog_product_index_website` (
    `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
    `website_date` date DEFAULT NULL COMMENT 'Website Date',
    `rate` float DEFAULT '1' COMMENT 'Rate',
    PRIMARY KEY (`website_id`),
    KEY `IDX_CATALOG_PRODUCT_INDEX_WEBSITE_WEBSITE_DATE` (`website_date`),
    CONSTRAINT `FK_CAT_PRD_IDX_WS_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Website Index Table';

    /* Call index.php to execute upgrde */

    /* After upgrade is complete run this */
  24. redesigned revised this gist Apr 25, 2014. No changes.
  25. redesigned revised this gist Apr 22, 2014. 2 changed files with 24 additions and 1 deletion.
    2 changes: 2 additions & 0 deletions after upgrade
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,2 @@
    delete all files except config.xml from the following directory:
    /app/code/core/Mage/GoogleCheckout/etc
    23 changes: 22 additions & 1 deletion upgrade_table_drops.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,18 @@
    /* Run this command to find tables with engine type MyISAM. */
    /* It will generate SQL to run, run all except catalogsearch_fulltext */
    SELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') AS sql_statements
    FROM information_schema.tables AS tb
    WHERE table_schema = 'magento'
    AND `ENGINE` = 'MyISAM'
    AND `TABLE_TYPE` = 'BASE TABLE'
    ORDER BY table_name;

    /* Run this */
    SET NAMES utf8;
    SET FOREIGN_KEY_CHECKS=0;
    SET UNIQUE_CHECKS=0;

    /* Run this */
    Truncate table dataflow_batch_export;
    Truncate table dataflow_batch_import;
    Truncate table log_customer;
    @@ -11,4 +26,10 @@ Truncate table log_visitor_info;
    Truncate table log_visitor_online;
    Truncate table report_viewed_product_index;
    Truncate table report_compared_product_index;
    Truncate table report_event;
    Truncate table report_event;

    /* Call index.php to execute upgrde */

    /* After upgrade is complete run this */
    SET FOREIGN_KEY_CHECKS=1;
    SET UNIQUE_CHECKS=1;
  26. redesigned revised this gist Apr 22, 2014. 1 changed file with 14 additions and 0 deletions.
    14 changes: 14 additions & 0 deletions upgrade_table_drops.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,14 @@
    Truncate table dataflow_batch_export;
    Truncate table dataflow_batch_import;
    Truncate table log_customer;
    Truncate table log_quote;
    Truncate table log_summary;
    Truncate table log_summary_type;
    Truncate table log_url;
    Truncate table log_url_info;
    Truncate table log_visitor;
    Truncate table log_visitor_info;
    Truncate table log_visitor_online;
    Truncate table report_viewed_product_index;
    Truncate table report_compared_product_index;
    Truncate table report_event;
  27. redesigned revised this gist Dec 17, 2013. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -15,11 +15,11 @@ Fix Permissions:
    chmod 550 ./mage

    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.8.0.0/magento-1.8.0.0.tar.gz
    tar -zxvf magento-1.8.0.0.tar.gz
    wget http://www.magentocommerce.com/downloads/assets/1.8.1.0/magento-1.8.1.0.tar.gz
    tar -zxvf magento-1.8.1.0.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.8.0.0.tar.gz
    rm magento-1.8.1.0.tar.gz
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/* ./var/cache/* ./var/session/* ./var/report/* ./media/tmp/* ./app/code/core/Zend/Cache/*
    find . -type d -exec chmod 755 {} \;
    find . -type f -exec chmod 644 {} \;
  28. redesigned revised this gist Dec 6, 2013. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions shell
    View file
    Original file line number Diff line number Diff line change
    @@ -16,10 +16,10 @@ Fix Permissions:

    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.8.0.0/magento-1.8.0.0.tar.gz
    tar -zxvf magento-1.7.0.2.tar.gz
    tar -zxvf magento-1.8.0.0.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
    rm magento-1.7.0.2.tar.gz
    rm magento-1.8.0.0.tar.gz
    rm -rf ./downloader/pearlib/cache/* ./downloader/pearlib/download/* ./var/cache/* ./var/session/* ./var/report/* ./media/tmp/* ./app/code/core/Zend/Cache/*
    find . -type d -exec chmod 755 {} \;
    find . -type f -exec chmod 644 {} \;
  29. redesigned revised this gist Dec 6, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion shell
    View file
    Original file line number Diff line number Diff line change
    @@ -15,7 +15,7 @@ Fix Permissions:
    chmod 550 ./mage

    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.7.0.2/magento-1.7.0.2.tar.gz
    wget http://www.magentocommerce.com/downloads/assets/1.8.0.0/magento-1.8.0.0.tar.gz
    tar -zxvf magento-1.7.0.2.tar.gz
    cp -rf magento/* magento/.htaccess .
    rm -rf magento
  30. redesigned revised this gist Aug 7, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion shell
    View file
    Original file line number Diff line number Diff line change
    @@ -14,7 +14,7 @@ Fix Permissions:
    chmod -R o+w media
    chmod 550 ./mage

    Upgrade:
    Upgrade or Install:
    wget http://www.magentocommerce.com/downloads/assets/1.7.0.2/magento-1.7.0.2.tar.gz
    tar -zxvf magento-1.7.0.2.tar.gz
    cp -rf magento/* magento/.htaccess .