frozenminds

--
-- Magento CE database clean-up extended
--
-- This is an extended clean-up which will clean search, import/export, reports, etc.
--
-- @author      Constantin Bejenaru <[email protected]>
-- @copyright   Copyright (c) Constantin Bejenaru (http://frozenminds.com/)
-- @license     http://www.opensource.org/licenses/mit-license.html  MIT License
--

frozenminds

--
-- Anonymise Magento database
--
-- @author      Constantin Bejenaru <[email protected]>
-- @copyright   Copyright (c) Constantin Bejenaru (http://frozenminds.com/)
-- @license     http://www.opensource.org/licenses/mit-license.html  MIT License
--

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

frozenminds

cat dump.sql | grep -v "INSERT INTO \`catalog_compare_item\`" | grep -v "INSERT INTO \`wishlist_item_option\`" | grep -v "INSERT INTO \`wishlist_item\`" | grep -v "INSERT INTO \`wishlist\`" | grep -v "INSERT INTO \`adminnotification_inbox\`" | grep -v "INSERT INTO \`dataflow_batch_export\`" | grep -v "INSERT INTO \`dataflow_batch_import\`" | grep -v "INSERT INTO \`report_event\`" | grep -v "INSERT INTO \`report_viewed_product_index\`" | grep -v "INSERT INTO \`report_compared_product_index\`" | grep -v "INSERT INTO \`catalogsearch_fulltext\`" | grep -v "INSERT INTO \`catalogsearch_query\`" | grep -v "INSERT INTO \`catalogsearch_recommendations\`" | grep -v "INSERT INTO \`catalogsearch_result\`" | grep -v "INSERT INTO \`catalog_category_flat_store_1\`" | grep -v "INSERT INTO \`catalog_category_flat_store_2\`" | grep -v "INSERT INTO \`catalog_product_flat_1\`" | grep -v "INSERT INTO \`catalog_product_flat_2\`" | grep -v "INSERT INTO \`log_customer\`" | grep -v "INSERT INTO \`log_quote\`" | grep -v "INSERT INTO \

frozenminds

<?xml version="1.0" encoding="UTF-8"?>
<!--
/**
 * Disable observers for Mage_Log module.
 */
-->
<config>
    <frontend>
        <events>
            <!-- Disable Mage_Log -->

frozenminds

<?xml version="1.0" encoding="UTF-8"?>
<!--
/**
 * Disable observers for Mage_Reports module.
 */
-->
<config>
    <frontend>
        <events>
            <!-- Disable Mage_Reports -->

frozenminds

sed -i 's/DEFINER=`olddefiner`/DEFINER=`newdefiner`/g' mysqldump-file.sql

frozenminds

server {
    ...

    rewrite_by_lua '
        -- get query args
        local args = ngx.req.get_uri_args()
 
        if args.p ~= nil then
            args.page = args.p
            args.p    = nil

frozenminds

server {
    listen 80;

    server_name test.dev;
    root /var/www/html;

    userid on;

    default_type    text/html;
    index           index.html;

frozenminds

user  www-data;
worker_processes auto;

events {
    worker_connections  1024;
}

http {
    include       mime.types;
    default_type  text/html;

frozenminds

[Unit]
Description=Tideways Daemon
Requires=network.target

[Service]
PIDFile=/var/run/tideways.pid
ExecStart=/usr/bin/tideways-daemon
User=tideways
Restart=on-failure
RestartSec=10