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.

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.

 

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.

New Element Discovered

A major research institution has just announced the discovery of the densest element yet known to science. The new element has been named Pelosium. The chemical symbol of Pelosium is Pu. Pelosium has one neutron, 12 assistant neutrons, 75 deputy neutrons, and 224 assistant deputy neutrons, giving it an atomic mass of 311. These particles are held together by dark particles called morons, which are surrounded by vast quantities of lepton-like particles called peons.

Pelosium’s mass actually increases over time, as morons randomly interact with various elements in the atmosphere and become assistant deputy neutrons within the Pelosium molecule, leading to the formation of isodopes. This characteristic of moron-promotion leads some scientist to believe that Pelosium is formed whenever morons reach a certain quantity in concentration. This hypothetical quantity is referred to as Critical Morass.

When catalyzed with money, Pelosium activates MSNBCobnoxium and CNNadnausium, both elements that radiate orders of magnitude more energy, albeit as incoherent noise, since they have half as many peons but twice as many morons as Pelosium.

Since it has no electrons, Pelosium is inert. However, it can be detected chemically as it impedes every reaction it comes in contact with. According to the discoverers, a minute amount of Pelosium causes one reaction to take over four days to complete when it would have normally occurred in less than a second. In the presense of anti-morons, Pelosium can be extremely corrosive. Botox seems to distort and smooth it’s surface, without impeding it’s ongoing decay.

Pelosium has a normal half-life of approximately two years, at which time it does not decay, but instead undergoes a transmutation, appearing in a new location but displaying the same properties. In this process, assistant neutrons, vice neutrons and assistant vice neutrons exchange places. Some studies have shown that the atomic mass actually increases after each transmutation.

Research at other laboratories indicates that Pelosium occurs naturally in the atmosphere. It tends to concentrate at certain points such as government agencies, large corporations, universities, and anywhere there is news coverage occurring. It can usually be found in the newest, best appointed, and best maintained buildings.

Scientists point out that Pelosium is known to be toxic at any level of concentration and can easily destroy any productive reaction where it is allowed to accumulate. Attempts are being made to determine how Pelosium can be controlled to prevent irreversible damage, but results to date are not promising.