Knase

Installing Fish shell on MacOS (Intel and M1) using brew

Fish is a smart and user-friendly command line (like bash or zsh). This is how you can instal Fish on MacOS and make your default shell.

Note that you need the https://brew.sh/ package manager installed on your machine.

Install Fish

brew install fish

Knase

Disable Device Enrollment Program (DEP) notification on macOS Ventura.md

Ventura docs for M2 Macs in this comment: https://gist.github.com/henrik242/65d26a7deca30bdb9828e183809690bd?permalink_comment_id=4555340#gistcomment-4555340

Old Monterey docs in this old revision: https://gist.github.com/henrik242/65d26a7deca30bdb9828e183809690bd/32c410e3a1de73539c76fa13ea5486569c4e0c5d

Solution for Sonoma: https://gist.github.com/sghiassy/a3927405cf4ffe81242f4ecb01c382ac

Knase

# found at: 
# http://stackoverflow.com/questions/1895059/git-revert-to-a-commit-by-sha-hash

# reset the index to the desired tree
git reset --hard 56e05fced

# move the branch pointer back to the previous HEAD
git reset --soft HEAD@{1}

git commit -m "Revert to 56e05fced"

Knase

<?php


/**
 * Return the path of the auth.json file.
 */
function findAuthJson() {

    // Windows sets HOMEDRIVE and HOMEPATH, but cygwin sets HOME.
    if (!isset($_SERVER["HOME"]) && isset($_SERVER["HOMEDRIVE"])) {

Knase

Write to NTFS support MacOS

1. Get the partition UUID

Connect the external drive to MacOS. It should mount read-only. Start "System Information", clic on Hardware -> Storage, select your drive in the list and copy its UUID.

Another way to get the UUID is to use the diskutil CLI tool:

~$ diskutil list 
~$ distutil info diskXsY

Knase

SET FOREIGN_KEY_CHECKS = 0;
#clear orders
TRUNCATE TABLE `gift_message`;
TRUNCATE TABLE `quote`;
TRUNCATE TABLE `quote_address`;
TRUNCATE TABLE `quote_address_item`;
TRUNCATE TABLE `quote_id_mask`;
TRUNCATE TABLE `quote_item`;
TRUNCATE TABLE `quote_item_option`;
TRUNCATE TABLE `quote_payment`;

Knase

Speed up warden for faster importing of large sql dumps.

1. Add the innodb options to the warden/environments/magento2.base.yml docker-compose YML file.
2. Restart warden environment warden env down && warden sync stop && warden env up -d && warden sync start
3. Import the .sql file with warden db import.
4. Remove options & restart warden enviornment once import completed.

Why these settings

• innodb_buffer_pool_size : Will cache frequently read data

Knase

Speed up warden for faster importing of large sql dumps.

1. Add the innodb options to the warden/environments/magento2.base.yml docker-compose YML file.
2. Restart warden environment warden env down && warden sync stop && warden env up -d && warden sync start
3. Import the .sql file with warden db import.
4. Remove options & restart warden enviornment once import completed.

Why these settings

• innodb_buffer_pool_size : Will cache frequently read data

Knase

SET FOREIGN_KEY_CHECKS=0;

# Clean order history
TRUNCATE TABLE `sales_bestsellers_aggregated_daily`;
TRUNCATE TABLE `sales_bestsellers_aggregated_monthly`;
TRUNCATE TABLE `sales_bestsellers_aggregated_yearly`;

# Clean order infos
TRUNCATE TABLE `sales_creditmemo`;
TRUNCATE TABLE `sales_creditmemo_comment`;

Knase

###
###
### ORDERS
###
###
SET FOREIGN_KEY_CHECKS=0; 
TRUNCATE `sales_flat_creditmemo`; 
TRUNCATE `sales_flat_creditmemo_comment`; 
TRUNCATE `sales_flat_creditmemo_grid`; 
TRUNCATE `sales_flat_creditmemo_item`;