szabacsik

Test webpage loading speed with Curl

curl -s -w 'Testing Website Response Time for: %{url_effective}\n\nLookup Time:\t\t%{time_namelookup}\nConnect Time:\t\t%{time_co
nnect}\nPre-transfer Time:\t%{time_pretransfer}\nStart-transfer Time:\t%{time_starttransfer}\n\nTotal Time:\t\t%{time_total}\n' -o /dev/null ADDRESS

https://www.techrepublic.com/article/how-to-test-a-website-loading-speed-using-the-curl-command

Test webpage loading speed with wget and time

time wget --quiet --output-document=/dev/null http://httpbin.org/delay/3

szabacsik

MySQL Cheatsheet

Export Tables

mysqldump -h 127.0.0.1 -u root --password=root --column-statistics=0 SOURCE-DATABASE TABLE-NAME TABLE-NAME | gzip > EXPORT.sql.gz
gunzip < EXPORT.sql.gz | mysql -h 127.0.0.1 -u root --password=root TARGET-DATABASE

Export Database but ignore some tables

szabacsik

run logrotate manually

logrotate.conf

/path/to/logs/*.log {
    weekly
    rotate 5
    compress
    olddir /path/to/logs/archived
}

szabacsik

Replace all the occurrence of the pattern in a file

sed -i 's/lorem=.*/lorem=REPLACED/g' /path/to/the/config.ini

Before

lorem=ipsum
dolor=sit

szabacsik

Find

find ./Photos -type f | wc -l

Rsync

rsync --stats --dry-run -ax ./Photos /tmp

szabacsik

<?php
/*
 * composer require symfony/validator
 * composer require beberlei/assert
 * composer require webmozart/assert
 * composer require respect/validation
 * composer require laminas/laminas-validator
 * composer require laminas/laminas-servicemanager
 {
     "require": {

szabacsik

<?php

class Token
{
    public static function generate()
    {
        $microtime = microtime(true);
        $microtimeString = (string)number_format($microtime, 6, '.', '');
        if (!strpos($microtimeString, '.'))
            $microtimeString = $microtimeString . '.0';

szabacsik

find all files that don't contain a text string

find . -type f -name '*_response.xml' | xargs grep -H -c -i 'success' | grep 0$ | cut -d':' -f1

https://unix.stackexchange.com/questions/26836/how-can-i-find-all-files-that-do-not-contain-a-text-string

find all files between two dates

find . -type f -name '*.xml' -newermt "2020-07-03" ! -newermt "2020-07-04"

szabacsik

; PHP 7
extension = gd2
;https://windows.php.net/downloads/pecl/releases/trader/
;extension = php_trader.dll

; Xdebug 2
zend_extension = php_xdebug.dll
xdebug.remote_port = 9000
xdebug.remote_enable = On
xdebug.remote_autostart = On

szabacsik

Apache Cordova / PhoneGap Quick Start Guide

Create Mobile apps with HTML, CSS & JS ( bootstrap, jquery )

npm install -g cordova

mkdir myCordovaProject && cd myCordovaProject