AgungPambudi

#!/bin/bash
#title           : cron_backup.sh
#description     : bash script to backup list cronjob (Linux).
#author          : Agung Pambudi
#website         : http://agungpambudi.com
#email           : [email protected]
#version         : 0.1
#==============================================================================
#
#                                   _         _ _

AgungPambudi

#!/bin/bash
#title           : autoremove_ftp_file.sh
#description     : bash script to remove file from FTP.
#author          : Agung Pambudi
#website         : http://agungpambudi.com
#email           : [email protected]
#version         : 0.1
#requirement     : apt-get install ncftp
#==============================================================================
#

AgungPambudi

#!/bin/bash
#title           : mysql_kill_process_based_on_ips.sh
#description     : bash script to kill process "SELECT & Sleep" at processlist in MySQL.
#author          : Agung Pambudi
#website         : http://agungpambudi.com
#email           : [email protected]
#version         : 0.2
#==============================================================================
#
#                                   _         _ _

AgungPambudi

REM   by Agung Pambudi
REM   [email protected]
REM   http://agungpambudi.com
REM                                    _         _ _
REM  ___ ___ _ _ ___ ___ ___ ___ _____l l_ _ _ _l l_l  ___ ___ _____
REM l .'l . l l l   l . l . l .'l     l . l l l . l l_l  _l . l     l
REM l__,l_  l___l_l_l_  l  _l__,l_l_l_l___l___l___l_l_l___l___l_l_l_l
REM     l___l       l___l_l
REM
REM Batch file to convert character set to latin1 in MySQL Table

AgungPambudi

<?php
	/* 
	| title           : upload_files_filtering_to_ftp.php
	| description     : php script to upload files from local to ftp.
	| author          : Agung Pambudi
	| website         : http://agungpambudi.com
	| email           : [email protected]
	| format args 	  : "17-12-23"
	|          	                     _         _ _
	|  ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____

AgungPambudi

@echo off
REM  title           : backup_restore_ms_sql.bat
REM  description     : batch file to backup and restore microsoft sql server.
REM  author          : Agung Pambudi
REM  website         : http://agungpambudi.com
REM  email           : [email protected]
REM  requirement     : MS SQL 2005
REM     	 	                           _         _ _
REM  ___ ___ _ _ ___ ___ ___ ___ _____I I_ _ _ _I I_I  ___ ___ _____
REM I .'I . I I I   I . I . I .'I     I . I I I . I I_I  _I . I     I

AgungPambudi

#	title           : mysql_select_query_to_view_certain_condition_using_sum_if_distinct_concat.sql
#	description     : select query to view certain condition
# author          : Agung Pambudi
# website         : http://agungpambudi.com
#	email           : [email protected]
# requirement 	: MySQL / Maria DB
# 			                         _         _ _
#  ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____
# | .'| . | | |   | . | . | .'|     | . | | | . | |_|  _| . |     |
# |__,|_  |___|_|_|_  |  _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|

AgungPambudi

<?php
	/* 
	|	title           : for_logic_to_looping_table_name_and_strore_in_array.php
	|	description     : php script for logic to looping tablenames and store in array.
	| author          : Agung Pambudi
	| website         : http://agungpambudi.com
	|	email           : [email protected]
	| 	    		                         _         _ _
	|  ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____
	| | .'| . | | |   | . | . | .'|     | . | | | . | |_|  _| . |     |

AgungPambudi

<?php 
	/* 
	|	title           : mysqldump_list_using_array.php
	|	description     : php script to get the lists of mysqldump on windows or mac/linux.
	| author          : Agung Pambudi
	| website         : http://agungpambudi.com
	|	email           : [email protected]
	| source          : https://www.php.net/manual/en/index.php, https://www.php.net/manual/en/function.array-merge.php
	| 			                         _         _ _
	|  ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____

AgungPambudi

#	title           : mysql_batch_insert.sql
#	description     : INSERT SELECT query with DUPLICATE KEY UPDATE
# author          : Agung Pambudi
# website         : http://agungpambudi.com
#	email           : [email protected]
# requirement 	  : MySQL / Maria DB
# alternative     : REPLACE query in MySQL
# 			                         _         _ _
#  ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____
# | .'| . | | |   | . | . | .'|     | . | | | . | |_|  _| . |     |