Guchie francisguchie

############### INSTALLING MySQL 5.6 ON UBUNTU 20.04 LTS

start by updating the release sudo apt-get update && sudo apt-get dist-upgrade

###### Uninstall any existing version of MySQL

check if you have any mysql installed

mysql -version or sudo dpkg -l | grep mysql

Useful LXD commands

Summarized from https://stgraber.org/2016/03/19/lxd-2-0-your-first-lxd-container-312/.

Interestingly, the LXD command line client is named.... lxc!

List available containers

lxc image list ubuntu:        # ubuntu: is officially supported image source
lxc image list images:        # images: is an unsupported source
lxc image alias list images:  # lists user-friendly names

Angular CLI version	Angular version	Node.js version	TypeScript version	RxJS version
1.0.0-beta.17 (package name: angular-cli)	2.0.x	6.9.x or later minor version	2.0.x	5.0.x or later minor version
1.0.0-beta.20-1 (package name: angular-cli)	2.1.x	6.9.x or later minor version	2.0.x	5.0.x or later minor version
1.0.0-beta.22-1 (package name: angular-cli)	2.2.x	6.9.x or later minor version	2.0.x	5.0.x or later minor version
1.0.0-beta.30	2.3.x	6.9.x or later minor version	2.0.x	5.0.x or later minor version
1.0.0-rc.4	2.4.x	6.9.x or later minor version	2.0.x	5.0.x or later minor version
1.0.6	4.0.x/4.1.x	6.9.x or later minor version	2.2.x	5.0.x or later minor version
1.1.3	4.0.x/4.1.x	6.9.x or later minor version	2.3.x	5.0.x or later minor version
1.2.7	4.0.x/4.1.x	6.9.x or later minor version	2.3.x	5.0.x or later minor version
1.3.2	4.2.x/4.3.x/4.4.x	6.9.x or later minor version	2.4.x	5.0.x or later minor version

	-- without using SET variable
	SELECT t.id,
	t.count,
	(@running_total := @running_total + t.count) AS cumulative_sum
	FROM TABLE t
	JOIN (SELECT @running_total := 0) r
	ORDER BY t.id

	-- with SET variable
	SET @running_total := 0;

	-- without using SET variable
	SELECT t.id,
	t.count,
	(@running_total := @running_total + t.count) AS cumulative_sum
	FROM TABLE t
	JOIN (SELECT @running_total := 0) r
	ORDER BY t.id

	-- with SET variable
	SET @running_total := 0;

	# MySQL Server Instance Configuration File
	# ----------------------------------------------------------------------
	# Generated by the MySQL Server Instance Configuration Wizard
	#
	#
	# Installation Instructions
	# ----------------------------------------------------------------------
	#
	# On Linux you can copy this file to /etc/my.cnf to set global options,
	# mysql-data-dir/my.cnf to set server-specific options

	# * Application-specific options follow here *

	#
	# The MySQL server
	#
	[mysqld]

	# The maximum amount of concurrent sessions the MySQL server will
	# allow. One of these connections will be reserved for a user with
	# SUPER privileges to allow the administrator to login even if the

	#!/bin/bash
	##this script will backup mysql and upload it to google drive
	##directory name
	dirname=$1;
	##database name
	database=$2;
	##database username
	dbuser=$3;
	##database password
	dbpass=$4;