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: Using lzop on Windows

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: php mysql update variable

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

Red Hat Linux cheat sheet commands examples RHEL

Useful Linux Commands (Red Hat)

( 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: Red Hat Linux cheat sheet commands examples RHEL

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: Backup your Bitnami Stack’s MySQL DB

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: Howto: Fix a Slow Bitnami Redmine Stack