Rename WP DB Prefix

Wanted to change wp database prefix on a couple of sites following importing data with WP Migrate DB Pro. First delete the initial tables: Then rename the imported ones Now update entries in user_options table: Lastly update entries in user_meta table:

Cleaning Up an old WP Database

Come across this old post. Install the WP-DBManager plugin by Lester Chan Check last time table was used: Compile a list, on the staging server, first of tables that we don’t seem to still be using: Thank you SO for one liner to remove woocommerce tables

Free Purgable Space

Found a good little article on clearing up “purgable space” on OSX Drive. One drives which will unmount there is this useful command: diskutil secureErase freespace 0 / Supposedly after running this command and restarting the computer, the purgable space will have been purged. I ended up not being registered in Disc Doctor right away … Continued

2019 Google SMPT Interaction

To enable a third party app to use a google account’s SMPT credentials to send mail: Use these settings: Gmail SMTP server address: Gmail SMTP username: Your Gmail address (for example, Gmail SMTP password: Your Gmail password Gmail SMTP port (TLS): 587 Gmail SMTP port (SSL): 465 Gmail SMTP TLS/SSL required: Yes May … Continued

Google Webfont Tools

Google Webfonts Helper is great. It generates the CSS and also downloads and generates various versions of the font for you. This command line and api option, Google Font Installer is also pretty cool. You can even install it on your computer.

Valet+ 500 Error Bricked PHP, pecl extension troubles apcu, apc

Starts with a 500 nginx error, three days ago, when settling down to do a quick update to a wordpress theme. What have I learned or clarified so far? Valet is a lightweight Mac development environment for Laravel, which is a php framework based on the model–view–controller application approach. Valet+ is a fork of Valet … Continued

Ripping Encrypted DVDs

Client wants his DVD published to his video streaming website. First I worked for a while with effmpeg, but kept getting errors. ffmpeg -i concat:VIDEO_TS.VOB\|VTS_01_0.VOB\|VTS_01_1.VOB -vcodec libxvid -q:v 5 -s 640×480 -aspect 640:480 -r 30 -g 300 -bf 2 -acodec libmp3lame -ab 160k -ar 32000 -async 32000 -ac 2 ~/Documents/Clients/Client/test.mp4 [ac3 @ 0x7fae3c027400] exponent 25 … Continued

sshfs requires libfuse.2.dylib error with iExplorer

iExplorer is a great app with which I can load my iPhone as an external disc. It was crashing after OSX upgrade with following issue: sshfs requires libfuse.2.dylib error with iExplorer. I was able to solve it by installing osxfuse. With homebrew: brew cask install osxfuse