.::: DBLink MariaDB Manipulation with Shell Scipt to insert table from Server A to Server B :::.

 

A. sample source server A server B sample 

1. record source & destination

=== source ===
ip       : 10.10.10.90
porr     : 3306
database : dbatools
table    : dbsizeos

=== destination ==
ip       : 10.10.10.9
porr     : 3306
database : dbatools
table    : list_dbsizeos
 

.::: Script insert database size & record to table base on size folder in OS Linux example MariaDB :::.

 

correlation https://teguhth.blogspot.com/2025/12/script-check-size-database-base-on-size.html

A. Using basic table info

1. create table

CREATE TABLE IF NOT EXISTS dbsizeos (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    capture_time DATETIME DEFAULT CURRENT_TIMESTAMP,
    db_name VARCHAR(100) NOT NULL,
    size_bytes BIGINT NOT NULL,
    size_mb DECIMAL(12,2) NOT NULL  
);

2.script 

.::: Create Script Backup All Database Full, Differential & Log Using T-SQL & Run using CMD SQL Server - Basic Update :::.

 
correlation https://teguhth.blogspot.com/2023/08/create-script-backup-database-full.html

1. enable xp_cmdshell

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'xp_cmdshell', 1;
RECONFIGURE;
    
2. create t-sql sp_backup_full_basic

IF DB_ID('dbatools') IS NULL
BEGIN
    CREATE DATABASE [dbatools];
END
GO

USE [dbatools];
GO

CREATE PROCEDURE [dbo].[sp_backup_full_basic]

-- =============================================  
-- Author: Teguh Triharto
-- Create date:  22 March 2000
-- Description: Script Backup Database
-- Website : https://www.linkedin.com/in/teguhth"
-- =============================================  
 

.::: Script check size database base on size folder in OS Linux example database size MariaDB :::.

  

ini shell script sederhana, rapi, dan standar DBA untuk list folder di /var/lib/mysql + hitung size-nya.

1. Versi Paling Simpel (langsung pakai du) semual folder n non folder 
[root@teguhth sizex]# cat cek_foldernisi.sh
#!/bin/bash

BASE_DIR="/var/lib/mysql"

echo "Database Directory Size Report"
echo "=============================="
printf "%-25s %10s\n" "FOLDER" "SIZE"
echo "------------------------------"

