MySQL Database Corruption

May 17, 2007 — Whitney Young

Something caused some tables to become unreadable today and as a result most of the site was showing error messages. The problem has been fixed and everything is back to normal. Sorry if this caused any problems.

No Comments Tags: MySQL, Webserver

Trac Migration (SQLite to MySQL)

May 4, 2007 — Whitney Young

Today I migrated Trac 0.10.3 to 0.10.4 and finally managed to get Trac set up with MySQL. Upgrading Trac went fine. Migrating from one database to another was a bit difficult, though. The script for migrating from SQLite to MySQL on Trac's site didn't quite do the job. It failed to convert the quotes from SQLite output into backticks for MySQL. I wrote a new script and will outline how to work through the whole process below.

Read More...

No Comments Tags: MySQL, SQLite, Trac, Webserver