https://www.howtoforge.com/tutorial/how-to-install-gitlab-on-debian-8/
How to center in html css
https://www.w3.org/Style/Examples/007/center.en.html http://vanseodesign.com/css/vertical-centering/
Lightslider js (Nice & Convinient Plugin for Slider)
http://sachinchoolur.github.io/lightslider/ ### HTML ### <div id=”image-thumbnail”> <div class=”carousel-control left” id=”left”> <i class=”fa fa-angle-left fa-3″></i> </div> <div class=”carousel-control right” id=”right”> <i class=”fa fa-angle-right fa-3″></i> </div> </div> ### Javascript ### $.ajax({ type: “POST”, url: “https:///getImages”, data: {product_id : }, success: function (result) { data = JSON.parse(result); $(“#image-thumbnail”).append(“”); for (const [key, value] of Object.entries(data[].img)){ $(“#image-gallery”).append(“<li><img src=’https://” + value.url […]
Easytab js ( Nice & Convenient Plugin for Tabs)
https://os.alfajango.com/easytabs/
mysql replace character
UPDATE game SET g_game_path = REPLACE(g_game_path,”s1.g”,”um”); For the query above, is to update the “game” table , to replace g_game_path’s “s1.g” into “um”
MYSQL INSERT INTO SELECT
To select data from table a to insert into b INSERT INTO ‘DB_NAME’.’TABLE_NAME'(TABLE_FIELD) SELECT ‘FIELDS_TO_INSERT_MUST_BE_TELE_WITH_INSERT_FIELD’ FROM ‘DB_NAME’.’TABLE_NAME’ WHERE (CONDITION);
echo-ing json into array in terminal
echo ‘json_array’ | python -mjson.tool
Mysql root password change
1.Stop mysql service 2.then run this command mysqld_safe –skip-grant-tables & 3.mysql -u root 4.Run Below Command:- use mysql; update user set password=PASSWORD(“mynewpassword”) where User=’root’; flush privileges; quit 5.stop start mysql service and you’re good to go 🙂 Reference Link : https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords
Print Ram unit (byte) linux command
for i in $(seq 1 38); do echo “2^$i” | bc; done | more EX: 536870912 = 512MB bc is a terminal calculator
Master slave mysql configuration
https://www.stephenrlang.com/2016/08/setting-up-mysql-master-slave-replication-with-xtrabackup/