Fixing a Broken MySQL Windows Service

Fixing a Broken MySQL Windows Service

MySQL is an open source database system used by many of today’s popular products including WordPress, Facebook, and Google.  This post outlines how to fix a broken (refuses to start, stuck starting) MySQL Windows Service: Kill the MySQL process Launch Task Manager Under Processes, right click on the MySql process and select End Process Delete the InnoDB engine files located in the MySql/Data installation folder: ib_logfile0 ib_logfile1 ibdata1 Start the MySQL Windows service If t...

Read the full article

Enabling Post Series in WordPress

Enabling Post Series in WordPress

A post series is a collection of articles about a specific topic. Typically on each post, there will be some indicator that this article is part of a series with a linked listing to the other posts in the series. An post series example is a series called “Summer Movie Reviews” that contain “Inception”, “Toy Story 3″, and “Despicable Me” posts. A post series provides a great way to organize articles for you readers. Unfortunately, WordPress does...

Read the full article

Backing up a MySQL Database

Backing up a MySQL Database

Shows how to backup a MySQL database from the command line. WARNING: Restoring from this backup will cause any existing database with the given name to be deleted prior to the restore. mysqldump.exe --add-drop-database --databases -uYOURLOGINNAME -pYOURLOGINPASSWORD YOURDATABASENAME > YOURBACKUPNAME.sql

Read the full article

Creating a SQL Login (for a Windows Login or Group)

Creating a SQL Login (for a Windows Login or Group)

Creates a SQL login for a given Windows user login or group name. ::Requires OSQL (Installed with SQL Client Tools) CALL :ExecSQLQuery "ServerName" "" "" "MASTER" "EXEC sp_grantlogin 'DOMAINNAME\DomainObject" GOTO:EOF ExecSQLQuery SETLOCAL ENABLEEXTENSIONS Set OutFile=%RANDOM%.txt Set SQL=SET NOCOUNT ON %5 ::Remove quotes Set SQL=%SQL:"=% Set Server=%1 IF %Server%=="" Set Server="(local)" IF NOT %2==...

Read the full article

Playing an Audio File

Playing an Audio File

Plays a given audio file. ;Here, filename is the full path and file name of the audio file to play ;and wait is either 1 to wait for the audio file to finish playing before ;the script continues or 0 to immediately continue the script. SoundPlay("filename", wait)

Read the full article