Database Administration
MySQL, SQL Server, Oracle, SQLite and recovery notes · 21 notes
Practical Tech & Game Server Notes for Real-World Projects
Hands-on notes for databases, web deployment, AI environments, Minecraft servers, game backend services, and developer workflows.
Explore by Topic
Web App Deployment
Flask, Java Web, Spring Boot, Vue and server setup · 2 notes
AI & Deep Learning
PyTorch, computer vision, LLMs and model environments · 7 notes
Developer Environment
Windows, Linux, macOS, Docker, VS Code and Java tooling · 5 notes
Game Server Development
Minecraft servers, plugins, mods, GTA V FiveM and game backend services · 2 notes
Latest Project Notes
Developer Environment
Running SQL Server on Linux with Docker and Connecting from Python via ODBC
Overview This article documents a practical setup for running SQL Server on Linux with Docker and connecting to it from Python through Microsoft ODBC Driver and pyodbc. The…
Database Administration
Troubleshooting SQL Server Express Remote Connection and Login Failures
Overview This article documents a troubleshooting case for SQL Server Express remote connection and login failures. The environment involved SQL Server Express, SQL Server Management Studio, a C#…
Database Administration
Troubleshooting MariaDB 10.2 Startup and Table Access Errors Caused by Data Directory Permissions
Overview This article documents a troubleshooting case for a MariaDB 10.2 instance installed under a custom path on Linux. The database service had startup and access problems. One…
Database Administration
Troubleshooting Oracle Listener Connection Errors on Windows Server 2008 R2 and Fixing SERVICE_NAME
Overview This article documents a troubleshooting case for Oracle listener connection errors on Windows Server 2008 R2. The environment involved Oracle 9i, PL/SQL Developer, and a BSEAP 5.0…
Database Administration
Importing an Oracle 11g Dump File with Data Pump and Fixing Directory and File Path Errors
Overview This article documents a practical Oracle Database 11g import case on Windows. The goal was to import a database dump file named YONBIPV3-1028.DMP into a local Oracle…
Database Administration
Troubleshooting a DBeaver SQL Syntax Error Near UNION When Querying SAP Tables
Troubleshooting a DBeaver SQL Syntax Error Near UNION When Querying SAP Tables Overview This article documents a troubleshooting case where a SQL query against SAP-related tables failed in…
Database Administration
MySQL InnoDB Data Recovery for Missing Tablespace Error
A practical MySQL InnoDB data recovery case involving ERROR 1812 missing tablespace, a deleted .ibd file, Ubuntu data directory checks, filesystem recovery attempts, and backup recommendations.
Database Administration
Troubleshooting MySQL 5.7 Startup Failure on CentOS Caused by performance_schema and mysqld_pre_systemd
Overview This article documents a real-world troubleshooting case where MySQL 5.7 on CentOS failed to start correctly through systemd. The investigation covered several layers: service status, performance_schema system…
Database Administration
Configuring MySQL 8.0 on Windows for LAN Remote Access
Overview This article documents the process of configuring MySQL 8.0 on Windows 10 so that it can accept remote connections from other machines on the same local network.…
Database Administration
Troubleshooting MySQL 8.0 Service Startup on Windows and Fixing datadir Path Errors
Overview This article documents the process of moving a MySQL 8.0 installation to a new directory on Windows, resolving service startup failures related to incorrect datadir paths, and…