szabacsik

Start MySql database with Apache/PHP and phpMyAdmin

docker run --name mysql -d -e MYSQL_ROOT_PASSWORD=PASSWORD -e MYSQL_ROOT_HOST=% -p 3306:3306 mysql/mysql-server:latest
docker run --name phpmyadmin -d --link mysql:db -p 8080:80 phpmyadmin/phpmyadmin:latest
docker run --name php -d --link mysql:db -p 80:80 php:apache
docker exec php bash -c "echo \"<?php phpinfo();\" >> /var/www/html/index.php"

Stop all running containers

szabacsik

<?php

/**
 * This PHP script creates CSV snapshots of all tables in a specified MySQL database.
 * Useful for database analysis and backup purposes. The script connects to the MySQL
 * database using PDO, retrieves the list of all tables (excluding specified ones),
 * and then exports each table's contents to a CSV file. The CSV files are saved in a
 * directory named 'snapshots' inside the script's directory, with each run generating
 * a new timestamped subdirectory for organization.
 *

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

<?php

/**
 * MySQL Table Change Logging Trigger Generator Script
 *
 * This script generates triggers for all tables in the $dbname database,
 * which log INSERT, UPDATE, and DELETE operations.
 * The triggers record modifications in the 'change_log' table,
 * storing the name of the affected table, the type of change (INSERT, UPDATE, DELETE),
 * the timestamp of the change, and the old and new data of the affected rows in JSON format.

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

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 - DBAL / ORM / Query Builder

Doctrine Query Builder

use Doctrine\DBAL\DriverManager;

require_once __DIR__ . '/vendor/autoload.php';

$connectionParams = [

szabacsik

Linux User Management

create group with group id

groupadd -g 1000 johndoe

create user with user id and group id

useradd -m --home /home/johndoe johndoe --uid 1000 --gid 1000 --groups group1,group2,sudo

szabacsik

diff --brief --recursive /path/to/dir1 /path/to/dir2

szabacsik

# yum remove php* -y
yum clean all
yum makecache
yum update -y
yum install dnf -y
dnf upgrade --refresh
yum-config-manager --disable remi-php74
yum-config-manager --enable remi-php81
dnf install php php-cli php-common php-pdo php-xml php-mbstring php-zip php-devel php-curl php-pear php-json php-xdebug -y