du -sh ${BASE_DIR}/* 2>/dev/null | sort -h | while read size folder; do
    printf "%-25s %10s\n" "$(basename "$folder")" "$size"
done

echo "------------------------------"
echo "TOTAL:"
du -sh "$BASE_DIR" | awk '{print $1}'

[root@teguhth sizex]#
 

.::: Simulation API HEAD Using Phyton & MariaDB MySQL with HTTP Status Code 200,404 :::.

 

1. Install phyton

sudo dnf install python3 python3-pip -y
pip3 install flask mysql-connector-python

2. create database sample & insert data  

CREATE DATABASE hris;
USE hris;

CREATE TABLE buy_period (
    id INT AUTO_INCREMENT PRIMARY KEY,
    period_year INT NOT NULL,
    period_month INT NOT NULL,
    start_date DATE NOT NULL,
    end_date DATE NOT NULL
);

.::: Simulation API DELETE Using Phyton & MariaDB MySQL with HTTP Status Code 500, 422, 200, 405 :::.

  

1. Install phyton

sudo dnf install python3 python3-pip -y
pip3 install flask mysql-connector-python

2. create database sample & insert data  

CREATE DATABASE hris;
USE hris;

CREATE TABLE buy_period (
    id INT AUTO_INCREMENT PRIMARY KEY,
    period_year INT NOT NULL,
    period_month INT NOT NULL,
    start_date DATE NOT NULL,
    end_date DATE NOT NULL
);
 INSERT INTO buy_period (period_year, period_month, start_date, end_date)
VALUES (2025, 1, '2025-01-01', '2025-01-31');

INSERT INTO buy_period (period_year, period_month, start_date, end_date)
VALUES (2025, 5, '2025-05-01', '2025-05-31');

.::: Create alert using API Bot Telegram to group & subtopic :::.

 

correlation to https://teguhth.blogspot.com/2025/12/create-alert-using-api-bot-telegram-to.html

1. add bot group to new group with message privilegde
 
2. run chat sample to username bot 
 

3. get message with id group (record group id chat)

https://api.telegram.org/bot8537695777:AAF6qO3Hm3l695Mw0CpvuIJtQppexF2jAW8/getUpdates

or 

curl -s https://api.telegram.org/bot8537695777:AAF6qO3Hm3l695Mw0CpvuIJtQppexF2jAW8/getUpdates

.::: Create alert using API Bot Telegram to private / username bot :::.

 

Berikut panduan cara membuat alert/notification ke Telegram dari server atau aplikasi Anda. Saya jelaskan cara paling umum dan paling mudah: mengirim pesan ke Telegram via Bot API.

1. Buat Bot Telegram (via BotFather) example bot 'teguhth' usernamebot 'teguhth_alert_bot'

Buka Telegram.
Cari BotFather.

Ketik:

/start
/newbot
 

.::: Simulation create view with additional ID Unique row_number(),hash /md5 & Primary Key in Oracle :::.

 

1. Buat Tabel dengan tanggal_lahir
CREATE TABLE karyawan (
    emp_id NUMBER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    nama VARCHAR2(100),
    jabatan VARCHAR2(100),
    lokasi VARCHAR2(100),
    tanggal_lahir DATE
);

2. Insert Data Sample (dengan tanggal lahir)

.::: Troubleshoot oracle PLS-00306: wrong number or types of arguments in call to 'SPBUY' PL/SQL: Statement ignored :::.

Dari gambar error tersebut terlihat jelas penyebabnya:

procedure spbuy(integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer) does not exist

Artinya: FUNCTION atau Stored Procedure spbuy (atau sptaxsample) membutuhkan 15 parameter, tapi saat dipanggil hanya diberikan 14 parameter.

. Tujuan Anda

Anda ingin mensimulasikan kasus tersebut pada database sample oracle dengan database contoh bernama hris.

Saya buatkan contoh struktur database, fungsi, dan pemanggilan yang benar & salah, sehingga error yang sama bisa direplikasi.

. SIMULASI DI oracle: Database hris

1. Buat Database Sample

 

.::: Troubleshoot PostgreSQL procedure spbuy(integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer) does not exist :::.

 

Dari gambar error tersebut terlihat jelas penyebabnya:

procedure spbuy(integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer) does not exist

Artinya: FUNCTION atau Stored Procedure spbuy (atau sptaxsample) membutuhkan 15 parameter, tapi saat dipanggil hanya diberikan 14 parameter.

. Tujuan Anda

Anda ingin mensimulasikan kasus tersebut pada database sample PostgreSQL dengan database contoh bernama hris.
 

.::: Simulation create view with additional ID Unique row_number(),hash /md5 & Primary Key in PostgreSQL EDB :::.

1. Buat Tabel dengan tanggal_lahir
CREATE TABLE karyawan (
    emp_id SERIAL PRIMARY KEY,
    nama VARCHAR(100),
    jabatan VARCHAR(100),
    lokasi VARCHAR(100),
    tanggal_lahir DATE
);

2. Insert Data Sample (dengan tanggal lahir)

.::: Troubleshoot MSSQL SQL Server Procedure or function 'spbuy' expects parameter '@p14', which was not supplied :::.

  

Dari gambar error tersebut terlihat jelas penyebabnya:

Incorrect number of arguments for FUNCTION ... expected 15, got 14

Artinya: FUNCTION atau Stored Procedure spbuy (atau sptaxsample) membutuhkan 15 parameter, tapi saat dipanggil hanya diberikan 14 parameter.

. Tujuan Anda

Anda ingin mensimulasikan kasus tersebut pada database sample SQL Server dengan database contoh bernama hris.