arkadiusjonczek

/** MySQL hostname */
if (php_sapi_name() == 'cli') {
    define( 'DB_HOST', '127.0.0.1' );
}
else {
    define( 'DB_HOST', 'mysql' );
}

arkadiusjonczek

sudo lsof -i
sudo netstat -lptu
sudo netstat -tulpn

arkadiusjonczek

SELECT DISTINCT uid
FROM tt_news
ORDER BY uid
INTO OUTFILE '/tmp/uids.csv'
LINES TERMINATED BY ',';

arkadiusjonczek

readlink -f file.txt

arkadiusjonczek

SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS 
WHERE table_name = 'oxarticles' AND COLUMN_NAME = 'OXID';
  
SELECT
  COLUMN_NAME, DATA_TYPE 
FROM
  INFORMATION_SCHEMA.COLUMNS 
WHERE
  TABLE_SCHEMA = 'ods'
AND

arkadiusjonczek

-- Query 1
SELECT 
	sum(round(((data_length + index_length) / 1024 / 1024 / 1024), 2)) as "Size in GB"
FROM 
	information_schema.TABLES
WHERE 
	table_schema = "ods"

-- Query 2
SELECT 

arkadiusjonczek

xdebug.profiler_enable=1
xdebug.profiler_output_dir="/var/www/debug"

arkadiusjonczek

# remove tag 1.1
git tag -d 1.1
git push origin :refs/tags/1.1

# tag current and push to origin
git tag 1.1
git push origin 1.1

arkadiusjonczek

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^(.*)$ http://domain.de [R=301,L]
</IfModule>

arkadiusjonczek

cat ~/.ssh/id_rsa.pub | pbcopy