Joost van Veen joostvanveen

## truncate_magento_log_tables.sql
--
-- This query truncates alle cache, session, dataflow,
-- index, log, report, quote, flat catalog, and URL
-- rewrite tables. Handy, if you have a bloated
-- Magento database and you need to do a bit
-- of cleaning up for use on a local machine.
--
-- Replace PREFIX_ with your current Magento table prefix.
--
-- USE AT OWN RISK. ALWAY BACKUP YOUR DATABASE FIRST.

## delete_products_and_categories_from_magento.sql
-- Foreign key check will cascade-delete all related data

-- Delete all products
DELETE FROM catalog_product_entity;

-- Reset the autoincrement for products
ALTER TABLE catalog_product_entity AUTO_INCREMENT = 1;

-- Delete all categories
DELETE FROM catalog_category_entity WHERE `entity_id` > 2;

## remove_big_files-from_git_history.sh
# This command removes any sql.gz SQL backup file from history, even if it was committed a few commits ago.
# Handy for big files that throw an error when trying to push. As always, rewriting git history is a
# dangerous action! Do not rewrite for commits that have already been fetched by fellow developers.

git filter-branch --prune-empty -d /path/to/tmp/scratch/dir --index-filter "git rm --cached -f --ignore-unmatch *.sql.gz" --tag-name-filter cat -- --all

## Varnish commands
# purge varnish cache in Varnish 3
varnishadm "ban.url ."

# purge varnish cache in Varnish 4
varnishadm "ban req.url ~ /"

## get-magento-version-number.sh
# Echo Magento version number
cd /path/to/magento/webroot
php -r "include 'app/Mage.php'; echo 'Magento version is: ', Mage::getVersion(); "

## .htaccess
# Force trailing slash for SEO purposes
RewriteEngine On

# For GET and HEAD requests only. We do not want to redirect posted forms and such, or we'll lose all POST data!
RewriteCond %{REQUEST_METHOD} ^(GET|HEAD)$

# Not for actual files. We do not want to redirect urls like test.jpg to test.jpg/
RewriteCond %{REQUEST_FILENAME} !-f

# Redirect to trailing slash if no slash is present in URI

## .gitignore
############ Project specific rules ###############
# Project specific rules go here...
# To ignore a folder, add asterix -> folder/*
# This way, unignored files like .keep and .gitkeep will still be added to git

################# Global rules ####################
## Never ignore .gitignore
!.gitignore

## Dependencies

## .htaccess
######################################################################
## Word to the wise                                                 ##
## It is best to keep your htaccess files as clean as possible      ##
## and set as many specs in your Apache config as you can.          ##
## Htaccess slows down Apache.                                      ##
## Review the entire file before use, especially the TODO sections. ##
######################################################################

Options -MultiViews
Options +FollowSymLinks

## .htaccess
# Canonical redirect - force www. prefix on domain
RewriteCond %{HTTP_HOST} ^mydomain\.nl$ [NC]
RewriteRule ^(.*)$ https://www.mydomain.nl/$1 [R=301,L]

## .htaccess
# Force SSL, but only for a certain domain
# At the same time, redirect http non-www ad www to https://www

# Replace example\.com and example.com with your domain

RewriteCond %{HTTPS} off
RewriteCond %{HTTP_HOST} ^(www\.)?example\.com$
RewriteRule (.*) https://www.example.com/$1 [R=301,L]
	--
	-- This query truncates alle cache, session, dataflow,
	-- index, log, report, quote, flat catalog, and URL
	-- rewrite tables. Handy, if you have a bloated
	-- Magento database and you need to do a bit
	-- of cleaning up for use on a local machine.
	--
	-- Replace PREFIX_ with your current Magento table prefix.
	--
	-- USE AT OWN RISK. ALWAY BACKUP YOUR DATABASE FIRST.
	-- Foreign key check will cascade-delete all related data

	-- Delete all products
	DELETE FROM catalog_product_entity;

	-- Reset the autoincrement for products
	ALTER TABLE catalog_product_entity AUTO_INCREMENT = 1;

	-- Delete all categories
	DELETE FROM catalog_category_entity WHERE `entity_id` > 2;
	# This command removes any sql.gz SQL backup file from history, even if it was committed a few commits ago.
	# Handy for big files that throw an error when trying to push. As always, rewriting git history is a
	# dangerous action! Do not rewrite for commits that have already been fetched by fellow developers.

	git filter-branch --prune-empty -d /path/to/tmp/scratch/dir --index-filter "git rm --cached -f --ignore-unmatch *.sql.gz" --tag-name-filter cat -- --all
	# purge varnish cache in Varnish 3
	varnishadm "ban.url ."

	# purge varnish cache in Varnish 4
	varnishadm "ban req.url ~ /"
	# Echo Magento version number
	cd /path/to/magento/webroot
	php -r "include 'app/Mage.php'; echo 'Magento version is: ', Mage::getVersion(); "
	# Force trailing slash for SEO purposes
	RewriteEngine On

	# For GET and HEAD requests only. We do not want to redirect posted forms and such, or we'll lose all POST data!
	RewriteCond %{REQUEST_METHOD} ^(GET\|HEAD)$

	# Not for actual files. We do not want to redirect urls like test.jpg to test.jpg/
	RewriteCond %{REQUEST_FILENAME} !-f

	# Redirect to trailing slash if no slash is present in URI
	############ Project specific rules ###############
	# Project specific rules go here...
	# To ignore a folder, add asterix -> folder/*
	# This way, unignored files like .keep and .gitkeep will still be added to git

	################# Global rules ####################
	## Never ignore .gitignore
	!.gitignore

	## Dependencies
	######################################################################
	## Word to the wise ##
	## It is best to keep your htaccess files as clean as possible ##
	## and set as many specs in your Apache config as you can. ##
	## Htaccess slows down Apache. ##
	## Review the entire file before use, especially the TODO sections. ##
	######################################################################

	Options -MultiViews
	Options +FollowSymLinks
	# Canonical redirect - force www. prefix on domain
	RewriteCond %{HTTP_HOST} ^mydomain\.nl$ [NC]
	RewriteRule ^(.*)$ https://www.mydomain.nl/$1 [R=301,L]
	# Force SSL, but only for a certain domain
	# At the same time, redirect http non-www ad www to https://www

	# Replace example\.com and example.com with your domain

	RewriteCond %{HTTPS} off
	RewriteCond %{HTTP_HOST} ^(www\.)?example\.com$
	RewriteRule (.*) https://www.example.com/$1 [R=301,L]