morocco
in search for some February sunshine i’ve spent 11 days in Morocco.
Month: February 2012
extracting single database from a [large] mysqldump or pg_dump
MySQL: extracting the whole database: sed -n '/^-- Current Database: `databaseName`/,/^-- Current Database: `/p' /path/to/the/fill/dump.sql > output.sql single table: sed -n '/^CREATE TABLE `tableName`/,/^\-\- Table structure for table /p' /path/to/the/fill/dump.sql > output.sql [via this blog] PostgreSQL: pv dump.sql | perl -ne 'print if /^COPY public.name_of_the_table/ .. /^\\\.$/' > out.sql [ via https://stackoverflow.com/a/62289905 ]
aspies
few articles about mild form of autism: Jeff Atwood – Software Developers and Asperger’s Syndrome Tracy Mayor/computerworld – Asperger’s and IT: Dark secret or open secret? sounds familiar?
cloning the server using rsync
braindump of things to do/directories not to copy when cloning physical debian to a vm using rsync