Using lzop on Windows

I wanted a fast way to backup an AppDynamics MySQL database directory on windows. The answer was lzop. Tools GoW 0.8.0 (GNU on Windows) lzop for Windows Setup Set your Enviornment PATH After installing GoW and extracting lzop.exe set your environment PATH to include the directory where you extracted lzop.exe Stop AppDynamics Controller and Database... » read more

php mysql update variable

Goal: Update wordpress post with PHP cli < ?php $con = mysql_connect("localhost","root","[redacted]"); if (!$con) { echo "Unable to connect to DB: " . mysql_error(); exit; } if (!mysql_select_db("wordpress")) { echo "Unable to select mydbname: " . mysql_error(); exit; } $myfileText = mysql_real_escape_string(file_get_contents('./code_for_wordpress.html',true)); $sql = "UPDATE `[your_instance_prefix]_posts` SET `post_content` = '$myfileText' WHERE `ID` like '1397';"; $result... » read more

howto move mysql freebsd without dump

to move mysql on freebsd without using a dump file follow these steps: stop mysql copy /var/db/mysql to its new location chown -R mysql:mysql modify /etc/rc.conf and add line mysql_dbdir=”“ modify /usr/local/etc/rc.d/mysql-server and change mysql_dbdir=”/var/db/mysql” to the new location of your mysql directory Start up mysql:  /usr/local/etc/rc.d/mysql-server start

useful active directory scripts

Scripts to manage Active Directory Users Appending a Multi-Valued Attribute Appending a Phone Number Adding a Route to the Dial-In Properties of a User Account Adding a User to Two Security Groups Appending Address Page Information for a User Account Appending a Home Phone Number to a User Account Assigning a Published Certificate to a... » read more

Red Hat Linux cheat sheet commands examples RHEL

Useful Linux Commands (Red Hat) (http://www.cse.buffalo.edu/~eisner/DLW) Revised 3/1/2000 Getting information man commandname display the manual page for a particular command named commandname man -S sectionnumber commandname display the manual page under a specific section numbered sectionnumber for the command named commandname. Sometimes the same command will exist in more than one section. man alone will... » read more

Howto: Backup your Bitnami Stack’s MySQL DB

Below I will explain how to take nightly backups of your MySQL database Download and Install: MYSQL GUI Tools 7zip Windows Server 2003 Resource Kit Tools to obtain robocopy After you install the tools bring up a command prompt and run these commands to copy robocopy to our working folder (1BACKUP_MYSQL): cd \ cd ..... » read more

Howto: Fix a Slow Bitnami Redmine Stack

Problem: Redmine is running super slow. Version: Bitnami Redmine Stack on Windows The Fix 1. Run MySQL System Tray Monitor (accessible from either of these methods): Start menu – MySql – MySQL System Tray Monitor “C:\Program Files\MySQL\MySQL Tools for 5.0\MySQLSystemTrayMonitor.exe” 2. Right click on system tray icon and from the popup menu select Actions -&gt;... » read more