#!/bin/bash

sudo apt-get -y install build-essential

# create database
mysql -u root -p
create database drupal;
CREATE USER drupalo IDENTIFIED BY 'drupalp';
grant all on drupal.* to 'drupalo'@'%' identified by "drupalp";
commit;
quit;

# create installation file on your webserver
cat < /var/www/drupal-install.php
<?php
# dowload
system("/usr/local/bin/wget http://ftp.drupal.org/files/projects/drupal-6.19.tar.gz");

# extract
system("/usr/bin/tar xzf ./drupal-*.tar.gz");

# move drupal files to current dir
system("/bin/mv drupal-*/* .");
system("/bin/mv drupal-*/.* .");

# configure
system("/bin/cp ./sites/default/defa

DB_HOST=localhost
DB_NAME=db1
DB_USER=root
DB_PASS=pass1234
TARGET=/tmp

# export DB
mysqldump --host=${DB_HOST} --password=${DB_PASS} --user=${DB_USER} ${DB_NAME} | bzip2 --best > ${TARGET}/$(hostname -f)_${DB_NAME}_$(date -I).sql.bz2

# import DB
bzcat /tmp/db_dump_${DB_NAME}.sql.bz2 | mysql --host=localhost --user=${DB_USER} --password=${DB_PASS} ${DB_NAME}
mysql --host=localhost --user=${DB_USER} --password=${DB_PASS} ${DB_NAME} < dump.sql

# import bzip2 compressed file
bzip2 -dc dump.sql.bz2 | mysql --user=${DB_USER} --password=${DB_PASS} ${DB_NAME}

# get settings
gsettings list-recursively | grep -i gedit
gsettings list-recursively org.gnome.settings-daemon.plugins.power
dconf read /org/gnome/settings-daemon/plugins/media-keys/calculator

# unity
setsid unity
dconf dump /org/compiz/

# http://askubuntu.com/questions/67355/how-do-i-completely-turn-off-screensaver-and-power-management
# /usr/share/glib-2.0/schemas/org.gnome.desktop.wm.preferences.gschema.xml

dconf watch /
http://askubuntu.com/questions/359593/is-it-possible-to-monitor-dconf-for-changes

# reset pannel settings
gconftool-2 --recursive-unset /apps/panel
d

#!/bin/bash

if [ $# -eq 0 ]; then
echo "USAGE $0 XEN_NAME DISK_SIZE RAM_SIZE DIST_NAME"
echo "Example: $0 srv1 4096 256 edgy"
exit
fi

XEN_NAME=$1
DISK_SIZE=$2
RAM_SIZE=$3
DIST_NAME=$4

# prepare directories
if [ ! -d /home/xen ]; then
mkdir /home/xen
fi

if [ ! -d /home/xen/domains ]; then
mkdir /home/xen/domains
fi

if [ !

# create automaticly a session
session.auto_start = ON

# disable global variables
register_globals = OFF

# increase upload limit
upload_max_filesize = 50M

#!/bin/bash

sudo su

wget http://www.medibuntu.org/sources.list.d/hardy.list -O /etc/apt/sources.list.d/medibuntu.list
apt-get update
apt-get -y --force-yes install medibuntu-keyring
apt-get update
apt-get -f --force-yes install acroread

# stop mysql
/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables &

# login
mysql -u root

# in mysql
use mysql;
update user set password=PASSWORD("NEW_PASS") where User='root';
flush privileges;
quit

# start mysql
/etc/init.d/mysql start

# Links
http://www.cyberciti.biz/tips/recover-mysql-root-password.html
http://www.cyberciti.biz/faq/mysql-change-root-password/

# BASH
echo "create database ${DB_NAME}" | mysql --user=${DB_USER} --password=${DB_PASS}

# SQL
mysql -u root -p
create database db_name;
create user db_user identified by 'user_pass';
grant all on db_name.* to 'db_user'@'%';
commit;
quit;

@echo off

set imageSmall=%~dp1%~n1_klein.jpg
set imageBig=%~dp1%~n1_gross.jpg
set quality=-quality 80

rem small
convert.exe -resize "150x100" %quality% %1 "%imageSmall%"

rem big
convert.exe -resize "1000x500>" %quality% %1 "%imageBig%"