Skip to content

Instantly share code, notes, and snippets.

View tidalgo22's full-sized avatar
🏠
Working from home

Rheman Tidalgo tidalgo22

🏠
Working from home
View GitHub Profile
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/.
https://www.youtube.com/watch?v=6oP-c30s7co
@tidalgo22
tidalgo22 / Vuejs Expressjs Getting Started
Created July 30, 2018 08:07
Get started with Vuejs and Expressjs with this guidelines
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.
@tidalgo22
tidalgo22 / mongo-express
Last active March 14, 2019 12:09
setting up mongo admin interface on existing mongodb container
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
@tidalgo22
tidalgo22 / Docker mongorestore
Created July 13, 2018 04:24
mongorestore on existing running container
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
https://ubuntuaws.wordpress.com/2017/05/10/locked-myself-out-of-ssh-port-ubuntu-aws-server-using-ufw/
https://www.ritolab.com/entry/73