KINKCreative

# CREATE CATEGORIES IN YOUR SYSTEM (MEN/WOMEN/KIDS and WOMEN/SHOES, WOMEN/JEWELRY, MEN/SHOES and KIDS/SHOES)
# Update the ID's in the top of shopify_import.php ($category)

# BACKUP
sudo mysqldump -p magentodb > magentodb.sql

#this saves the whole DB, incl users and categories

#switch to shopify-import branch, pull
#on your local machine run shopify_import.php, for me it's

KINKCreative

<?php

/*

Put this file into your root folder. Set the user settings below and run the script. It will auto-delete when done.

*/

$mageFilename = 'app/Mage.php';
if (!file_exists($mageFilename)) {

KINKCreative

# GET RECENTLY UPDATED TABLES

SELECT UPDATE_TIME, TABLE_NAME FROM `TABLES` WHERE TABLE_SCHEMA = 'magentodb' ORDER BY UPDATE_TIME DESC;

KINKCreative

$ git commit ...              (1)
$ git reset --soft 'HEAD^'    (2)
$ edit                        (3)
$ git add ....                (4)
$ git commit -c ORIG_HEAD     (5)
This is what you want to undo

This is most often done when you remembered what you just committed is incomplete, or you misspelled your commit message, or both. Leaves working tree as it was before "reset". (The quotes may or may not be required in your shell)

Make corrections to working tree files.

KINKCreative

# First add python-software-properties to get apt-add-repository
$ sudo apt-get install python-software-properties

# then...
$ sudo add-apt-repository ppa:git-core/ppa
$ sudo apt-get update
$ sudo apt-get install git

KINKCreative

# OPEN MYSQL

$ sudo mysql -p

# SWITCH TO YOUR MAGENTO DATABASE
mysql> use magentodb

# IF YOU WANT TO CHECK COLUMN NAMES
mysql> SELECT `COLUMN_NAME`FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA`='magentodb' AND `TABLE_NAME`='core_config_data';

KINKCreative

// ADD TO YOUR VCL FILE

sub vcl_fetch {
    if (beresp.http.Vary ~ "User-Agent") {
        set beresp.http.Vary = regsub(req.http.Vary, ",? *User-Agent *", "");
        set beresp.http.Vary = regsub(req.http.Vary, "^, *", "");
        if (beresp.http.Vary == "") {
            remove beresp.http.Vary;
        }
    }

KINKCreative

<a rel="license" href="http://creativecommons.org/licenses/by-nc-nd/4.0/"><img alt="Creative Commons License" style="border-width:0" src="http://i.creativecommons.org/l/by-nc-nd/4.0/88x31.png" /></a><br />This <span xmlns:dct="http://purl.org/dc/terms/" href="http://purl.org/dc/dcmitype/StillImage" rel="dct:type">work</span> by <a xmlns:cc="http://creativecommons.org/ns#" href="http://garabatos.me" property="cc:attributionName" rel="cc:attributionURL">Garabatos</a> is licensed under a <a rel="license" href="http://creativecommons.org/licenses/by-nc-nd/4.0/">Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License</a>.

KINKCreative

screen command	Task
Ctrl+a c          Create new window
Ctrl+a k          Kill the current window / session
Ctrl+a w          List all windows
Ctrl+a 0-9        Go to a window numbered 0 9, use Ctrl+a w to see number
Ctrl+a Ctrl+a     Toggle / switch between the current and previous window
Ctrl+a S        Split terminal horizontally into regions and press Ctrl+a c to create new window there
Ctrl+a :resize      Resize region
Ctrl+a :fit     Fit screen size to new terminal size. You can also hit Ctrl+a F for the the same task
Ctrl+a :remove    Remove / delete region. You can also hit Ctrl+a X for the same taks

KINKCreative

rsync -rtvz --progress --partial --exclude user@remote.server.com:/srv/www www/