Monthly Archives: December 2014
Dec 30 2014 New Release
Sometimes it feels like a constant struggle, but not always if you have faith on your side.
Here, There and Everywhere
Just finishing up with Geoff Emerick’s book – it is a great read for Beatles fans. I never realized that he worked on another favorite album of mine, Imperial Bedroom by Elvis Costello.
Duplicating a mysql database
Here is a simple way to duplicate a database from the command line of a windows server:
1.Create the target database using MySQLAdmin or your preferred method. In this example, db2 is the target database, where the source database db1 will be copied.
2.Execute the following statement on a command line:
mysqldump -h [server] -u [user] -p[password] db1 | mysql -h [server] -u [user] -p[password] db2
Note: There is NO space between -p and [password]
If you do not want to add the password on the command line, you can leave that blank and you will be prompted for it.
Session Drummer 3 is not being recognized by SONAR X3
The information in this article applies to:
SONAR X3 (all versions)
We have received reports from some customers that Session Drummer 3 does not show up in their version of SONAR X3 despite being installed successfully from the installer. Some customers have also reported that it shows up but results in a “Failed to Insert Soft Synth” message when attempting to insert it into SONAR.
If you are experiencing this issue, Session Drummer 3 has dependencies that may be missing from your computer. This version of Session Drummer 3 relies on components distributed with the Microsoft Visual C++ Redistributable for Visual Studio 2012 Update 4. This update can be obtained from the link below:
http://www.microsoft.com/en-us/download/details.aspx?id=30679
If you are running into this issue, please download and install this update with SONAR closed. Once this update has finished, open up SONAR and perform a VST Scan by doing the following:
1.Within SONAR, Navigate to Edit > Preferences > VST Settings
2.Click the “Scan” button to perform a VST Scan
3.Click Apply and Close to close the Preferences window once complete.
4.At this point you should be able to create a project and insert Session Drummer 3 successfully from Insert > Soft Synths
Note: if SONAR is set to run an Automatic Background VST Scan, you do not have to manually run a VST Scan upon opening SONAR X3.
Little Hope, No Good Change
6 years later – same old crap.
Black Bars on the Side of the content on my monitor
Sometimes when I plug in an HDMI to my laptop to use my regular desktop monitor, I get two black bars squeezing the content down. The way to fix it is to Roll back the driver. At least it works for me. This is a ‘note to self’ to remind me when it happens again, but maybe it will help you to.
Lies and Consequences New Mix
I’m gathering material for a video, but for now here is the latest mix.
Lies and Consequences
Nerdy Joke
Q: What did God do before he created the Universe?
A: He was busy preparing Hell for the people who ask such questions.
To find duplicates in a mysql field
Do a SELECT with a GROUP BY clause. Let’s say name is the column you want to find duplicates in:
SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;This will return a result with the name value in the first column, and a count of how many times that value appears in the second.