Tag: mysql

Here you can see a listing of all the posts tagged with mysql on this website.

  • Move a Django site to PostgreSQL: check

    Posted on July 26, 2008 at 22:50 +0200 Tagged with , , ,

    When I moved over from Dreamhost to Slicehost, one of the (minor) motivators was the option to use something different than MySQL. Don't get me wrong, though: MySQL is a nice system, fast, relatively memory-efficient and so on. But what drove and still drives me nuts is that not every storage engine within MySQL supports transactions. MyISAM can be as fast as it gets, if it lacks transaction support, I won't use it for at least some of my tables. And having to manually check that every time I write a new app really started to annoy me. But how to move a site like this, that is using Django, from one database system to another (or to be specific, PostgreSQL in this scenario) as simply as possible?

    [more ...]

    0 comments

  • Batch-renaming MySQL tables

    Posted on June 25, 2006 at 20:18 +0200 Tagged with ,

    Ever felt the need to batch-rename quite a few tables in a MySQL database? Sadly phpMyAdmin doesn't offer renaming of all the tables in a specific database. So I first started renaming them manually using the commandline interface but got soon quite tired of the whole process.

    A quite ugly but IMO pragmatic workaround for this limitation is to build a small query file holding all the RENAME TABLE statements you want. To generate this query listing first of all get a list of all the tables you want to rename.

    [more ...]

    2 comments