My mysqld runs on Ubuntu Hardy and after replacing the complete mysql data with a dump from another server the "/etc/init.d/mysql stop" command fails, because the system administration account doesn't work anymore. So I had to recreate it again:
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
The password can be obtained from /etc/mysql/debian.cnf.
Finding files with the find command is actually more difficult than it should be.
This finds and lists the largest files (more than 200 MB) on the whole file system:
find / -type f -size +200000k -exec ls -lh {} \; | awk '{ print $9 ": " $5 }'
The same, but simpler syntax:
find / -size +200M -ls
This finds the most recently changed files under the current directory:
find . -type f -printf '%TY-%Tm-%Td %TT %p\n' | sort
I do offsite backups using BackupPC. The amount of data increases constantly so I need to add occasionally hard disks. Additionally I want the data to be encrypted, at least after powering off the system that is running the BackupPC application. So I decided to use logical volume management (LVM) and block device encryption (cryptsetup). The following steps were needed (on Ubuntu Feisty):