Back up and print WordPress blog with Base

Posted on in Categories Download of the day, Howto, Linux, Linux desktop, MySQL last updated November 1, 2007

This sounds like a good idea to me. Never thought one can use OpenOffice to import MySQL database and do all sort of crazy things. I can even build PDF file of all top posts and provide it as download option for a small fee. From the article:

If you are running a blog (or any Web publishing system, for that matter) that relies on a database back end, you will sooner or later face the problem of backing up the content stored in the database. One way to go about it is to build a backup tool using Base. Since Base can pull data from a MySQL or any ODBC-compliant data source, you can create a simple database that connects to the blog’s back end and extracts content from it, which you can then export in different formats.

Read more

Quickly Backup / dump MySql / Postgres database to another remote server securely

Posted on in Categories Backup, FreeBSD, Howto, Linux, MySQL, Postgresql, RedHat/Fedora Linux, Sys admin, Tips, UNIX last updated October 1, 2007

Using UNIX pipe concept one can dump database to another server securely using ssh protocol. All you need remote execution rights for the ‘dd’ command, over SSH. This allows you to run database dumps across an encrypted channel.

Dump Postgres Database using ssh

Use pg_dump command command:
pg_dump -U USERNAME YOUR-DATABASE-NAME | ssh [email protected] "dd of=/pgsql/$(date +'%d-%m-%y')"

Dump MySQL Database using ssh

Type the following command:
mysqldump -u USERnAME -p'PASSWORD' YOUR-DATABASE-NAME | ssh [email protected] "dd of=/mysql/$(date +'%d-%m-%y')"

Howto: Make consistent MySQL database backups using Solaris ZFS snapshots

Posted on in Categories Howto, MySQL, Solaris, UNIX last updated August 20, 2007

I’ve already written about MySQL backup using a shell script and consistent backup with Linux Logical Volume Manager (LVM) snapshots:

A snapshot volume is a special type of volume that presents all the data that was in the volume at the time the snapshot was created. This means you can back up that volume without having to worry about data being changed while the backup is going on, and you don’t have to take the database volume offline while the backup is taking place.

Niclas has posted a nice howto about consistent MySQL backups using Solaris UNIX ZFS snapshots:

In this article I will show you how to install MySQL on a ZFS file system and supply you with a script to make consistent snapshots of the databases. This script may not be 100% fit for busy sites but for most smaller places I think it is perfect.

MySQL Proxy Load balancing and Failover Tutorial

Posted on in Categories CentOS, Debian Linux, Download of the day, High performance computing, Howto, Linux, Monitoring, MySQL, RedHat/Fedora Linux, Suse Linux, Tuning, Ubuntu Linux, UNIX last updated August 10, 2007

MySQL Proxy is a simple and new program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication. Its flexibility allows for a wide variety of use cases, including:
a) Load balancing
b) Failover
c) Query analysis
d) Query filtering and modification
e) and many more…

MySQL Proxy tutorial

Oreilly has published a nice tutorial using MySQL proxy application:

MySQL Proxy is a lightweight binary application standing between one or more MySQL clients and a server. The clients connect to the Proxy with the usual credentials, instead of connecting to the server. The Proxy acts as man-in-the-middle between client and server.

In its basic form, the Proxy is just a redirector. It gets an empty bucket from the client (a query), takes it to the server, fills the bucket with data, and passes it back to the client.

If that were all, the Proxy would just be useless overhead. There is a little more I haven’t told you yet. The Proxy ships with an embedded Lua interpreter. Using Lua, you can define what to do with a query or a result set before the Proxy passes them along.

MySQL Proxy Load balancing and Failover Tutorial - Logo

Download MySQL proxy

You can download MySQL proxy here

Install and configure MySQL on Windows XP or Vista or 2003 server

Posted on in Categories GNU/Open source, MySQL, Windows, Windows server last updated June 25, 2007

There is a nice small article about using MySQL on Windows 2003 or Vista desktop system.

I honestly have to say that, now after years of using MySQL on Windows, I find it to be my favorite database/platform combination of choice. In my opinion, it’s easier to use than Microsoft’s own database on their platform, the performance and feature set will meet 90+% of the needs that Windows/Web applications have, it consumes less resources than SQL Server, and the reliability is stellar.

This article shows you why you should believe this to be the case and why, if you haven’t started using MySQL on Windows yet, you really should think about doing so.

MySQL on Windows? Absolutely! []

PHP, Perl, MySQL web programming tutorials, howtos for beginners and novice users

Posted on in Categories Apache, FAQ, Howto, Linux, MySQL, UNIX last updated June 6, 2007

The motto of this site is learn with pictures, not words:

In Pictures tutorials began as part of a research study we conducted for the U.S. Department of Education. The goal: to make it easier for people with learning disabilities to learn computer subjects.

As part of the study, we created simple, illustration-based tutorials. Everyone who tested them–not just people with learning disabilities–said the new tutorials enabled them to learn faster and easier than conventional text-heavy books.

The site offers tutorials on common Linux web programming subject:
=> PHP

=> Perl

=> MySQL

Great work! (Thanks to [email protected] for a hat tip)