The CodeKits notebook
Ideas into working code.
Practical tutorials, project walkthroughs and development notes. Explore the code, understand the structure, and build something of your own.
3 articles · Newest first
MySQL
Move a MySQL app, uploads and keys to a new VPS
Move a MySQL-backed app safely with a stopped-writer backup, private uploads, preserved encryption keys, empty-target restore and cutover checks.
· 6 min read
MySQL
Create a MySQL app user and test backup restores
Create a restricted MySQL application account, take a consistent table backup and verify it by restoring into a separate test database.
· 4 min read
MySQL
Add date filters and pagination to MySQL
Build predictable MySQL date filters with UTC boundaries, a stable cursor and indexes, then test duplicate timestamps and page boundaries.
· 4 min read