24 July 2006 01:15
ONLamp.com -- Live Backups of MySQL Using Replication
by springnet & 3 othersThere are only a few steps to setting up replication. The first step is to set up a user account to use only for replication. It's best not to use an existing account for security reasons. To do this, enter an SQL statement like the following on the maste
apache friends - very easy apache, mysql, php and perl installation without hassles
by springnet & 3 othersMany people know from their own experience that it's not easy to install an Apache web server and it gets harder if you want to add MySQL, PHP and Perl. XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. XAMPP is really very e
PHP MySQL Tutorial
by springnet & 4 othersSoon you will know just how easy it is to build dynamic web pages using PHP and MySQL. Really, PHP and MySQL is easy to learn, and I hope this tutorial will help you realise that :-)
SitePoint Forums - PHP and MySQL coding tips
by springnet & 2 othersI thought it would be good to create a thread with a lot of my common PHP and MySQL coding tips that I mention in other topics on here all the time. These are valuable things that I've learned during 1 year with PHP and MySQL. I believe these are good do'
ProfitPapers | Papers : Performance Tuning Mysql for Load
by springnet & 3 othersOn one of the largest Vbulletin based forums I operate we just finished a record month with a little over 217,000 uniques with just shy of half a million total users. As anyone else running a big board knows hitting these types of figures while maintainin
MySQL AB :: MySQL: The World's Most Popular Open Source Database
by springnet & 5 others# Row-based Replication # Table and Index Partitioning # MySQL Cluster Disk-Based Tables # Dynamic Pluggable Storage Engine API # MySQL Cluster Replication # Learn About More Cool Features (pdf) »
phpMyAdmin | MySQL Database Administration Tool | www.phpmyadmin.net
by springnet & 8 othersphpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.
MySQL Commands
by springnet & 1 otherCREATE TABLE [table name] (firstname VARCHAR(20), middleinitial VARCHAR(3), lastname VARCHAR(35),suffix VARCHAR(3), officeid VARCHAR(10),userid VARCHAR(15),username VARCHAR(8),email VARCHAR(35),phone VARCHAR(25), groups VARCHAR(15),datestamp DATE,timestam
John Wiseman » Blog Archive » Creating a MySQL connection with PHP/AJAX
by springnet & 5 othersIn this tutorial I will explain how to open a mysql database connection using PHP and the all popular AJAX. The purpose of this article is to demonstrate how the XMLHttpRequest object works within php and the advantages of using it.
24 July 2006 01:00
PHP Help: Creating a Membership System with PHP and MySQL
by springnetCreating a Membership System with PHP and MySQL
Top 7 PHP Security Blunders [PHP & MySQL Tutorials]
by springnet & 5 othersHP is a terrific language for the rapid development of dynamic Websites. It also has many features that are friendly to beginning programmers, such as the fact that it doesn't require variable declarations. However, many of these features can lead a progr
Zend Technologies - Beginner Tutorials - Build your own Database Driven Website using PHP & MySQL
by springnetA hands-on guide to learning all the tools, principles and techniques needed to build a fully functional database-driven Website using PHP & MySQL. This series covers everything from installing PHP & MySQL under Windows or Linux, through to building a liv
MySQL Gotchas
by springnet & 6 othersWhen working with the MySQL ™ database server I have repeatedly encountered situations where the results of various actions have been unexpected and/or contrary to the behaviour generally expected of an SQL relational database. The cause can usually be
MySQL AB :: Managing Hierarchical Data in MySQL
by springnet & 13 othersMost users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical
dublish.com - Simple Optimization for PHP and MySQL
by springnet & 4 othersHere is a list of a few very simple tips for optimizing your php/mysql applications. Keep these in mind while developing.
MySQL 5.0 Reference Manual
by springnet & 3 othersThis is the MySQL Reference Manual. It documents MySQL 5.0 through 5.0.23
How To Set Up Database Replication In MySQL | HowtoForge - Linux Howtos and Tutorials
by springnet & 4 othersThis tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately repl
24 July 2006 00:45
How To Set Up A Load-Balanced MySQL Cluster | HowtoForge - Linux Howtos and Tutorials
by springnet & 6 othersThis tutorial shows how to configure a MySQL 5 cluster with three nodes: two storage nodes and one management node. This cluster is load-balanced by a high-availability load balancer that in fact has two nodes that use the Ultra Monkey package which provi