vzool

Backup android app, data included, no root needed, with adb

Note: This gist may be outdated, thanks to all contributors in comments.

adb is the Android CLI tool with which you can interact with your android device, from your PC

You must enable developer mode (tap 7 times on the build version in parameters) and install adb on your PC.

Don't hesitate to read comments, there is useful tips, thanks guys for this !

vzool

name: Node CI

on:
  push:
    tags:
      - 'v*'

jobs:
  upload-release:

vzool

# Add Repository to your system (ondrej/php PPA)

sudo apt install apt-transport-https lsb-release ca-certificates
sudo wget -O /etc/apt/trusted.gpg.d/php.gpg https://packages.sury.org/php/apt.gpg
sudo sh -c 'echo "deb https://packages.sury.org/php/ $(lsb_release -sc) main" > /etc/apt/sources.list.d/php.list'
sudo apt update

# Install PHP 7.1
sudo apt install php7.1

vzool

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.

vzool

# Bitbucket Git Downloader
# Copyright (c) Davide Gironi, 2021
# Released under GPLv3

# Downloads all the repository from a Bitbucket account

vzool

-- Reasonably efficient pagination without OFFSET
-- SQLite version (Adapted from MS SQL syntax)
-- Source: http://www.phpbuilder.com/board/showpost.php?p=10376515&postcount=6

SELECT foo, bar, baz, quux FROM table
 WHERE oid NOT IN ( SELECT oid FROM table
                    ORDER BY title ASC LIMIT 50 )
 ORDER BY title ASC LIMIT 10

vzool

1. Generate a gpg key

With GnuPG 2.1.15

If you want to create an RSA or DSA key in a straight forward way use:

gpg --full-gen-key

If you want to use an ECC algorithm, you need to add the --expert flag

gpg --expert --full-gen-key

vzool

<?php

// Updated code from comments

function encode($value) {
    if (!$value) {
        return false;
    }

    $key = sha1('EnCRypT10nK#Y!RiSRNn');

vzool

if [ ! -f .env ]
then
  export $(cat .env | xargs)
fi

vzool

# dump
mysqldump -u user -p database --default-character-set=utf8mb4 --result-file=dump.sql

# restore
mysql -u user -p database --default-character-set=utf8mb4 < dump.sql