à vérifier.

chapeau !

hey non, toujours pas du gigabit sur l'Ethernet...

...
Mes condoléances...
...

ha ! bien !

H1 : mysqldump --all-databases --add-drop-database --skip-comments >/tmp/dumph1.sql
H1 : cat /tmp/dumph1.sql | mysql -h H2 -uroot -p
H1 : cat /tmp/dumph1.sql | md5sum
H2 : mysqldump --all-databases --add-drop-database --skip-comments | md5sum

EDIT : attention aux bases "système"

Coudé, il parait qu'elle est bien !

parce que ça claque mieux et que c'est toujours bien de savoir comment va une machine en se connectant.

This feature is very nice as it will give you a quick look at useful information. Unfortunately, Debian Server does not include the dynamic MOTD. First you will need to install some prerequisites and build the directory structure. To do so, run the following commands in terminal. If you would like to add update notification, I have written another article detailing the steps at Debian MOTD Update Notifier.

Shell

install lsb-release

sudo apt-get install lsb-release

install figlet to enable ASCII art

sudo apt-get install figlet

create directory

mkdir /etc/update-motd.d/

change to new directory

cd /etc/update-motd.d/

create dynamic files

touch 00-header ; touch 10-sysinfo; touch 90-footer

make files executable

chmod +x /etc/update-motd.d/*

remove MOTD file

rm /etc/motd

Once the above commands have been run, you can move on to populating the files you created. Below you can copy and paste.
Header (00-header)

!/bin/sh

#

00-header - create the header of the MOTD

Copyright (c) 2013 Nick Charlton

Copyright (c) 2009-2010 Canonical Ltd.

#

Authors: Nick Charlton hello@nickcharlton.net

Dustin Kirkland kirkland@canonical.com

#

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License as published by

the Free Software Foundation; either version 2 of the License, or

(at your option) any later version.

#

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

GNU General Public License for more details.

#

You should have received a copy of the GNU General Public License along

with this program; if not, write to the Free Software Foundation, Inc.,

51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

[ -r /etc/lsb-release ] && . /etc/lsb-release

if [ -z "$DISTRIB_DESCRIPTION" ] && [ -x /usr/bin/lsb_release ]; then

Fall back to using the very slow lsb_release utility

    DISTRIB_DESCRIPTION=$(lsb_release -s -d)

fi

figlet $(hostname)
printf "\n"

printf "Welcome to %s (%s).\n" "$DISTRIB_DESCRIPTION" "$(uname -r)"
printf "\n"

System Information (10-sysinfo)

!/bin/bash

#

10-sysinfo - generate the system information

Copyright (c) 2013 Nick Charlton

#

Authors: Nick Charlton hello@nickcharlton.net

#

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License as published by

the Free Software Foundation; either version 2 of the License, or

(at your option) any later version.

#

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

GNU General Public License for more details.

#

You should have received a copy of the GNU General Public License along

with this program; if not, write to the Free Software Foundation, Inc.,

51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

date=date
load=cat /proc/loadavg | awk '{print $1}'
root_usage=df -h / | awk '/\// {print $(NF-1)}'
memory_usage=free -m | awk '/Mem:/ { total=$2 } /buffers\/cache/ { used=$3 } END { printf("%3.1f%%", used/total*100)}'
swap_usage=free -m | awk '/Swap/ { printf("%3.1f%%", $3/$2*100) }'
users=users | wc -w
time=uptime | grep -ohe 'up .*' | sed 's/,/\ hours/g' | awk '{ printf $2" "$3 }'
processes=ps aux | wc -l
#ip=ifconfig $(route | grep default | awk '{ print $8 }') | grep "inet addr" | awk -F: '{print $2}' | awk '{print $1}'
#ip=hostname --all-ip-addresses || hostname -I
ip=ip a | grep 'inet ' | awk '{print $2}' | tr '\n' ' '

echo "System information as of: $date"
echo
printf "System Load:\t%s\tIP Address:\t%s\n" $load "$ip"
printf "Memory Usage:\t%s\tSystem Uptime:\t%s\n" $memory_usage "$time"
printf "Usage On /:\t%s\tSwap Usage:\t%s\n" $root_usage $swap_usage
printf "Local Users:\t%s\tProcesses:\t%s\n" $users $processes
echo

Footer (90-footer)

!/bin/sh

#

90-footer - write the admin's footer to the MOTD

Copyright (c) 2013 Nick Charlton

Copyright (c) 2009-2010 Canonical Ltd.

#

Authors: Nick Charlton hello@nickcharlton.net

Dustin Kirkland kirkland@canonical.com

#

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License as published by

the Free Software Foundation; either version 2 of the License, or

(at your option) any later version.

#

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

GNU General Public License for more details.

#

You should have received a copy of the GNU General Public License along

with this program; if not, write to the Free Software Foundation, Inc.,

51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

[ -f /etc/motd.tail ] && cat /etc/motd.tail || true

Once these files are populated with the above, you should now be able to logout and then log back in either using putty or on the console and you will be presented with something that looks like below.

hoooo merde !

heu non, en cas d'urgence, on va aux.... Urgences ! Arrêtez avec vos "médecines douces" dans des cas comme ça, vous vous mettez en danger ou pire vous mettez en danger vos proches !
Sinon, pour la bobologie ou les petits tracas tant qu'ils sont rares et pas trop douleurs, j'ai rien à dire, faites ce que vous voulez.

ha bien !
via https://bookmarks.geekandfree.org/?meRaEQ

à tester. comment certains peuvent encore prétendre être efficace sur nano...
EDIT:
echo "set undodir=~/.vimundo" >>/etc/vim/vimrc
echo "set undofile" >>/etc/vim/vimrc

et bim !

ça semble sympa.

ça fait quoi ?

à tester
#bashtips #bashrc

function setproxy() {
export {http,https,ftp}_proxy='http://greatfirewall.bullshit.tld:<PORT>'
}

function unsetproxy() {
unset {http,https,ftp}_proxy
}

function httpretcode {
curl -sIL $1 | grep HTTP | tail -n1 | cut -d " " -f 2
}

USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t
IF OBJECT_ID('t_uq') IS NOT NULL DROP FUNCTION t_uq
GO

CREATE TABLE t(c0 INT, c1 NVARCHAR(50), c2 bit)
GO

CREATE FUNCTION t_uq(@c1 NVARCHAR(50))
RETURNS bit
AS
BEGIN
DECLARE @ret bit
IF (SELECT COUNT(*) FROM t WHERE c1 = @c1 AND c2 = 1) > 1
SET @ret = 0
ELSE
SET @ret = 1
RETURN @ret
END
GO

ALTER TABLE t ADD CONSTRAINT t_c CHECK(dbo.t_uq(c1) = 1)

INSERT INTO t(c0, c1, c2) VALUES(1, 'a', 0) --OK
INSERT INTO t(c0, c1, c2) VALUES(2, 'a', 0) --OK
INSERT INTO t(c0, c1, c2) VALUES(3, 'b', 1) --OK
INSERT INTO t(c0, c1, c2) VALUES(4, 'b', 1) --Fails

--So far so good, but watch now:

UPDATE t SET c2 = 1 WHERE c0 = 2
--No error, the constraint doesn't do its job!

--We have invalid data:
SELECT * FROM t

Les gens qui vont chez le docteur : "Je vais mal, et voici en détail tous mes symptômes."
Les gens qui vont chez le garagiste : "Ma voiture ne marche plus, voici tout ce que j'ai noté"
Les gens qui ont un souci informatique : "CA MARCHE PAS. VOILA MERCI AU REVOIR."
-> tellement vrai

parfait.

outch...

Pour empécher à ssh de mettre les clefs dans le know_hosts (parce que sur un réseau en dhcp, c'est ****)
Host .mydomain.com
StrictHostKeyChecking no
UserKnownHostsFile /dev/null
LogLevel QUIET