Geeky Nuggets

Access to MySQL import class

July 18, 2009 | 0 Minutes Read

In my latest project at work I need to import data from an Access database into mySQL to be able to create an online shop from that data. Instead of importing just the database of that particular client, I created a generic PHP class that can import any Access database to MySQL.

Big databases must be imported by chunks.

Since Access databases can get so big, the import class has to do its job by chunks, to avoid memory limits. It also needs to reload itself when it detects it is close to the time limit, all of which it now does without any problems. We can now import (hopefully) any Access database.

Older posts

  • July 10, 2009

    Ecoquotidien.fr

    July 10, 2009 | 0 Minutes Read

    A new project

  • June 27, 2009

    WP-Feedly theme available for download

    June 27, 2009 | 0 Minutes Read

    After some beta testing and subsequent bug squashing, WP-Feedly is ready for prime-time, and available for download.

  • June 27, 2009

    New portfolio theme: CleanFolio

    June 27, 2009 | 0 Minutes Read

    New portfolio Wordpress theme

  • June 16, 2009

    Post sorting plugin

    June 16, 2009 | 1 Minutes Read

    UPDATE : A post sort plugin already exists, take a look at this one.You’ve probably noticed that there is no option to sort posts any other way than by date in Wordpress. I’ve had several requests to be able to sort post from the oldest to the newest, which Wordpress cannot do with a simple one button option.I think I can hear the critics already ;) : “What, but that is sacrilegious! It’s not a blog anymore then!” but maybe these users do not want a blog per se, but only an easy to maintain, ...

  • June 13, 2009

    Beta testers wanted

    June 13, 2009 | 1 Minutes Read

    The Feedly-like theme for Wordpress has reached the beta stages. I would like to do a limited round of testing before releasing this theme. Feedly changes so quickly that I’m having trouble keeping up! Only today, I noticed they added the date in a little box on the left hand side, I must admit it’s quite useful to see at a glance when the posts were published. I implemented it straight away on WP-feedly, of course!Below is a video showing how window size changes are handled, using adaptive C...