Hidde Braun hiddebraun

## clean-prestashop-db.sql
# Delete all logs
TRUNCATE ps_log;


# Delete old connection data (only used for stats)
# change 2016-02-01 00:00:00 according to you needs
DELETE c, cs
  FROM ps_connections c
  LEFT JOIN ps_connections_source cs ON (c.id_connections = cs.id_connections)
    WHERE c.date_add < '2016-02-01 00:00:00';

## countries.json
[
  {
    "name": "Afghanistan",
    "short_name": "AF",
    "calling_code": "93"
  },
  {
    "name": "Åland",
    "short_name": "AX",
    "calling_code": "358"

## default
server {
    listen       80;
    server_name  localhost;
    root       /Users/YOUR_USERNAME/Sites;

    access_log  /Library/Logs/default.access.log  main;

    location / {
        include   /usr/local/etc/nginx/conf.d/php-fpm;
    }

## Java.md

      
              1 file
            
          
              13 forks
            
          
              13 comments
            
          
              62 stars
            
          
                JeOam
                / Java.md
            
            
              Last active
              May 5, 2020 03:15
            
              
                Install Java 8 on OS X: https://www.cyanhall.com/posts/notes/7.homebrew-cheatsheet/#java
              
          
    Update: https://www.cyanhall.com/posts/notes/7.homebrew-cheatsheet/#java
on El Capitan, after installing the brew...
$ brew update
$ brew tap caskroom/cask
$ brew install Caskroom/cask/java

And Java 8 will be installed at /Library/Java/JavaVirtualMachines/jdk1.8.xxx.jdk/

  
## gist:5528649

      
              1 file
            
          
              42 forks
            
          
              15 comments
            
          
              154 stars
            
          
                wrburgess
                / gist:5528649
            
            
              Last active
              November 24, 2022 15:29
            
              
                Backup Heroku Postgres database and restore to local database
              
          
    Grab new backup of database

Command: heroku pgbackups:capture --remote production
Response: >>> HEROKU_POSTGRESQL_COLOR_URL (DATABASE_URL)  ----backup--->  a712
Get url of backup download

Command: heroku pgbackups:url [db_key] --remote production
	# Delete all logs
	TRUNCATE ps_log;


	# Delete old connection data (only used for stats)
	# change 2016-02-01 00:00:00 according to you needs
	DELETE c, cs
	FROM ps_connections c
	LEFT JOIN ps_connections_source cs ON (c.id_connections = cs.id_connections)
	WHERE c.date_add < '2016-02-01 00:00:00';
	[
	{
	"name": "Afghanistan",
	"short_name": "AF",
	"calling_code": "93"
	},
	{
	"name": "Åland",
	"short_name": "AX",
	"calling_code": "358"
	server {
	listen 80;
	server_name localhost;
	root /Users/YOUR_USERNAME/Sites;

	access_log /Library/Logs/default.access.log main;

	location / {
	include /usr/local/etc/nginx/conf.d/php-fpm;
	}