[SOLVED] XAMPP Row size too large, innoDB sql import

Ran into some problems recently with XAMPP. Exported a large mySQL production database and tried to import it locally in XAMPP (through Shell access).

Error: ERROR 1118 <42000> at line 437919: Row size too large <> 8126>. Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

First I tried changing table to ROW_FORMAT=COMPRESSED doing so:

ALTER TABLE <tablename>

No success with that. Then I changed innodb_buffer_pool_size to 32MB (default setting was 8 or 16) in my.ini (mySQL config file in XAMPP)

xampp control panel

# Comment the following if you are using InnoDB tables
innodb_data_home_dir = "/Sites/xampp-portable-win32-1.8.3-5-VC11/mysql/data"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "/Sites/xampp-portable-win32-1.8.3-5-VC11/mysql/data"
#innodb_log_arch_dir = "/Sites/xampp-portable-win32-1.8.3-5-VC11/mysql/data"
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 32M
innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 10M
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_file_per_table = 1
innodb_file_format = Barracuda

Doing so made it possible to import a 1GB sql table without any problem.

The above applies to XAMPP portable version xampp-portable-win32-5.5.19-0-VC11.zip


Winamp 5.666 change media library location

One of my previous posts guided you to the process of moving your library location from drive X to drive Y with the aid of a HEX-editor. This was tested for Winamp version 5.61. It was a rather complex approach, since iTunes XML import did not work in that version.

I have tested this again with Winamp version 5.666 and XML export/import works perfectly.

  • Make a backup copy of  your Winamp profile (c:\Users\<USERNAME>\AppData\Roaming\Winamp\*)
  • Open Winamp
  • Remove everything from your current playlist
  • On the media library tab, click local library
  • Click Library button and export media database

Open the generated XML file, and with a program like notepad++, you can find & replace the <key>location</key> values to the new location. Save the file

  • Reopen Winamp
  • Remove everything in your library
  • Close and reopen Winamp
  • On the library button, choose import media database and point to the new XML file you created

That’s it!


PHP UTF8 test-template (jQuery, Bootstrap)

This is just a webdevelopment template for PHP (all errors, xdebug), HTML, jQuery, Bootstrap (UTF8 encoding).

ini_set('display_errors' , 'On');
ini_set('xdebug.var_display_max_depth', -1);
ini_set('xdebug.var_display_max_children', -1);
ini_set('xdebug.var_display_max_data', -1);
<!doctype html>
<meta charset="utf-8">
<script src="//code.jquery.com/jquery-1.11.2.min.js"></script>
<script src="//code.jquery.com/jquery-migrate-1.2.1.min.js"></script>
<link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css" rel="stylesheet">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>



30 tips voor de dodentocht

Volg me op Twitter @JanVerkoyen en krijg de laatste dagen voor de start van de dodentocht nog 30 tips mee.

Jammergenoeg kan ik er zelf niet bij zijn dit jaar, maar ik hoop dat mijn ervaringen jou te hulp kunnen schieten. Veel succes!

Mijn twee uitgebreide verslagen van succesvolle tochten vind je in 2008 en 2009, maar ook die van 2007 waar ik vlak voor 50km op een domme manier opgaf.

Move your music library from Winamp to iTunes

In a previous post I helped you to switch your music library from iTunes to Winamp, without losing any metadata (such as last play date, play count, rating…). Now Winamp has stopped releasing new versions, some might want to switch back sooner or later. I’ve made the switch as a kind of experiment to see whether it would be possible to keep (the most valuable metadata). iTunes won’t be able to please me in the near future, but as time goes by, it might be the only easy way to sync with my old iPod Classic and iPad.

What do you need?

Winamp 5.666 (media library required, standard Winamp installation)
– Your favorite txt notepad software with find/replace features (Notepad++, GVim, …)

It will please you to hear that moving the library back to iTunes is less complicated than the reverse option.


Start up Winamp

Winamp export media database

The default view has a button called ‘library’ at the bottom of the left column (media library column). Click, and choose ‘export media database’. This will create an iTunes XML library database.

Start up your favorite txt editor

Open the XML file created by Winamp in the previous step. Replace F below with the drive letter on your system. Find:


Replace with


(so the only thing that needs replacement is %5 to /)

Save and close XML file

Start up iTunes

iTunes import XML database from Winamp

File (Alt + F) > Library > Import playlist… Choose the XML file

If you have lots of media files, this will take some time.

Record audio and video with VLC

Step by step tutorial on how to record audio and video with VLC. This will enable you to make a screencast without special software. This has been tested with VLC 2.0.8 and VLC 2.1.3.

Required to record audio/video

  • http://www.videohelp.com/download/UScreenCapture2015.zip (http://www.videohelp.com/tools/UScreenCapture)
  • http://sourceforge.net/projects/screencapturer/files/


  • VLC > View > Advanced Controls
  • VLC > View > Status Bar
  • CTRL+C (open capture device)
  • Screen capture record (video device)
  • Virtual audio capture (audio device)
  • If applicable: go to advanced settings and change 4:3 into, 16:9. You can change the default 4:3 aspecto ratio:

    change default picture aspect ratio in vlc
    If you want to set the default picture-aspect ratio n:m to 16:9, go to advanced preferences (CTRL+P), show all settings, Input / codecs > DirectShow > Picture aspect ratio n:m, and change 4:3 to 16:9.
  • Next to play button, click arrow and choose “convert”
  • Choose a destination filename, e.g. test.mp4
  • Start recording…



Step by step tutorial adapted from:

VLC stuck in a loop? Kill process seems like the only solution?

Video image freezes, audio rewinds 3 to 4 seconds and gets stuck in a loop.
A similar problem has been documented here: https://trac.videolan.org/vlc/ticket/6600.
Unfortunately there seems to be no solution. It even happens in recent VLC distributions, like VLC Rincewind 2.1.3.

I have tried using Windows Media Player Classic (MPC), without any effect. At random intervals, with any kind of video format, video playback stops.

Quite out of the blue I found this behaviour tracing back to Intel Optimus Technology. I have two video cards: HD Graphics 4600 and NVIDIA Quadro K2100M controlled by Optimus. Optimus technology switches between these two GPU’s to ensure maximum battery autonomy.

When disabling Optimus in your BIOS settings, the video problem should belong to the past. This, however, isn’t an optimal solution when you rely on Optimus to get maximum battery autonomy. At this time, with the latest BIOS and Graphic drivers video playback keeps freezing with Optimus enabled. Hopefully, a driver update will fix this in the near future.

Feedback appreciated

Van Google Bookmarks naar Chrome Bookmarks

Heb je in het verleden ook steeds gebruik gemaakt van Google Bookmarks en je je altijd beklaagd dat deze niet gesynchroniseerd worden met Google Chrome en ver te zoeken zijn op je mobiele toestellen waar je ook Chrome gebruikt?

Simpel! Gebruik alleen nog Chrome Bookmarks en gooi je Google Bookmarks de deur uit, samen met de bijhorende Bookmarklet knop.
Je originele Google Bookmarks verhuis je gewoon naar Google Chrome.