mysqlcheck -u root -pxxxxx --repair wordpress wp_options
Uncategorized
Convert iso to vhd
qemu-img convert -f raw -O vpc input.iso output.vhd
opensuse upgrade on 15.x
#!/bin/bash
oldver=15.1
releasever=15.2
set -x
zypper ref;zypper up
zypper lr --url
sed -i "s/${oldver}/${releasever}/g" /etc/zypp/repos.d/*.repo
zypper --releasever=$releasever ref
zypper --releasever=$releasever dup --download-in-advance
settings to allow MacSSH to connet to a modern sshd
in /etc/ssh/sshd_config, add this section#---- BEGIN --- Legacy changes, ok for Macos9
HostKeyAlgorithms +ssh-rsa
KexAlgorithms +diffie-hellman-group1-sha1
Ciphers +aes128-cbc,3des-cbc
#---- END ----- Legacy changes, ok for Macos9
add some colour to your prompt
PS1=”[\033[01;32m]GREEN[\033[0m]:”uname -n’-[‘/usr/bin/whoami’]$PWD$ ‘
print all available ansi colors
#!/bin/bash
color=16;
while [ $color -lt 245 ]; do
echo -e "$color: \\033[38;5;${color}mhello\\033[48;5;${color}mworld\\033[0m"
((color++));
done
remove ansi colors from file
cat file.txt | sed 's/\x1b[[0-9;]*m//g'
get disk info for all solaris zones, including zfs and vxfs disks
#!/bin/bash
for z in `zoneadm list -cv | grep -iv global | grep -v NAME|awk '{ print $2 }'` ;do
zonecfg -z $z info | grep -i vx | grep -i rdsk | awk -F'/' '{ print $5 }' | sort | uniq | while read dg;do
# echo "----------------- $z : $dg"
dgs=$dg
vxdisk -o alldgs list | egrep "$dgs"| awk '{ print $1 " " $4 }' | while read -r d g;do D=`/usr/sbin/vxdisk list $d | egrep '^c.t.*' | awk '{ print $1 }'`
NOS2=`echo $D | sed 's/s2$//g'`
SIZE=`grep -i $NOS2 format.txt | awk '{ print $NF }' | awk -F'-' '{ print $NF }' | sed 's/>//g;s/GB//g'`
echo "$z : $g : $NOS2 : $SIZE : $d"
done
done
done
get disk serial ids in AIX
#!/bin/sh
lspv | awk '{ print $1 }' | while read d;do
S=`lsmpio -ql $d | grep -i serial | awk '{ print $3 }'`
echo "$d : $S"
done
Create a pacemaker resource from a systemd service
pcs resource create example systemd:custom.service --group mygroup