InnoDB the “case-sensitive monster”

Posted in Programming, Server Administration, webdesign on June 4th, 2010 by Ole
No Gravatar

Hello,

this posting is about InnoDB’s limitation of lower / upper cases and the resulting problems of
InnoDB database migrations to different operating systems.

THE TASK:

Import an InnoDB database from Mac OS  MySQL  5.x to Linux MySQL 5.x (in our case Rhel 5 ).

No big deal, I thought.

Made a mysql dump and imported the dump to Linux.   5 minutes work, just the way  admins love it ! ;-)

THE CHALLENGE:

Imported the dump. I am done! That’s what I thought. Just let’s check the app that accesses the freshly imported DB.

Running the app brought me exceptions. Some tables couldn’t be found… URGH! Checked the tables… everything was fine. The dump was fine… the tables were present. WTF!!!!!

THE SOLUTION:

After 10 hours of pain, we found the solution.

MySQL and especially the storage engine InnoDB depends on the case sensitivity of the operating system. Windows and Mac OS (by default) are not case-sensitive.  So if you are importing a Mac or Win DB-dump to a case-sensitive operating system (like Linux), the DB will be handled case sensitively, although the dump is not a case-sensitive one. I think this problem should be fixed. I know fixing this problem is nearly impossible because the OS has to be capable of doing this. But giving some sort of warning while importing a non-case-sensitive DB to a case-sensitive DB-Server… that can’t be so difficult !

How to fix our specific problem:

Add the following line to your MySQL Server Config:

lower_case_table_names=1

By default Windows MySQL uses lower_case_table_names=0 and MacOS MySQL lower_case_table_names=2

The MySQL documentation advises setting lower_case_table_names=1 for InnoDB. For more information, please read the MySQL documentation.

Popularity: 18% [?]

  • Share/Bookmark
Tags: , , ,

Company Website Online

Posted in Blog, Company, webdesign on June 17th, 2009 by Matthias
No Gravatar

Hi there,

our company website is online since yesterday.  More improvement and updates to the website will follow. This blog will get an overhaul as well, in the upcoming weeks .

Cheers,

Matthias

Popularity: 13% [?]

  • Share/Bookmark

Placing DIVs over Flash-Objects

Posted in Tips, webdesign on December 29th, 2008 by Joerg
No Gravatar

During my attempts to get into the deepest voodoo magic known to man, sometimes referred to as “webdesign”, I stumbled over another problem which took me some time to find the answer to. But since I recently played Professor Layton for the DS and immediately fell in love with it, I don’t mind wracking my brains about a riddle now and then… So my problem was to display a DIV element OVER an existing flash-object.

The first hits on google told me that this is impossible, since the flash-object has no z-index and hence the z-indexing for elements does not work here.

After some more google-usage, I found out that you can tell your flash-object to be “transparent”. You do this by adding the parameter “wmode” and giving it the value of “transparent”. You’ll also have to add wmode=”transparent” to your embed tag. And voila, it worked for me! I haven’t tested it on mac browsers, but as soon as I’ll have I’ll tell you.

So the whole code looks like this:

<div id="flash">
<object border="0" width="802" height="766" id="YOUR_ID_HERE">
<param name="movie" value="myswf.swf">
<param name="allowScriptAccess" value="always">
<param name="wmode" value="transparent">
<embed src="myswf.swf" width="802" height="766" name="YOUR_ID_HERE" wmode="transparent">
</embed>
</object>
</div>

As you can see, I used a unique DIV that holds the flash-object. This DIV has a lower z-index than the DIV that is shown over the flash-object. As I told you, the z-indexing does not work in this case. I just added it for the sake of completeness.

Popularity: 3% [?]

  • Share/Bookmark
Tags: , , ,

Make your blog individual

Posted in Blog, Tips, webdesign on November 26th, 2008 by Joerg
No Gravatar

Nowadays, nearly every website that needs some information-updating now and then is done using a so-called “content management system”.

Blogging software can be seen as a special sub-category type of cms. The software we use to manage our blog is called WordPress. And since you know that individuality is important for most people, there are many different themes available for WordPress to give your blog an individual and/or personal touch. I must admit that we are using a standard theme for the moment, but this may change soon…

If you have ever wanted to create your own WordPress Theme then this is your lucky day. Be sure to check out these nifty tutorials.
You’ll only need some very very basic html and php knowledge to understand them! Even I managed it. Maybe you will see the effects of my efforts soon :)

Popularity: 4% [?]

  • Share/Bookmark
Tags: ,