.pQd’s log

in search for some February sunshine i’ve spent 11 days in Morocco.
Continue reading ‘morocco’ »

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 `MyTable`/,/^DROP TABLE /p' test.sql

[via this blog]

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?

braindump of things to do/directories not to copy when cloning physical debian to a vm using rsync
Continue reading ‘cloning the server using rsync’ »