![[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;
Leave a comment
![[icon]](http://geekblog.oneandoneis2.org/rsc/icons/feed-icon-16x16.gif)
Blogroll
![[icon]](http://www.creativehedgehog.com/icon.png){kind=icon}
Creative Hedgehog
La parte A se refiere solamente a las dos novelas estudiadas. La parte A debe ser preparada después de leer la primera mitad de la novela y contestar las siguientes preguntas: ¿te está gustando la novela/película o no, y por qué? No me gusta la novela. Las personajes que puedes gustar son superficiales, o hacen [...]![[Link to post]](http://geekblog.oneandoneis2.org/skins/112/rsc/img/chain_link.gif "[Link to post]")
06/08/10 - SPN3730 diario: Pascual Duarte parte A
![[icon]](http://geekblog.oneandoneis2.org/media/blogs/112/hari.png)
Hari's corner
Why please do stay on a bit longer! Hopefully I'll come back with something to write about04/09/10 - Hello, are you still there?
Place of Stuff
Isn't this exciting? We're out of the tedium of Genesis (world created, man falls, many people live and die. Oh, and attempted forced buggery and a spot of incest). We're into Exodus now; the Bible has got going, that tricky first chapter is out of the way and the real action can start! When the [...]
03/08/10 - The Bible ? On The Waterfront
![[icon]](http://geekblog.oneandoneis2.org/media/blogs/112/blogger.ico)
Yay! Labour Day!
Long weekend!
Yay!04/09/10 - Long Weekend!
![[icon]](http://nationeldiablo.wordpress.com/favicon.ico)
  This was possibly the most ridiculous show I have seen in a long time and I can get Sky 1 I know ridiculous. It could be summed up in three sentences Do you know what's in your cereal? Want to? Read the label. Instead it went on for a hour about how evil the [...]27/10/09 - Dispatches ? do you know what?s in your breakfast? (warning...
Blogroll generated by MagpieRSS
My links
You know.. It's been 24 hours and I *still* can't think how the way COBOL uses multi-level variables could ever have seemed like a good idea
05/09/10
Dominic tried to explain how circular references can cause a memory leak to a colleague this morning, and got told off for not working. Apparently, the analogy of a madman shooting anybody who isn't being pointed at by somebody else was NOT the boss-safe way to go..
01/09/10
![[Icon]](http://static.last.fm/matt/nice_favicon.png)
I last listened to:
The Offspring - She's Got Issues
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
©2010 by Dominic Humphries • Credits: blog software | web hosting | monetize