kaiserama

Restore MySQL from Amazon S3

This is a hands-on way to pull down a set of MySQL dumps from Amazon S3 and restore your database with it

Sister Document - Backup MySQL to Amazon S3 - read that first

1 - Set your MySQL password and S3 bucket, make a temp dir, get a list of snapshots

# Set our variables

export mysqlpass="ROOTPASSWORD"

FWIW: I (@rondy) am not the creator of the content shared here, which is an excerpt from Edmond Lau's book. I simply copied and pasted it from another location and saved it as a personal note, before it gained popularity on news.ycombinator.com. Unfortunately, I cannot recall the exact origin of the original source, nor was I able to find the author's name, so I am can't provide the appropriate credits.

Effective Engineer - Notes

By Edmond Lau
Highly Recommended 👍
http://www.theeffectiveengineer.com/

What's an Effective Engineer?

Wolfram Ravenwolf on X: "I'm now using Qwen3-Coder in Claude Code. Works with any model actually, but this is surely the best one currently. There are a bunch of proxies on GitHub that make this possible, but none worked well enough for me, so I implemented this myself using LiteLLM. Guide in comments: https://t.co/Wqbv75nxlp" / X
HOWTO: Use Qwen3-Coder (or any other LLM) with Claude Code (via LiteLLM) : r/LocalLLaMA

Here's a simple way for Claude Code users to switch from the costly Claude models to the newly released SOTA open-source/weights coding model, Qwen3-Coder, via OpenRouter using LiteLLM on your local machine.

This process is quite universal and can be easily adapted to suit your needs. Feel free to explore other models (including local ones) as well as different providers and coding agents.

I'm sharing what works for me. This gu

	*.pyc
	AWS-ElasticBeanstalk-CLI*
	bin/
	lib/
	man/
	src/
	include/
	debug.sqlite

	import mimerender

	mimerender.register_mime('pdf', ('application/pdf',))
	mimerender = mimerender.FlaskMimeRender(global_charset='UTF-8')

	def render_pdf(html):
	from xhtml2pdf import pisa
	from cStringIO import StringIO
	pdf = StringIO()
	pisa.CreatePDF(StringIO(html.encode('utf-8')), pdf)

	<!doctype html>

	<html lang="en">
	<head>
	<meta charset="utf-8">

	<title>Title</title>
	<meta name="description" content="The HTML5 Herald">
	<meta name="author" content="SitePoint">

	@font-face {
	font-family: 'ABeeZee';
	font-style: normal;
	font-weight: 400;
	src: local('ABeeZee'), local('ABeeZee-Regular'), url(http://fonts.gstatic.com/s/abeezee/v9/JYPhMn-3Xw-JGuyB-fEdNA.ttf) format('truetype');
	}
	@font-face {
	font-family: 'Abel';
	font-style: normal;
	font-weight: 400;

	# Project Policy

	This policy provides a single, authoritative, and machine-readable source of truth for AI coding agents and humans, ensuring that all work is governed by clear, unambiguous rules and workflows. It aims to eliminate ambiguity, reduce supervision needs, and facilitate automation while maintaining accountability and compliance with best practices.

	# 1. Introduction

	> Rationale: Sets the context, actors, and compliance requirements for the policy, ensuring all participants understand their roles and responsibilities.

	## 1.1 Actors

	#!/bin/bash
	export WANDB_API_KEY=<your key>
	export WANDB_PROJECT=<org/project>

	litellm --port 4000 --debug --config cc-proxy.yaml