Marcos omarcosr

Have you ever stuck in a condition where you have to restore your mysql database from only an *.frm and *.ibd files? I have.

So what happen is somehow our mysql service is going down and can not be restarted. I try many things to no avail and getting tired of it.

And then I came across this page https://dev.mysql.com/doc/mysql-enterprise-backup/3.11/en/partial.restoring.single.html. I think probably I can just copy the *.frm and *.ibd file, wipe the current mysql data, reset the mysql, and restore those two files. Easy.

So I stupidly remove /var/lib/mysql/[schema_name], and also /var/lib/mysql/ib* file. Restart the mysql, and it start normally. Finally!

How to update the Go version

System: Debian/Ubuntu/Fedora. Might work for others as well.

As mentioned here, to update a go version you will first need to uninstall the original version.

To uninstall, delete the /usr/local/go directory by:

	const puppeteer = require("puppeteer-core"); // v13.0.0 or later
	const path = require("path");

	(async () => {
	const browser = await puppeteer.launch({
	executablePath:
	"C:\\Program Files\\Google\\Chrome\\Application\\chrome.exe",
	});
	const page = await browser.newPage();
	const timeout = 5000;

	let seen = new Set()

	async function getBioLink(row) {
	try {
	const { signature, uniqueId } = row
	const secUid = row.secUid
	const url = `https://us.tiktok.com/api/user/detail/?aid=1988&app_language=en&app_name=tiktok_web&battery_info=1&browser_language=en-US&browser_name=Mozilla&browser_online=true&browser_platform=MacIntel&browser_version=5.0%20%28Macintosh%3B%20Intel%20Mac%20OS%20X%2010_15_7%29%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%29%20Chrome%2F105.0.0.0%20Safari%2F537.36&channel=tiktok_web&cookie_enabled=true&device_id=7137341942917350955&device_platform=web_pc&focus_state=true&from_page=user&history_len=2&is_fullscreen=false&is_page_visible=true&language=en&os=mac&priority_region=US&referer=&region=US&screen_height=1440&screen_width=2560&secUid=${secUid}&tz_name=America%2FNew_York&uniqueId=${uniqueId}&webcast_language=en&msToken=J9m3_eBf4GKuBDGa063BDCsjVBzMBmcFqJvEGf0M62WHW9yPzXAHzcFhc8-X5-DLAkVoNH7CKKi-Jkp1Kb7ua75MV6btEfjcZPAbhZJKirSwPlP_CTcRrSMHocUTnU4=&X-Bogus=DFSz

	#!/bin/bash

	curl https://www.cloudflare.com/ips-v4 > .ips-v4
	curl https://www.cloudflare.com/ips-v6 > .ips-v6

	firewall-cmd --new-zone=cloudflare --permanent
	firewall-cmd --reload

	for i in `<.ips-v4`; do firewall-cmd --zone=cloudflare --add-source=$i; done
	for i in `<.ips-v6`; do firewall-cmd --zone=cloudflare --add-source=$i; done

	#!/bin/bash

	PREFIX="$1"
	IFACE="$2"

	ip netns add jool
	ip link add name to_jool typ veth peer name to_world
	ip link set up dev to_jool
	ip link set dev to_world netns jool
	ip netns exec jool ip link set up dev to_world

	func main() {
	cmd := exec.Command("sh", "-c", "cd ../../bin/worker; ./run.sh")
	// some command output will be input into stderr
	// e.g.
	// cmd := exec.Command("../../bin/master_build")
	// stderr, err := cmd.StderrPipe()
	stdout, err := cmd.StdoutPipe()
	if err != nil {
	fmt.Println(err)
	}