millipedia millipedia

millipedia create resources for organisations in the not-for profit, arts and education sectors.

millipedia / fix_mangled_mysql

Last active February 2, 2017 09:51

Fix mangled chars in MySQL DB. Original info here http://jonisalonen.com/2010/mysql-character-encoding/

	//general case is:

	update table set column = convert(binary column using utf8);

	// if we've just moved a cmsms db then this is a good start
	// but you'll have to do any module specific bits.

	update cms_content_props set content = convert(binary content using utf8);
	update cms_htmlblobs set html = convert(binary html using utf8);
	update cms_module_news set news_data = convert(binary news_data using utf8);

millipedia / adb_screenshot

Last active December 19, 2015 12:39

Grab an android screenshot from adb and save to local computer. Originally came from http://stackoverflow.com/a/14353315

adb shell screencap -p | sed 's/\r$//' > screen.png

millipedia / gist:5755827

Last active December 18, 2015 08:39

Use dig to look up name servers being used by a list of domains.

cat domainlist.txt | xargs -izzz -n 1 sh -c "echo \"Domain: \" zzz; dig zzz ns +short; echo"