bunch of loose ends – things i keep on forgetting
* setting mysql datadir to different folder (on ubuntu 8.10) : adapt /etc/my.cnf AND tweak /etc/apparmor.d/usr.sbin.mysqld
#snippet usr.sbin.mysqld /data/db/ r, /data/db/** rwk,
* adding an entry in fstab is using UUID instead of /dev/ description - how to find UUID ?
sudo vol_id -u /dev/sda1
* filling up a db with sql-dumped data
mysql --user=artnd -p -e "source artnd_database" artnd
* serving a folder with apache2 : add a conf file to /etc/apache2/conf.d eg
Alias /artnd /data/
<Directory /data>
Options IncludesNoExec
Order allow,deny
Allow from all
</Directory>
* minimal xorg.conf (nvidia)
# sudo dpkg-reconfigure -phigh xserver-xorg Section "Monitor" Identifier "Configured Monitor" EndSection Section "Screen" Identifier "Default Screen" Monitor "Configured Monitor" Device "Configured Video Device" DefaultDepth 24 EndSection Section "Module" Load "glx" EndSection Section "Device" Identifier "Configured Video Device" Driver "nvidia" Option "NoLogo" "True" EndSection
* dev tools on fedora
yum groupinstall "Development Tools" "Legacy Software Development"
* cool tool : screen (copy pasted random notitions while steef explained some)
ptr@hsb:~$ cat .screenrc
hardstatus alwayslastline "%{=b}%{-b}%{dw} %{.c}%d-%m %{.y}%0c %{dd}
%-Lw%{dg}%n%f* %t%? (%u)%? %{-}%+Lw %{dw}"
vbell off
screen -r
(needs .screenrc)
(ctrl-a n)
(ctrl-a p)
(ctrl-a d)
sleep 10000
(ctrl-z)
disown -h
(kill your term if you like)
tty
* rsync with bandwithlimit
rsync -av --bwlimit=512 downloads.openwrt.org::openwrt-downloads/sources .