Articles Repository

Version 1.0
Author: Falko Timme
Last edited 04/23/2007

This article describes how you can back up MySQL databases without interrupting the MySQL service. Normally, when you want to create a MySQL backup, you either have to stop MySQL or issue a read lock on your MySQL tables in order to get a correct backup; if you don’t do it this way, you can end up with an inconsistent backup. To get consistent backups without interrupting MySQL, I use a little trick: I replicate my MySQL database to a second MySQL server, and on the second MySQL server I use a cron job that creates regular backups of the replicated database.

Read the rest of this entry »

In this article you will learn a simple method to make PHP/MySQL Pagination Class.

What is Pagination?
==============

What if you have a table with a thousand rows, and you want to allow
the user to browse through the entire table. Simply listing all the
records in that table would not be a good idea. Instead you should
break the table up into smaller “chunks” and allow the user to
navigate through theses “chucks”. This is what pagination does, it
allows you to break up large result sets from a database query, and
present it to the user in a more manageable way.

Read the rest of this entry »

Devshed articles have been a great resource for php-learners to learn php techniques very quickly and easily. A similar article on making a RSS (Rich Site Summary) has been posted on Devshed.

In this article we are going to discuss how to create a PHP-based RSS reader. It would be helpful if you know something about XML, but not really necessary. RSS documents have three main tags: Title, You can read the rest of this awesome article at http://www.devshed.com/c/a/MySQL/Creating-an-RSS-Reader-the-Reader/ 

 

Preface:

There are many howtos on building Apache with PHP, MYSQL support, but it is very rare to find some document on OCI8 support with Apache Build, recently I was building a web server in my data center and I was really in trouble when I was searching some installation document, there are few documents , but most of them are using either RPM version of packages or they are missing some of the essential steps. I am trying to write a howto that will help you to at least understand the installation with step-by-step method.

Plateform:

I am using IBM x system x86_64 bit server with RHEL 4 Update Level 4.

Read the rest of this entry »