alexantr

@echo off

REM Minify JS CSS SVG

REM npm install uglify-js -g
REM or
REM npm install terser -g
REM npm install clean-css-cli -g
REM npm install svgo -g

alexantr

<?php

// download latest from https://www.adminer.org/latest-mysql-en.php
$files = scandir(__DIR__, SCANDIR_SORT_DESCENDING);
foreach ($files as $file) {
    if ($file != '.' && $file != '..' && is_file(__DIR__ . '/' . $file) && strpos($file, 'adminer-') === 0 && substr($file, -4) === '.php') {
        $f = str_replace('-mysql', '', $file);
        if (is_file(__DIR__ . '/' . $f)) {
            require __DIR__ . '/' . $f;
            break;

alexantr

<?php

$url = 'https://www.adminer.org/latest-mysql-en.php';

$data = get_web_page($url);

if (isset($data['url'], $data['content'])) {
    print_r($data['url']);

    file_put_contents(basename($data['url']), $data['content']);

alexantr

#!/bin/bash

# save password for db user "backup" in "~/.mylogin.cnf":
# mysql_config_editor set --login-path=local --host=localhost --user=backup --password
# permisions for backup user: Select table data, Show databases, Lock tables, Show View

# Base folder with backups
BASE_BACKUP_DIR="$HOME/.backup"

# Current date for folder name