Island in the Net

Inner join updates

October 30, 2009November 28, 2008 by feign

Here is how to do update of a table that needs to be joined with another table in MySQL, Oracle and SqlServer. Let’s say we want to give a 20% raise to sales department. Microsoft SQL Server: ORACLE: Be careful here to have a primary key set on Department.DepID. Otherwise you get an error ORA-01779 … Read more

MySQL – Full database backup & restore

October 30, 2009November 27, 2008 by feign

Mysql has it pretty simple when it comes to database backup. Using mysqldump tool you can create an sql dump of one, more or all databases on your server. What it does, is writes SQL scripts for every object inside a database (DML, grants, data inserts etc.). Database restore (or cloning) is then done by … Read more

Few discoveries

May 9, 2007 by feign

I was wrong. The Negliahn pod wasn’t broken, it was out of power. As it appears, they are solar-powered and i arrived there in the middle of the night. Peyiferen is the same, at night it would show few seconds of life and then shutdown due to lack of power. Dereno however doesn’t have that … Read more

Negilahn out of order?

May 7, 2007April 24, 2007 by feign

This morning i woke up a bit early and decided to visit the pod ages and take a few pictures of the outside. First one i went to was Negilahn, as jungle it should have largest spectrum of life dwelling there (in contrary to the desert of Payiferen or ice wasteland of Dereno). But to my suprise, few seconds after hitting the main power switch everything had shut down. So tried switched it on again for a few times but it just would not stay online for more than 10 seconds. Day before yesterday everything was working fine. Did something happen in the meantime? There is a pretty large crack in the roof of the pod (see the pictures below) making it open to the outside. All kinds of bizzare animals that live here could have entered it and mess with the controls. Or it could just be the morning (or evening, i was too tired to calculate what time it is there) moisture that made the power act wierd.

That’s one more that goes against DRC. It’s not as bad as Tetsonot but they sould have closed the crack before allowing explorers to visit. Or at least put a safty net to keep the animals out.

Here are the pictures i took these days:

Portals, activists and trivia

April 24, 2007April 23, 2007 by feign

Yesterday was really interesting. I entered the portals located in the pods for the first time (one in Negliahn and one in Tetsonot wich only recently became public). Negliahn is located in a heavy jungle and swamp area with all different kinds of vegetation. Seems hard to spot all the animals through the windows. The … Read more