Yovko Lambrev yovko

## arch_linux_installation_guide.md

      
              1 file
            
          
              111 forks
            
          
                63 comments
              
            
              764 stars
            
          
                mjkstra
                / arch_linux_installation_guide.md
            
            
              Last active
              December 7, 2025 15:17
            
              
                A modern, updated installation guide for Arch Linux with BTRFS on an UEFI system
              
          
    Modern Arch linux installation guide

Table of contents


Introduction
Preliminary Steps
Main installation

Disk partitioning
Disk formatting


Disk mounting


## buildspec.yml
version: 0.2

env:
  variables:
    NODE_ENV: "${env}"

phases:
  install:
    runtime-versions:
      nodejs: 12

## build_signTextJS.md

      
              3 files
            
          
              1 fork
            
          
                4 comments
              
            
              6 stars
            
          
                angelyordanov
                / build_signTextJS.md
            
            
              Last active
              December 27, 2022 13:38
            
              
                BTrust MacOS setup
              
          
    Building signTextJS


Clone https://github.com/angelyordanov/signTextJS
Run travis/osx..install script or open it and run the steps manually
Run travis/osx..script
If all goes well you'll have a signtextjs_plus-0.0.0-macos.dmg in the repo root


## cloudSettings
{"lastUpload":"2019-01-11T09:09:35.430Z","extensionVersion":"v3.1.2"}

## sh2ju.sh
#!/bin/bash
### Copyright 2010 Manuel Carrasco Moñino. (manolo at apache.org)
### Copyright 2016 Patrick Double (pat at patdouble.com)
###
### Licensed under the Apache License, Version 2.0.
### You may obtain a copy of it at
### http://www.apache.org/licenses/LICENSE-2.0

###
### A library for shell scripts which creates reports in jUnit format.

## README.md

      
              1 file
            
          
              15 forks
            
          
                34 comments
              
            
              81 stars
            
          
                Remiii
                / README.md
            
            
              Last active
              May 26, 2025 00:46
            
              
                How to delete Vault (AWS Glacier) 🗻
              
          
    How to delete Vault (AWS Glacier)

This Gist give some tips in order to remove AWS Glacier Vault with AWS CLI (ie. https://aws.amazon.com/en/cli/).
Step 1 / Retrive inventory

$ aws glacier initiate-job --job-parameters '{"Type": "inventory-retrieval"}' --vault-name YOUR_VAULT_NAME --account-id YOUR_ACCOUNT_ID --region YOUR_REGION


## wordpress_utf8mb4-to-utf8.sh
DB="your_database_name"
USER="your_db_user"
PASS="your_db_pass"
HOST="database_hostname"
(
    echo 'ALTER DATABASE `'"$DB"'` CHARACTER SET utf8 COLLATE utf8_general_ci;'
    mysql -p $PASS -u $USER -h $HOST "$DB" -e "SHOW TABLES" --batch --skip-column-names \
    | xargs -I{} echo 'ALTER TABLE `'{}'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;'
) \
| mysql -p $PASS -u $USER -h $HOST "$DB"

## nginx.conf
upstream phpfpm {
	server unix:/var/run/php5-fpm.sock;
}

upstream hhvm {
	server unix:/var/run/hhvm/hhvm.sock;
}

# SSL
ssl_protocols             TLSv1 TLSv1.1 TLSv1.2;

## README.md

      
              1 file
            
          
              36 forks
            
          
                1 comment
              
            
              121 stars
            
          
                magnetikonline
                / README.md
            
            
              Last active
              July 13, 2025 16:25
            
              
                WordPress assorted database clean up SQL queries.
              
          
    WordPress database clean up queries


Orphan rows

wp_posts -> wp_posts (parent/child)
wp_postmeta -> wp_posts
wp_term_taxonomy -> wp_terms
wp_term_relationships -> wp_term_taxonomy
wp_usermeta -> wp_users
wp_posts -> wp_users


Other
	version: 0.2

	env:
	variables:
	NODE_ENV: "${env}"

	phases:
	install:
	runtime-versions:
	nodejs: 12
	#!/bin/bash
	### Copyright 2010 Manuel Carrasco Moñino. (manolo at apache.org)
	### Copyright 2016 Patrick Double (pat at patdouble.com)
	###
	### Licensed under the Apache License, Version 2.0.
	### You may obtain a copy of it at
	### http://www.apache.org/licenses/LICENSE-2.0

	###
	### A library for shell scripts which creates reports in jUnit format.
	DB="your_database_name"
	USER="your_db_user"
	PASS="your_db_pass"
	HOST="database_hostname"
	(
	echo 'ALTER DATABASE `'"$DB"'` CHARACTER SET utf8 COLLATE utf8_general_ci;'
	mysql -p $PASS -u $USER -h $HOST "$DB" -e "SHOW TABLES" --batch --skip-column-names \
	\| xargs -I{} echo 'ALTER TABLE `'{}'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;'
	) \
	\| mysql -p $PASS -u $USER -h $HOST "$DB"
	upstream phpfpm {
	server unix:/var/run/php5-fpm.sock;
	}

	upstream hhvm {
	server unix:/var/run/hhvm/hhvm.sock;
	}

	# SSL
	ssl_protocols TLSv1 TLSv1.1 TLSv1.2;