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…