/*
 *  database setup, use etc
 *
 */

/********************/
/* MariaDB login */
mysql -u root
mariadb -u root

/********************/
/* import db with SOURCE com*/
MariaDB [ngorano_traders]>

SOURCE /data/data/com.termux/files/home/storage/shared/zangu/MyAppsProjects/ngorano_traders_20250524/ngorano_traders_data/ngorano_biz_initial_db.sql

SOURCE /data/data/com.termux/files/home/storage/shared/zangu/MyAppsProjects/ngorano_traders_20250524/ngorano_traders_data/ngorano_biz_initial_db_all_null_varchar.sql

SOURCE /data/data/com.termux/files/home/storage/shared/zangu/MyAppsProjects/ngorano_traders_20250524/ngorano_traders_data/ngorano_biz_db.sql

SOURCE /data/data/com.termux/files/home/storage/shared/zangu/MyAppsProjects/ngorano_traders_20250524/ngorano_traders_data/tx_types_table.sql

SOURCE /data/data/com.termux/files/home/storage/shared/zangu/myApps/ngorano_biz_20250716/ngorano_biz_data/ngorano_biz.sql

SOURCE /data/data/com.termux/files/home/storage/shared/zangu/myApps/ngorano_biz_20251104/ngorano_biz_data/ngorano_biz.sql

/********************/
/* access directory */
cd /data/data/com.termux/files/home/storage/shared/zangu/MyAppsProjects/ngorano_traders_data

cd /data/data/com.termux/files/home/storage/shared/zangu/myApps/ngorano_biz_20250703

/********************/
/* mysqldump */
mariadb-dump -u root ngorano_traders > /data/data/com.termux/files/home/storage/shared/zangu/MyAppsProjects/ngorano_biz_20250524/ngorano_biz_data/ngorano_biz_db.sql

mariadb-dump -u root ngorano_traders > /data/data/com.termux/files/home/storage/shared/zangu/myApps/ngorano_biz_20250703/ngorano_biz_data/ngorano_biz.sql