![[1+1=2]](http://www.oneandoneis2.org/Pix/1+1=2.png)
OneAndOneIs2
| « A reported conversation.. | I hate to say "I told you so" » |
Sun, Mar 08, 2009
![[Icon]](rsc/img/chain_link.gif)
![[Icon]](http://www.oneandoneis2.org/favicon.ico)
Another MySQL debug
I noticed that my blog's RSS feeds weren't working for the last couple days. But I had no idea why, and I had other things to worry about, so I didn't do much about it.
Then I got a helpful pointer from sokuban (Cheers, sok!) that at the bottom of the blog (Where I rarely go) was yet another MySQL error: This time, it was errno=1062 caused by a duplicate entry.
It was kind enough to tell me what it was trying to do at the time - update the hitlog - so I went into PhpMyAdmin and selected the evo_hitlog table and clicked on "optimise table"
This gave me a warning that "Number of rows changed from 133381 to 133386" and the error is now fixed.
I'm starting to get worried about the sheer size of this blog. The SQL database is nearly 45MB in size, it's actually so big that I can't actually back it up any more and it's starting to error out.
Oh well. I'm sure it'll be fine... ![[Smiley]](http://geekblog.oneandoneis2.org/img/smilies/icon_rolleyes.gif){kind=icon}
3 comments
I don't understand the error message at all, but I just saw "UNIXTIME" and I remembered 1234567890 Day and the Unix Y2K. (Was it in 2038 or something?)
I wonder what's gonna happen to my computers then. Either way, I'm going to buy 64bit next time I get a computer just in case.
(So offtopic, I know)
In fact, I wrote my entire blog backend using SQLite because I dislike MySQL intensely.
SQLite is extremely lightweight, configurable client-side database library but great for blog-driven websites and websites with medium to large sized databases. Backing up a database is as simple as copying the file over to another location. Again, it has enough tools like a graphical SQLite database browser which allows you to create small dbs very easily and also import or export SQL dumps to or from databases.
Nobody needs the power of a separate MySQL server backend unless one is running a worldwide corporate server and needs that scalability.
You can also save space by probably doing some trimming of older stuff that the blog might accumulate in the tables that you actually no longer need.
Something like this will show you your table information with sizes, etc:
mysql> show table status;
Comment feed for this postLeave a comment
![[Links]](http://geekblog.oneandoneis2.org/skins/112/rsc/img/chain_link.gif)
My links
Hmm.. new look for twitter? I hope it gets less "Ick! Change! Put it back!" nonsense than Facebook..
08/02/12
Facebook Syndication Error
08/02/12
![[Icon]](http://static.last.fm/matt/nice_favicon.png)
I last listened to:
Johann Pachelbel - Canon in D major
Most recent photo:
Submersible houseboat
![[Icon]](https://www.amazon.com/favicon.ico)
![[FSF Associate Member]](http://geekblog.oneandoneis2.com/media/getButton.png){kind=small}
![[Valid RSS feed]](http://geekblog.oneandoneis2.org/media/valid-rss.png "Validate my RSS feed feed")
Unless otherwise stated, all articles/files on this website are licensed under a Creative Commons License. This page's URL must be supplied in attribution.
Blog skin based on a design by Séverine Landrieu & François Planque
©2012 by Dominic Humphries • Credits: blog software | web hosting | monetize