Long, long ago I hacked together a Java app that imports the freedb CD info files from my local drive to an MS Access database. The CD ripper application I use creates a local freedb with a file for each CD I rip (all of them). So importing from that freedb to a database seemed a natural thing to do.
Access was all that I had access (heh) to, and it had a “music collection” database template, so with slight modification to the template that’s what I used.
Well now, I no longer have access (heh) to Access, Access is a PITA, and I already have MySQL available on my home server, so I figured it was time to finally migrate.
I found a handy application called Navicat (fully functional trial), that will import directly from the Access .MDB file to a MySQL database.
While Navicat mostly worked, I was not quite done. The import did not properly get the auto_increment attribute on the tables’ ‘id’ column. Also, the Access database tables had spaces in their names which is kind of a drag. Fortunately both were easily solved by exporting from MySQL to text using mysqldump, editing the .sql file that resulted, and then reimporting to MySQL from the .sql file.
Sure it’s a ridiculous thing nobody in their right mind will ever have to do, but I’m not in my right mind.
