cedricmagne

From 473846959772d8160b34b92ae3bcecddf24b972f Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Julian=20Nu=C3=9F?= <julian.nuss@outlook.com>
Date: Tue, 23 Sep 2014 21:07:29 +0200
Subject: [PATCH 1/1] [BUGIFX] Zend Framework 1 + PHP5.6

---
 lib/Zend/Locale/Format.php          | 22 +++++++++++-----------
 lib/Zend/Service/Audioscrobbler.php |  6 +++---
 lib/Zend/Service/Technorati.php     |  6 +++---
 lib/Zend/Validate/Hostname.php      |  4 ++--

cedricmagne

# Truncate a file
$ cat /dev/null >| my_file.log
## OR
$ truncate -s0 yourfile
##if permission denied, use sudo
$ sudo truncate -s0 yourfile

cedricmagne

# must run as root
sudo varnishd -f /usr/local/etc/varnish/default.vcl -s file -a 127.0.0.1:80

# help: see available arguments with descriptions
varnishd -h

# -f Specifies the location of the vcl script to launch Varnish with.
# -s Specifies storage options. The file argument stores in /tmp by default. You can specify another location with -s file,/location
# -a Specifies the address and port that Varnish will run at. You can access your website through Varnish using this address and port.

cedricmagne

## Usage
command [options] [arguments]

## Options
--help (-h)           Display this help message
--quiet (-q)          Do not output any message
--verbose (-v|vv|vvv) Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debugging
--version (-V)        Display an application version
--ansi                Force ANSI output
--no-ansi             Disable ANSI output

cedricmagne

##
## Create mysql triggers dump
## We add DROP TRIGGER IF EXISTS with option --add-drop-trigger
## This option is supported only by mysqldump as supplied with MySQL Cluster. It is not available when using MySQL Server 5.5.
## If you don't need password dont use -p option.
##
mysqldump -u <USERNANME> -p --routines --add-drop-trigger --no-create-info --no-data --no-create-db --skip-opt <database> > outputfile.sql

##
## Change old DEFINER with sed command

cedricmagne

-- Show triggers
SHOW TRIGGERS;

-- Show free lock
SELECT IS_FREE_LOCK('DATABASE_NAME.reindex_full')

-- Log all queries
-- Mysql need to have write access on mysql_general.log
SET global log_output = 'FILE';
SET global general_log_file='/var/log/mysql/mysql_general.log';