Framework, or not; was: Re: What's a site like this one worth?

Sean Corfield wrote: > I agree with Dave here. Learning a framework while you're trying to > crank out your first site in several years will just slow you down. A goal for the next site I build is for it to be a template for future sites. I'd like to be able to create another brochure site with re-coding limited to displaying new user's content as much as possible. The website/web applications I've built in the past, they were all start-from-scratch one off projects. Doing that this time feels like a step backwards. > Do this project, then re-learn Fusebox, then learn > some CFC stuff, then learn Transfer ORM. Also, the client hasn't responded to my query for more info, so I have some time to learn a framework before starting this project. In the interim, I'd like to create a photo gallery site that will become a stock image library. Also, a photography site I created a while ago needs a re-skin. >> Mysql will be fine and it's a snap to learn. Ok. First thing I'll be looking for is a way to migrate the data in the old Access databases to MySQL. Thank you! * JB *

>Ok. First thing I'll be looking for is a way to migrate the data in the >old Access databases to MySQL. have fun with that! navicat will do it on windows but not mac & the biggest issue you will have is the auto-inc field, generally the others are fine. If you can export the access db to sql, tab or csv it can be imported with most tools. Come to think of it mysql has a db migration toolkit that should do it. http://dev.mysql.com/downloads/gui-tools/5.0.html Worst case you could make a cfm page that loops over the access db and if you recreate the table in mysql then grab the data from each row and insert it into mysql.. that would be fairly easy.

Dave l wrote: >> Ok. First thing I'll be looking for is a way to migrate the data in the >> old Access databases to MySQL. > > have fun with that! Trying to. Be more fun when I can get my sites to run properly on my Mac   and I can get to the task of site building. > http://dev.mysql.com/downloads/gui-tools/5.0.html I downloaded the Mac Disk Image, but it only has the the Admin and the Query Browser apps. Is the Migration Tool Windows only? > Worst case you could make a cfm page that loops over the access db and if you recreate the table in mysql then grab the data from each row and insert it into mysql.. that would be fairly easy. Does Railo support Access so I could read the tables to loop and write the rows to a MySQL mirror? Thanks, * JB *