Rheman Tidalgo tidalgo22

## XAMPP - Replacing MariaDB with MySQL
As of XAMPP 5.5.30 and 5.6.14, XAMPP ships MariaDB instead of MySQL. MariaDB is not 100% compatible with MySQL and can be replaced with the “orginal” MySQL server.

Requirements
Windows
XAMPP for Windows
Administrator privileges to restart Windows services
Backup
Backup the old database into a sql dump file
Stop the MariaDB service
Rename the folder: c:\xampp\mysql to c:\xampp\mariadb

## Steps to Upgrade MariaDB for XAMPP
I’m a fan of short articles/news!

Tested: Upgrading to MariaDB 10.2 for XAMPP v7.1.4

Download an installer of the latest stable version of MariaDB
Be sure all modules are stopped from the XAMPP Control Panel
Rename (xampp path)/mysql to something else (i.e. mysql-old)
Install the downloaded MariaDB to the (xampp path)/mysql
Copy the mysql-old/bin/my.ini file to mysql/bin directory
Copy all .ini and .bat files from mysql-old root to the mysql root

## Update xampp from maria db 10.1 to 10.2
1 : Shutdown or Quit your XAMPP server from Xampp control panel.
2 : Download the ZIP version of MariaDB https://downloads.mariadb.org/mariadb/10.2.10/
3 : Rename the xampp/mysql folder to mysql_old.
4 : Unzip or Extract the contents of the MariaDB ZIP file into your XAMPP folder.
5 : Rename the MariaDB folder, called something like mariadb-5.5.37-win32, to mysql.
6 : Rename xampp/mysql/data to data_old.
7 : Copy the xampp/mysql_old/data folder to xampp/mysql/.
8 : Copy the xampp/mysql_old/backup folder to xampp/mysql/.
9 : Copy the xampp/mysql_old/scripts folder to xampp/mysql/.
10: Copy mysql_uninstallservice.bat and mysql_installservice.bat from xampp/mysql_old/ into xampp/mysql/.

## Nodejs Crash Course
https://www.youtube.com/watch?v=6oP-c30s7co

## Vuejs Expressjs Getting Started
First make your repo and pull it.

Lets get started:
we need to install vue cli https://github.com/vuejs/vue-cli/tree/v2#vue-cli--
npm install -g vue-cli

Then create our project,
vue init webpack my-project //client on my case

Questions will be prompt just answer it with yes.

## mongo-express
docker run -it --rm -p 8081:8081 --link mongo_1:mongo --net my_app_default mongo-express

my_app_default is the network get it using docker network ls
mongo_1 on mongo_1:mongo is the container name.

ref:
https://github.com/mongo-express/mongo-express/issues/215


## Docker mongorestore
Docker exec -it <mongo_container_name> /bin/bash

on shell access:
- mongo
- show dbs
- use db_sample
- db.dropDatabase()
- show dbs :check if db_sample has been deleted

exit mongo and run mongorestore

## Git Tutorials
A better Git workflow with rebase
https://www.youtube.com/watch?v=f1wnYdLEpgI

## aws ec2 ufw ssh block
https://ubuntuaws.wordpress.com/2017/05/10/locked-myself-out-of-ssh-port-ubuntu-aws-server-using-ufw/

## laravel with aws ses
https://www.ritolab.com/entry/73
	As of XAMPP 5.5.30 and 5.6.14, XAMPP ships MariaDB instead of MySQL. MariaDB is not 100% compatible with MySQL and can be replaced with the “orginal” MySQL server.

	Requirements
	Windows
	XAMPP for Windows
	Administrator privileges to restart Windows services
	Backup
	Backup the old database into a sql dump file
	Stop the MariaDB service
	Rename the folder: c:\xampp\mysql to c:\xampp\mariadb
	I’m a fan of short articles/news!

	Tested: Upgrading to MariaDB 10.2 for XAMPP v7.1.4

	Download an installer of the latest stable version of MariaDB
	Be sure all modules are stopped from the XAMPP Control Panel
	Rename (xampp path)/mysql to something else (i.e. mysql-old)
	Install the downloaded MariaDB to the (xampp path)/mysql
	Copy the mysql-old/bin/my.ini file to mysql/bin directory
	Copy all .ini and .bat files from mysql-old root to the mysql root
	1 : Shutdown or Quit your XAMPP server from Xampp control panel.
	2 : Download the ZIP version of MariaDB https://downloads.mariadb.org/mariadb/10.2.10/
	3 : Rename the xampp/mysql folder to mysql_old.
	4 : Unzip or Extract the contents of the MariaDB ZIP file into your XAMPP folder.
	5 : Rename the MariaDB folder, called something like mariadb-5.5.37-win32, to mysql.
	6 : Rename xampp/mysql/data to data_old.
	7 : Copy the xampp/mysql_old/data folder to xampp/mysql/.
	8 : Copy the xampp/mysql_old/backup folder to xampp/mysql/.
	9 : Copy the xampp/mysql_old/scripts folder to xampp/mysql/.
	10: Copy mysql_uninstallservice.bat and mysql_installservice.bat from xampp/mysql_old/ into xampp/mysql/.
	First make your repo and pull it.

	Lets get started:
	we need to install vue cli https://github.com/vuejs/vue-cli/tree/v2#vue-cli--
	npm install -g vue-cli

	Then create our project,
	vue init webpack my-project //client on my case

	Questions will be prompt just answer it with yes.
	docker run -it --rm -p 8081:8081 --link mongo_1:mongo --net my_app_default mongo-express

	my_app_default is the network get it using docker network ls
	mongo_1 on mongo_1:mongo is the container name.

	ref:
	https://github.com/mongo-express/mongo-express/issues/215
	Docker exec -it <mongo_container_name> /bin/bash

	on shell access:
	- mongo
	- show dbs
	- use db_sample
	- db.dropDatabase()
	- show dbs :check if db_sample has been deleted

	exit mongo and run mongorestore
	A better Git workflow with rebase
	https://www.youtube.com/watch?v=f1wnYdLEpgI