4337 links
  • Arnaud's links
  • Home
  • Login
  • RSS Feed
  • ATOM Feed
  • Tag cloud
  • Picture wall
  • Daily
Links per page: 20 50 100
page 1 / 1
10 results tagged memo x
  • Note: mysql
    # do not use utf8, its not "real utf8"
    CREATE DATABASE `foo` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

    # use this :
    # https://mathiasbynens.be/notes/mysql-utf8mb4#utf8-to-utf8mb4
    CREATE DATABASE `foo` DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci;


    CREATE USER 'foo'@'%' IDENTIFIED BY "password";

    GRANT ALL ON `foo`.* TO "foo"@"%";




    convert :
    # For each database:
    ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
    # For each table:
    ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    # For each column:
    ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    # (Don’t blindly copy-paste this! The exact statement depends on the column type, maximum length, and other properties. The above line is just an example for a `VARCHAR` column.)
    May 3, 2017 at 2:09:48 PM GMT+2 * - permalink - archive.org - https://links.infomee.fr/?kmGPew
    memo mysql
  • Note: git memo

    Voir fichier à un commit :
    git show HASH:path/to/file

    Hash du commit initial :
    git rev-list --max-parents=0 HEAD

    Voir liste fichiers modifiés entre 2 commits :
    git diff --name-only SHA1 SHA2
    git log --name-status --oneline HEAD~6..HEAD
    git log --name-status --oneline HEAD~6..HEAD |grep -vP '^\S[^\s]'|sort|uniq

    Voir modif sur un fichier entre 2 commits :
    git diff SHA1 SHA2 main.c

    Trouver l'ancetre commun le plus vieux
    git config --global alias.oldest-ancestor '!bash -c '\''diff -u <(git rev-list --first-parent "${1:-master}") <(git rev-list --first-parent "${2:-HEAD}") | sed -ne "s/^ //p" | head -1'\'' -'
    git oldest-ancestor

    git rebase -i [HASH parent]

    man -7 gitrevisions

    HEAD
    HEAD~1 HEAD^ HEAD^1
    HEAD~2 HEAD^2 HEAD~1^
    HEAD~3

    10:10 V /tmp/git_test [master L|V]
    $ git lola

    • 52f73ef (HEAD -> refs/heads/master) Merge branch 'toto'
      |\
      | * 2f39200 (refs/heads/toto) commit on toto
    • | d581320 Commit on master
      |/
    • eae368a first commit
      10:10 V /tmp/git_test [master L|V]
      $ git log --name-status --oneline eae368a..52f73ef
      52f73ef Merge branch 'toto'
      d581320 Commit on master
      A tata
      2f39200 commit on toto
      A b
    November 28, 2016 at 2:28:55 PM GMT+1 * - permalink - archive.org - https://links.infomee.fr/?wo2tCA
    git memo
  • GNU screen [quick_reference]

    screen -R toto
    C^a d : detach
    C^a c : create
    C^a A : rename
    C^a " : liste
    C^a p : switch to previous
    C^a n : switch to next
    C^a a : switch to last
    C^a ESC : copy mode (pour scrollback)

    November 21, 2013 at 11:41:43 AM GMT+1 - permalink - archive.org - http://aperiodic.net/screen/quick_reference
    memo screen
  • Git Cheatsheet

    Great interactive cheatsheet

    November 8, 2013 at 1:31:30 PM GMT+1 - permalink - archive.org - http://www.ndpsoftware.com/git-cheatsheet.html
    git memo
  • http://www.pement.org/awk/awk1line.txt
    November 2, 2013 at 9:14:12 AM GMT+1 - permalink - archive.org - http://www.pement.org/awk/awk1line.txt
    awk memo
  • http://sed.sourceforge.net/sed1line.txt
    November 2, 2013 at 9:12:37 AM GMT+1 - permalink - archive.org - http://sed.sourceforge.net/sed1line.txt
    memo sed
  • Cheat - Pour vous souvenir de la bonne syntaxe « Korben Korben

    Old mais je viens d'y repenser. Finalement je fais pareil, j'ai des mémo pour chaque commande dans un dossier de mon dropbox alors pourquoi pas essayer de les utiliser avec ça ? à tester. Dans tous les cas ça ne doit pas remplacer le man

    October 23, 2013 at 7:53:20 AM GMT+2 - permalink - archive.org - http://korben.info/cheat-pour-vous-souvenir-de-la-bonne-syntaxe.html
    bash cheat console man memo shell syntax syntaxe
  • ssh config file : proxy

    Pour utiliser machinerebond pour accéder aux *.vm automatiquement :

    $ cat .ssh/config
    Host=machinerebond
    Hostname=machinerebond.fqdn.com
    User=root

    Host=*.distant
    User=root
    ProxyCommand=ssh -W %h:22 machinerebond

    Alternative :
    D'abord se co sur la machine rebond avec un -A pour ramener sa key dans l'agent distant
    Ensuite on peut se co sur les autres machines, mais plus long.

    Autres directives possibles :
    ServerAliveInterval 30
    ServerAliveCountMax 120

    Port 22000
    User fooey
    IdentityFile ~/.ssh/github.key
    LocalForward 9906 127.0.0.1:3306
    more : http://www.openbsd.org/cgi-bin/man.cgi?query=ssh_config&apropos=0&sektion=0&manpath=OpenBSD+Current&arch=i386&format=html

    October 10, 2013 at 11:36:42 AM GMT+2 - permalink - archive.org - https://links.infomee.fr/?0hyAJQ
    config memo proxy ssh
  • Utiliser vim pour voir les diff de svn diff

    $svndiffx .classpath

    cat ~/bin/svndiffx

    !/bin/bash

    svn diff --diff-cmd "/home/amm/bin/svnvimdiff" $1

    $cat /home/amm/bin/svnvimdiff

    !/bin/bash

    vim -d $6 $7

    September 26, 2012 at 1:56:35 PM GMT+2 - permalink - archive.org - https://links.infomee.fr/?Fhxz-A
    diff memo svn
  • La commande sed
    January 18, 2012 at 10:19:42 AM GMT+1 - permalink - archive.org - http://www.siteduzero.com/tutoriel-3-287602-la-commande-sed.html
    linux memo
Links per page: 20 50 100
page 1 / 1
Shaarli - The personal, minimalist, super-fast, database free, bookmarking service by the Shaarli community - Help/documentation