Optimizing Magento For Speed

Optimizing Magento Magento is a very popular eCommerce application. It offers a great deal of customization and abilities from initial install. Here are a few suggestions for optimizing a Magento installation. Changing The .htaccess File Enabling Output Compression In your .htaccess file for Magento you will find a section of text starting with the line,<IfModule…

Deleting Magento Test Orders From Database

Truncating Test Orders SQL Script Tested on Magento 1.8. Simply run the following SQL code. Note: Always make a backup of your database first. “What worked today may not work tomorrow” SET FOREIGN_KEY_CHECKS=0; TRUNCATE `sales_flat_creditmemo`; TRUNCATE `sales_flat_creditmemo_comment`; TRUNCATE `sales_flat_creditmemo_grid`; TRUNCATE `sales_flat_creditmemo_item`; TRUNCATE `sales_flat_invoice`; TRUNCATE `sales_flat_invoice_comment`; TRUNCATE `sales_flat_invoice_grid`; TRUNCATE `sales_flat_invoice_item`; TRUNCATE `sales_flat_order`; TRUNCATE `sales_flat_order_address`; TRUNCATE `sales_flat_order_grid`;…

mysqldump Wamp Database

In this tutorial I will show you how to easily dump your database file using Wamp. To get started simply open your command prompt and type in the following: c:/wamp/bin/mysql/mysql5.6.12/bin/mysqldump -uyourusername -p databasename > c:/Users/ComputerUserName/Desktop/db.sql   The above command will execute the mysql dump and create a file called “db.sql” of your database tables directly…