mysql databases

Recently I was looking for XML reporting engine that allows me to generate reports from a variety of different MySQL databases. Your reports can be generated as PDF, PostScript, XML, HTML, DVI, Latex or straight ANSI text. Papyrus will correctly represent the reports in each of these outputted mediums with as much support as it […]

{ 0 comments }

Hardware and software failures are part of life. And that is why you need to have a backup plan. I have already written about backing up files and MySQL databases. There is no need to backup all installed binaries and software programs. The following tip will not just save your time, but both Debian and RHEL based distro can be updated instantly.

{ 54 comments }

This is a simple backup solution for people who run their own web server and MySQL database server on a dedicated or VPS server. Most dedicated hosting provider provides backup service using NAS or FTP servers. These service providers will hook you to their redundant centralized storage array over private VLAN. Since, I manage couple of boxes, here is my own automated solution. If you just want a shell script, go here (you just need to provided appropriate input and it will generate FTP backup script for you on fly, you can also grab my php script generator code).

{ 123 comments }