Thursday 21 August 2014

Slide Shows of Events

Vanaf vandaag voeg ik dia-voorstellingen van evenementen en thema's aan mijn 'Fotoshop' webpagina toe. Ik zal ook panorama's en films bijvoegen als ik die heb gemaakt.

De eerste voorstelling toont foto's van de auto-rodeo in Wilp-Achterhoek.
De tweede voorstelling gaat over het Tractor Pulling evenement in Ameland.

- - - - - - - - - -

As of today I am adding slide shows of events and themes to my 'Fotoshop' web page. I shall also include panoramas and movies if I made them.

The first slide show is of a car rodeo in Wilp-Achterhoek.
The second show is about Tractor Pulling at Ameland.

Saturday 16 August 2014

Foto's uit militaire dienst van 1981 bij mijn OYPO webshop

Het werd weer tijd om mijn OYPO webshop uit te breiden. De toegevoegde foto's zijn gemaakt tijdens mijn militaire diensttijd in 1981, toen ik ook nog aan modelbouw deed.

1981_Militaire-Dienst_Hollandsche_Rading_Stormbaan_2_01a-Over-hindernist 1981_Militaire-Dienst_Seedorf_Modelbouw_05-M10-Tank-Destroyer-and-M3-Half-Trackt
1981_Militaire-Dienst_Seedorf_Rode_Kruiskamp_13-Rode-Kruis-kamp-uit-boomt 1981_Militaire-Dienst_Seedorf_Oefentanks_Sherman-tank-02t

Thursday 14 August 2014

Wireless network connections in hotels and on the road

If you ever try to be smart and add some hi-speed DNS servers to your WiFi DNS settings ... don't. I thought I was and the last months I have been wondering why I couldn't connect to wireless LANs in hotels and trains - and they didn't know either.

Today, at Hotel BB (good hotel btw) they put me in contact with their WiFi-provider and after a going through every detail, we found the reason: my manual DNS entries. Why did I put them there? Well, at home I sometimes use NameBench to find the best DNS-servers. And since Google's DNS servers are mostly the fastest, I thought it a good thing to add those two (8.8.8.8 and 4.4.4.4) permanently to the DNS of my WiFi connection! Which then blocked and confused the routers in the hotels I was staying or the trains on which I travelled. And I thought what a shitty stuf do these guys have... hum hum ;-)

So.... I created a separate location for when I am mobile and I called it Mobile (DHCP). I leave it totally empty so routers in hotels and trains can discuss with my Macbook Pro what is the best connection and which DNS-servers to use. Here's how in images:

1-network-prefs
 
2-edit-locations
 
3-add-location
 
4-turn-wifi-on
 
5-connect
 
and click Apply when the Mac asks you to!

Now, whenever I go out and take my MacBook Pro with me, I first choose this Mobile (DHCP) location so whatever WiFi-router I connect to, I have a good chance for internet access.
 

Wednesday 13 August 2014

E-Mail to Evernote

I fixed some other flaws in my version of the Send E-Mail to Evernote.scpt:

Update 13 aug 2014:
- I repaired a situation where there is no content-type found in the email headers. I now set it to text/plain in such a case.

Update 5 aug 2014:
- I repaired the strange time formatting (1=3=4=5 instead of 1345) when adding multiple email messages at once.
- And I added a dialog when the script has successfully finished processing for when Growl is not active.

See also my previous posts.
 

Friday 8 August 2014

Quickly transfer MySQL databases to a new server

Again I needed to transfer all data from one server to another. I knew I documented the transfer of MySQL databases somewhere (it's deep inside in the Replication-how-to) and decided to post them again here, so they're quicker to find.

One can transfer MySQL databases in various ways:
  1. Using mysqldump and zip + ftp
  2. Zip the database itself + ftp (you might need to repair the tables after unzipping)
  3. Use Navicat's Data Transfer module (not always good for tables with millions of records or blob data)
Personally, I prefer to use option 2, like below, in Terminal or an SSH session:

$ cd /var/mysql/ (or /var/lib/mysql/)
$ sudo zip -r ~/[database].zip [database]

Do this for each database that you want to copy. Then send all zip's per FTP to the new server.
Start an SSH session with the remote server and enter the following commands:

$ cd /var/mysql (or /var/lib/mysql/)
$ sudo unzip ~/[database].zip
$ sudo chown -R _mysql:admin [database]

For the above chown, check first with ls -l if _mysql:admin are the right owners. Then do this for each unzipped database.

Next, start Navicat and now you should see your databases in the connection of the new server. If not, you probably forgot to either do a Refresh Connection or the chown-command.

If you can access the tables and view data, good! If not, right click the table and choose Maintain->Repair Table->Quick or ->Extended and then try again.