WordPress development site

I use this script to search and replace the domain name in the WordPress database to adjust a fresh copy from the production site.
Replaces every occurence of ‘www.domainname.tld’ and ‘domainname.tld’ with ‘dev.domainname.tld’.
You then access the development site by adding it to your ‘hosts’ file or internal DNS.


#!/bin/sh
echo File: $1 Replace: $2
cp $1 $1.bak
perl -p -i -e "s|www\.$2|dev\.$2|g" $1
perl -p -i -e "s|://$2|://dev\.$2|g" $1

FreeBSD 11 installation notes

Base install

Ports, first time
portsnap fetch
portsnap extract

Ports, updating
portsnap fetch
portsnap update

Checking installed packages against ports
Using portupgrade, (“pkg install portupgrade” first)
portversion -v
Updating, using ports binaries or source
portupgrade -vaP

Cleanup of /var/db/pkg/

Apache HTTPd

Default document root
/usr/local/www/apache24/data
Configuration location
/usr/local/etc/apache24/

MySQL

Configuration file: /usr/local/etc/mysql/my.cnf
Datadir: /var/db/mysql
Initial MySQL root password in $HOME/.mysql_secret

To change password for root
root@localhost [(none)]> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this
root@localhost [(none)]>
root@localhost [(none)]> alter user ‘root@localhost’ IDENTIFIED BY ‘new_password’;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
root@localhost [(none)]> set password = ‘new_password’;
Query OK, 0 rows affected (0.02 sec)

PHP

Configuration location
/usr/local/etc/
/usr/local/etc/php/

Prepare
pkg install png-1.6.29
pkg install jpeg
pkg install libxml2
pkg install libltdl
pkg install gmake
pkg install freetype2
pkg install curl

Install PHP and modules
pkg install php71
pkg install php71-imap
pkg install php71-mcrypt
pkg install php71-curl
pkg install php71-ctype
pkg install php71-dom
pkg install php71-fileinfo
pkg install php71-filter
pkg install php71-gd
pkg install php71-hash
pkg install php71-iconv
pkg install php71-json
pkg install php71-mysql
pkg install php71-mysqli
pkg install php71-openssl
pkg install php71-pcntl
pkg install php71-session
pkg install php71-simplexml
pkg install php71-tokenizer
pkg install php71-xml
pkg install php71-zlib

Install Apache module
pkg install mod_php71

ffmpeg / youtube-dl

Creating video or audio clips using ffmpeg

ffmpeg clip audio interval with starting and end time

Cut part from video file from start position to end position with FFmpeg

Using ffmpeg to cut up video

Convert video format without re-encoding
ffmpeg -i input.m2ts -c:v copy -c:a aac -strict experimental -b:a 128k output.mp4

Replacing audio in a video

Replacing video audio using ffmpeg

Create a single image video (for audio clips uploaded to Youtube)

Combine one image + one audio file to make one video using FFmpeg

youtube-dl

youtube-dl is a python script that allows you to download and view videos from different platforms for archiving and offline viewing
downloading videos to a specific path with youtube-dl
How to download only subtitles of videos using youtube-dl
Change youtube-dl download output location

Windows 10 (swedish)

Uppdateringshistorik för Windows 10 (1703)

https://support.microsoft.com/sv-se/help/4018124/windows-10-update-history

Uppdateringshistorik för Windows 10 (1607)

https://support.microsoft.com/sv-se/help/4000825

wmic

https://superuser.com/questions/447277/list-all-installed-software-on-pc
https://community.spiceworks.com/how_to/111076-using-wmic-to-retrieve-a-list-of-all-installed-programs
https://social.msdn.microsoft.com/Forums/vstudio/en-US/a9beeed3-99f0-4627-ba1e-aa0161fa58c9/wmic-invalid-xsl-format-or-file-name?forum=windowsgeneraldevelopmentissues

Lista alla installerade program, html
wmic /output:Installed.htm product get /format:”%WINDIR%\system32\wbem\en-US\hform”

Lista alla installerade program, csv
wmic /output:Installed.csv product get /format:”%WINDIR%\system32\wbem\en-US\csv”

VirtualBox – convert RAW image to VDI and otherwise

Cloned from: https://blog.sleeplessbeastie.eu/2012/04/29/virtualbox-convert-raw-image-to-vdi-and-otherwise/

VirtualBox – convert RAW image to VDI and otherwise

VirtualBox command-line interface (VBoxManage) provides an easy way to convert raw disk image to the VDI/VMDK format and otherwise.

Let’s assume that we have raw image of the sdb device:

sudo dd if=/dev/sdb of=./sdb.raw

To use it with VirtualBox we need to convert it to the VDI format:

VBoxManage convertdd sdb.raw sdb.vdi --format VDI

To use it with VMware we need to convert it to the VMDK format:

VBoxManage convertdd sdb.raw sdb.vmdk --format VMDK

Convert between VDI/VMDK formats:

VBoxManage clonehd sdb.vdi sdb.vmdk --format VMDK
VBoxManage clonehd sdb.vmdk sdb.vdi --format VDI

Convert to the RAW image:

VBoxManage clonehd sdb.vdi sdb.raw --format RAW

Alternative solution to get back raw image after applying modifications is to use qemu-img command from qemu package:

qemu-img convert -f vmdk sdb.vmdk -O raw sdb.raw

Now we can write image to the device:

sudo dd if=./sdb.raw of=/dev/sdb