MySQL

Many people asked me to write about setting up Lighttpd under CentOS or RHEL 5 Linux using chroot() call. The instructions are almost same but you need to make little modification as compare to Debian / Ubuntu Linux instructions.

{ 10 comments }

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 […]

{ 0 comments }

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 user@remote.server.com “dd […]

{ 5 comments }

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 […]

{ 0 comments }

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 […]

{ 11 comments }

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, […]

{ 9 comments }

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 […]

{ 2 comments }