-- update magento directory path
UPDATE core_config_data SET value = 'http://www.example.com/' WHERE path = 'web/unsecure/base_url';
UPDATE core_config_data SET value = 'https://www.example.com/' WHERE path = 'web/secure/base_url';

-- enable ssl on fronted and backend
USE magento;
UPDATE core_config_data SET value = 1 WHERE path = 'web/secure/use_in_frontend';
UPDATE core_config_data SET value = 1 WHERE path = 'web/secure/use_in_adminhtml';

-- clear cache
rm -r /var/www/var/cache/ /var/www/var/session/

-- disable cache
UPDATE core_cache_option SET value = 0;

-- disable redir

-- delete all tax definitions
DELETE FROM tax_calculation_rule;
DELETE FROM tax_class;
DELETE FROM tax_calculation_rate;
DELETE FROM tax_calculation;

-- create tax_class
INSERT INTO tax_class(class_name, class_type) VALUES
('Umsatzsteuerpfichtige Güter 19%','PRODUCT'),
('Umsatzsteuerpfichtige Güter 7%','PRODUCT'),
('Umsatzsteuerfreie Güter','PRODUCT'),
('inkl.

# preconfigure nullmailer
debconf-set-selections <<\EOF
nullmailer shared/mailname string $(hostname)
nullmailer nullmailer/relayhost string YOUR_SMTP_HOST smtp --auth-login --user=YOUR_SMTP_USER --pass=YOUR_SMTP_PASS
EOF

# install nullmailer
apt-get install -y nullmailer

# configure mailname
echo "YOUR_DOMAIN" > /etc/mailname

# send test email
echo "This is a test message from ${USER}@${HOSTNAME} at $(date)" | sendmail -f SENDER@YOUR_MAIL.COM RECIPIENT@YOUR_MAIL.COM

# change from / sender address
NULLMAILER_USER=info
# broken?

import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

public class MysqlTest {

private final static String dbUser = "dbo_java";
private final static String dbPass = "java_test";
private final static String dbHost = "192.168.1.111";
private final static String dbName = "java";

public static void main(String[] args) {
Connection conn = null;

try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://" + dbHos

#!/bin/bash

DB_HOST=localhost
DB_NAME=magento
DB_USER=magento
DB_PASS=magento

mysqldump --host=${DB_HOST} --password=${DB_PASS} --user=${DB_USER} ${DB_NAME} > ${DB_NAME}.$(date "+%Y-%m-%d_%H:%M:%S").sql