Flutterby™! : Porting the Flutterby CMS to MySQL to

Next unread comment / Catchup all unread comments User Account Info | Logout | XML/Pilot/etc versions | Long version (with comments) | Weblog archives | Site Map | | Browse Topics

Porting the Flutterby CMS to MySQL to

2015-02-18 03:25:04.467133+00 by Dan Lyke 4 comments

Porting the Flutterby CMS to MySQL to move my blog to hosting from a dedicated server. How do y'all put up with this excuse for a database?

[ related topics: Content Management Weblogs Open Source Databases ]

comments in ascending chronological order (reverse):

#Comment Re: Porting the Flutterby CMS to MySQL to made: 2015-02-18 15:01:51.514565+00 by: Larry Burton

First you stop thinking of it as a SQL database. It does things its way. Don't resist it, work with it. Embrace its way of doing things rather than fighting it.

I do very few SQL calls to MySQL anymore, I just use several products that are based on it. From that perspective it seems to be pretty solid.

#Comment Re: Porting the Flutterby CMS to MySQL to made: 2015-02-18 15:40:54.619264+00 by: markd

Sorry for the block of text, but somewhat apropos (from one of the early aD folks)

"Have any of you ever read the comments on a popular site like f---ed company or slashdot? 90%+ of the postings should make you embarrassed to be a member of the human race. Even on GOOD community sites like photo.net, about 80% of the postings are disposable. Do you really want to reliably preserve thousands of "me first" and "mr stinky finger" posts for the rest of eternity? Everyone should encourage the use of unstable architectures for typical crummy community sites. A server crash on one of these sites has the potential to wipe out hard evidence that the internet world of the late 90s and early 2000s was populated mainly by immature, racist, homophobic sociopaths. The use of MySQL should be encouraged, for your children's sake." -- Rzolf

#Comment Re: Porting the Flutterby CMS to MySQL to made: 2015-02-18 16:25:20.498014+00 by: mkelley

and that's why my blog posts from 2000-2007 have been ported to .txt files.

#Comment Re: Porting the Flutterby CMS to MySQL to made: 2015-02-20 14:51:12.719505+00 by: meuon

I abuse MySQL a lot. It works.

You would have to dump all tables and reload to use this but the config option:

innodb_file_per_table

makes a big difference if you are using Innodb.