Database Administration
MySQL, SQL Server, Oracle, SQLite and recovery notes · 21 notes
GetModNest reference library
Technical Archive
Archived guides for databases, web deployment, AI environments, game servers and developer tooling. These notes are retained as reference material while the main site focuses on B2B export acquisition through SEO, GEO and paid ads.
Explore the Archive
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 Archived Articles
Database Administration
Migrate MySQL Database from CentOS to Ubuntu
A practical MySQL 8.0 database migration case from CentOS Docker to Ubuntu, covering mysqldump export, scp transfer, character set validation, and import verification.
Database Administration
MySQL Production Deployment with Replication and VIP Failover on Linux
A practical MySQL 8.0 production deployment case on Linux, covering binary installation, my.cnf configuration, primary-replica replication, Keepalived VIP failover, and mysqldump backup restore.
Database Administration
SQL Server Database Synchronization with Transactional Replication
A practical SQL Server 2022 cross-network database synchronization case using transactional replication and push subscription, covering Publisher, Distributor, Subscriber setup, agent configuration, and validation.
AI & Deep Learning
Build an Enterprise WeChat AI Bot with Dify and Docker
A practical Enterprise WeChat AI Bot deployment workflow using Dify, Docker Compose, Flask callback service, Nginx reverse proxy, Dify API integration, and knowledge base answers on Linux.
AI & Deep Learning
Deploying DeerFlow 2.0 Enhanced Locally on Windows with DeepSeek, Tavily, Docker, RAG, Tools, and Sandbox
Overview This article documents a Windows local deployment process for DeerFlow 2.0 Enhanced. The goal was to run DeerFlow locally with Docker, configure an LLM provider, enable web…
AI & Deep Learning
Installing and Configuring OpenClaw on Windows with Kimi API and Feishu Bot Integration
Overview This article documents a practical setup process for installing OpenClaw on Windows and integrating it with Kimi / Moonshot AI and a Feishu bot. The setup involved…
Developer Environment
Building a Java JDBC MySQL Study Plan Manager with Maven and DAO-Based CRUD
Overview This article documents a small Java project that connects to a MySQL database through JDBC and implements basic CRUD operations for a study plan manager. The goal…
Developer Environment
Setting Up a Windows 11 Local Development Database Environment with MySQL, MongoDB, and Redis
Overview This article documents a Windows 11 local development database setup involving MySQL, MongoDB, and Redis. The goal was to prepare the database environment required by a development…
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…