petemcw

Magento SQL Snippets

Clear Temporary Data Tables

TRUNCATE `log_customer`;
TRUNCATE `log_quote`;
TRUNCATE `log_summary`;
TRUNCATE `log_url`;
TRUNCATE `log_url_info`;

petemcw

#
# Customized VCL file for serving up a Drupal site with multiple back-ends.
#
# For more information on this VCL, visit the Lullabot article:
# http://www.lullabot.com/articles/varnish-multiple-web-servers-drupal
#

# Define the internal network subnet.
# These are used below to allow internal access to certain files while not
# allowing access from the public internet.

petemcw

class KeyGenerator
  require "digest/sha1"
  def self.generate(length = 12)
    Digest::SHA1.hexdigest(Time.now.to_s + rand(567891234).to_s)[1..length]
  end
end

petemcw

# The MySQL database server configuration file.
#
# DESC: InnoDB mainly, heavy queries, fewer connections, 4GB RAM
#
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

# This was formally known as [safe_mysqld]. Both versions are currently parsed.

petemcw

# Magento Connect 2 cache directories and files
downloader/pearlib/cache/
downloader/*.cfg

# Magento runtime media files
media/catalog/product/cache/
media/tmp/
media/js/
media/css/
media/.thumbs/