Host wendy \tHostName 192.168.20.22 \tUser myname \tIdentityFile ~/.ssh/keyidfile \tIdentitiesOnly yes #for tailscale Host wendy-tailscale \tHostName 1.1.1.1 \tUser myname \tIdentityFile ~/.ssh/keyfile IdentitiesOnly yes\""},{"logid":1642,"ns":0,"title":"Scripts to backup to synology without mounting drives","pageid":483,"logpage":483,"params":{},"type":"create","action":"create","user":"Bacchas","timestamp":"2026-04-24T17:51:55Z","comment":"Created page with \"
#!/bin/bash # Use absolute paths for everything RSYNC_BIN=\"/usr/bin/rsync\" MKDIR_BIN=\"/bin/mkdir\" fdate=`date -I` fname=\"wendy_karaoke.txt\" LOG_FILE=\"$HOME/Desktop/cronlogfiles/logs/$fname\" # Create log directory if missing mkdir -p \"$HOME/Desktop/cronlogfiles/logs\" # Log Header { echo \" \" echo \"***********************************************************\" echo \" \" echo \"------ $(date) --------\" echo \" \" } >> \"$LOG_FILE\" # THE FIX: # 1. Changed '-avi'...\""},{"logid":1641,"ns":0,"title":"Backup script on mac config and setup","pageid":482,"logpage":482,"params":{},"type":"create","action":"create","user":"Bacchas","timestamp":"2026-04-24T17:50:28Z","comment":"Created page with \"=[[ Setup Mac for ssh into synology ]]= =[[Scripts to backup to synology without mounting drives]]=\""},{"logid":1640,"ns":0,"title":"PYTHONAPP","pageid":481,"logpage":481,"params":{},"type":"create","action":"create","user":"Bacchas","timestamp":"2026-04-21T16:58:41Z","comment":"Created page with \" pip install flask pymysql cryptography gunicorn DBUtils\""},{"logid":1639,"ns":0,"title":"Python Environment Setup","pageid":480,"logpage":480,"params":{},"type":"create","action":"create","user":"Bacchas","timestamp":"2026-01-05T15:47:35Z","comment":"Created page with \"==Create the Environment with a Unique Name== *Instead of the generic .venv, give your Windows environment a name that clearly identifies it. In your project's root terminal, run: python -m venv .venv_pc *This creates a new folder named .venv_pc in your project. Your existing Mac folder (e.g., .venv or .venv_mac) will remain completely untouched.\""},{"logid":1638,"ns":0,"title":".PS1 To .exe","pageid":479,"logpage":479,"params":{},"type":"create","action":"create","user":"Bacchas","timestamp":"2025-12-02T19:05:11Z","comment":"Created page with \"==Converting a PowerShell script (.ps1) to an executable (.exe) can be achieved using tools like PS2EXE or IExpress.==\""},{"logid":1637,"ns":0,"title":"Convert .Py to .exe","pageid":478,"logpage":478,"params":{},"type":"create","action":"create","user":"Bacchas","timestamp":"2025-12-02T16:42:01Z","comment":"Created page with \"#Converting a Python script (.py) to an executable (.exe) file for Windows can be achieved using tools like PyInstaller\""},{"logid":1636,"ns":0,"title":"MYSQL DATABASE BACKUP","pageid":477,"logpage":477,"params":{},"type":"create","action":"create","user":"Bacchas","timestamp":"2025-10-07T14:26:04Z","comment":"Created page with \"==Mysql Backup and Restore == ===List Databases=== '''Login to server ''' mysql ''' List databases''' show databases; '''List Tables in a database''' use databasename show tables; ===Bakcup a single database=== done from bash - no need to log in to mysql mysqldump -u root -ppassword sugarcrm > sugarcrm.sq syntax mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
===Backup a single table=== mysqldump -u root -ppassword dat...\""},{"logid":1635,"ns":0,"title":"MYSQL DATABASE RESTORE","pageid":476,"logpage":476,"params":{},"type":"create","action":"create","user":"Bacchas","timestamp":"2025-10-07T14:17:50Z","comment":"Created page with \"==Restore Database== I used this to restore r512 from the dumped .sql file in 2025
I tried to restore it using phpmyadmin, but it did not work, got many errors. probably because it was a raw sql dump backup. The target database must already exist. if it doesn't, create it first
* log into mysql CREATE DATABASE your_database_name; mysq...\""},{"logid":1634,"ns":0,"title":"APPSHEET","pageid":475,"logpage":475,"params":{},"type":"create","action":"create","user":"Bacchas","timestamp":"2025-10-06T14:58:20Z","comment":"Created page with \"== Fix permission error when connecting to a mysql database == '''On the mysql server, loginto mysql then run command''' ALTER USER 'bacchas'@'%' IDENTIFIED WITH mysql_native_password BY 'Outwater24!'; FLUSH PRIVILEGES;\""}]}}