MySQL – SleePy Code

iRedMail on Nginx

Published by Jeremy on March 15, 2013

This is my experiment to get iRedMail to work with Nginx. In the end I got everything to work other than awstats, although with some caveats. I don’t like awstats very much and it seemed quite troublesome to get it setup. There is a mode to run awstats in that lets it just generate static …

Convert TS3 from sqlite to mysql database

Published by Jeremy on December 2, 2010

I run a teamspeak server and it uses teamspeak3. However when I set it up, I didn’t bother getting any further than getting it running. Now I find out that its using sqlite for a database and that database is taking up a lot of data for useless logs. First step was to figure out …

Mysql queries using offsets without limits

Published by Jeremy on August 2, 2010

While working on a project, I came across the need for a script to run a loop through a table and process some commands. However, due to the size of the table, this surely would take longer than the default 30 seconds that is setup in most configurations. However, I didn’t want to do any …

Moving mysql

Published by Jeremy on June 27, 2010

Time to move my mysql data directory to another drive. So its up to some simple commands to get me started. First my my.conf file. $ sudo mv /etc/mysql/my.cnf /home/configs $ sudo ln -s /home/configs/my.cnf /etc/mysql/ I should note that the way I installed mysql (apt-get), a debian.cnf file is created. I haven’t even bothered …

Securing database user credentials

Published by Jeremy on June 20, 2010

A random thought has hit me. Most people try to keep their MySQL user credentials secure. But why? If a server has been setup properly, it becomes a mute point. The idea occurred me when thinking about opening a sites source code up. If I opened the site up, I could give them access to …