Database Woopsie

Published on Feb. 13, 2008 under Tech Blog

I returned to my computer today to notice I had the following error: (145, "Table './databasename/comments_freecomment' is marked as crashed and should be repaired") Well, crap. The solution is quite easy, however: mysqlcheck -uUsername -pPassword databasename comments_freecomment Now you know what you already know, you can ... Read more.

MySQL Replication

Published on Jan. 23, 2006 under Projects

Status: The webapp server is running fine, but backups are important. Better yet, a hot computer is a great idea. To do this, I setup an older spare rackmount as a 'live' webapp server, just in case. A duplicate LAMP was setup, web apps copied over ... Read more.

MySQL Replication

Published on Jan. 22, 2006 under Notes and Tutorials

Whether you want to have a live copy to help distribute workload, or have a copy as a pseudo-hot-swapable backup like me, replicating your MySQL server is a must. While this isn't a foolproof solution (a DELETE/DROP command issues will replicate as well), it does help protect against data loss ... Read more.