Copy MySQL Database Structure without Data

Three easy steps to copy the structure of a MySQL database, i.e. the table definitions but no rows/records/data: 1. Create the new database, either from MySQL Query Browser (part of MySQL GUI Tools) or MySQL Command Line: CREATE DATABASE `new_database_name`; 2. Copy the database structure using the mysqldump command from a dos command prompt. Note:… Continue reading Copy MySQL Database Structure without Data

Published
Categorized as MySQL

Mobile internet in Thailand

I am currently in Thailand for three months with my family 🙂We’re at the island of Koh Lanta which is in southern Thailand, close to Krabi and Puket (Phuket). I’m trying to work from here but getting a decent internet connection has been a hassle. Internet is generally very cheap (compared to Sweden anyway) but… Continue reading Mobile internet in Thailand

BC30560: ‘MySqlConnection’ is ambiguous in the namespace ‘MySql.Data.MySqlClient’.

I got this error in one of my ASP.NET web sites after uploading a new version: BC30560: ‘MySqlConnection’ is ambiguous in the namespace ‘MySql.Data.MySqlClient’. It worked fine on my development machine but not on the production server. I could not figure out what it was for quite some time. Turned out I had added the… Continue reading BC30560: ‘MySqlConnection’ is ambiguous in the namespace ‘MySql.Data.MySqlClient’.

Lotus Notes data directory on Windows Vista

Just installed and old CD with Lotus Notes 7.02 on my Windows Vista laptop.Could not find notes.ini, names.nsf in the file system, apparently it’s no longer stored in C:\Program Files\Lotus\Notes\Data. After some searching I found it here: C:\Users\[UserName]\AppData\Local\VirtualStore\Program Files\lotus\notes\data>

Convert Accented Characters to ASCII

It is pretty simple in .NET to convert Western Unicode (non-ASCII, accented, diacritics) to ASCII, but regardless I had a hard time figuring it out it so I’m posting here for my own future reference. [code lang=”vb”] Dim strTest as String = "Any string containing accented characters, e.g. åäöéèêÅÄÖÉÈÊ" strTest = System.Text.Encoding.ASCII.GetString(System.Text.Encoding.GetEncoding(1251).GetBytes(strTest)) [/code]

Published
Categorized as VB.NET

Looking for Credential Tiles hangs Remote Desktop

On my new Acer TravelMate 5530G I run Windows Vista Home Premium. I use Windows Remote Desktop Connection (RDC) to connect to my server which has been working just fine. But this weekend after setting up a new Windows 2008 server and trying to connect to it, RDC shows a dialog “Looking for Credential Tiles”.… Continue reading Looking for Credential Tiles hangs Remote Desktop

Copy Outlook Signatures

I just got a new laptop running Vista so I wanted to backup and transfer all my Outlook signatures from my old XP laptop. Both are running Outlook 2007. Outlook 2007 Signature file locations in Windows Vista and XP: Vista: %USERPROFILE%\AppData\Roaming\Microsoft\Signatures (usually C:\Users\\AppData\Roaming\Microsoft\Signatures) XP: %USERPROFILE%\Application Data\Microsoft\Signatures(C:\Documents and Settings\\Application Data\Microsoft\Signatures) From that directory, just copy everything… Continue reading Copy Outlook Signatures