Schlagwort: replace

Android: Amazon Fire TV replace App Starter

If you have a Amazon Fire TV Stick and you was touched by the „forced“ Firmware Update from 5.2.1.2 to later. You will see now a full blown Advertisement Screen on Start which plays Advertisements Videos on Scroll down Button (Ads Video Autostart with Tone) The „New Amazon Bloatware“ Menu: Appstarter CLEAN Menu: Howto: Connect the Fire TV Stick to the TV and boot the Stick Check Wifi Go to Stick System Settings, check out IP Address of the Stick 192.168.XXX.XXX Enable ADB Development Access at System Settings of the Stick, need some search Enable ADB Install (Siteload) at the […]

WordPress: Change Word on all content sites with mysql

If you run a WordPress Blog or other CMS with MySQL Backend you can easy change one same word or expression on all content sites on the fly Do a mysqldump at first of the current database $ mysqldump -u username -p dbname > dbbackup.sql Login to the MySQL server Console Switch to the Database mysql> use dbname; run command for tests, lists touched posts mysql> SELECT * FROM wp_posts WHERE (post_content LIKE '%expression%'); Run Replace code to pre, cause i use preformat text plugin for the copy & paste boxes mysql> UPDATE wp_posts SET post_content = REPLACE ( post_content, […]