New tutorial added to HowtoMatrix database.
Installing Lighttpd With PHP5 And MySQL Support On Mandriva 2010.0
Lighttpd is a secure, fast, standards-compliant web server designed
for speed-critical environments. This tutorial shows how you can
install Lighttpd on a Mandriva 2010.0 server with PHP5 support (through
FastCGI) and MySQL support.
Link to the original site
New tutorial added to HowtoMatrix database.
Evolving A Database With MySQL
This tutorial explains how to grow your own database definition in a way that is maintainable, by using so-called recreate scripts. These scripts can be used to both create a database from scratch and update an existing database.
Link to the original site
New tutorial added to HowtoMatrix database.
Installing Lighttpd With PHP5 And MySQL Support On Mandriva 2009.1
table align=left cellpadding=0 cellspacing=0 width=43 height=40 style=margin-top:0px;margin-bottom:0px;trtdimg class=teaser-image-even src=http://images.howtoforge.com/images/teaser/mandriva.gif width=40 height=40 alt= //td/tr/tablepbInstalling Lighttpd With PHP5 And MySQL Support On Mandriva 2009.1/b/p
pLighttpd is a secure, fast, standards-compliant web server designed
for speed-critical environments. This tutorial shows how you can
install Lighttpd on a [...]
This howto was written when I needed to run some php based web
applications and the only system around was FreeNAS. Although many
people are using php and MySQL on a FreeNAS box successfully I couldn’t
find any simple tutorial for the purpose, so I wrote one in case anyone
needs it.
Read more at HowtoForge
Cherokee is a very fast, flexible and easy to configure Web Server.
It supports the widespread technologies nowadays: FastCGI, SCGI, PHP,
CGI, TLS and SSL encrypted connections, virtual hosts, authentication,
on the fly encoding, load balancing, Apache compatible log files, and
much more. This tutorial shows how you can install Cherokee on an
Ubuntu 9.04 server with PHP5 support (through [...]
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 9.04 server with PHP5 support (mod_php) and MySQL support.
I do not issue any guarantee that this will work for you!
1 Preliminary Note
In this tutorial I use the hostname server1.example.com with the IP address [...]
This tutorial covers the setup of PHP 5.3.0/Lighttpd on Debian (lenny) with imap, mysql, mysqli, sqlite3, ImageMagick and mycrypt support.
For this tutorial I will assume you are logged in as root this is not advised.
First we need to install the webserver:
aptitude install lighttpd
Now we install the packages needed for mysql and mysqli support. You will [...]
Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, SSI, TLS and SSL encrypted connections, Virtual hosts, Authentication, on the fly encoding, Load Balancing, Apache compatible log files, Data Base Balancing, Reverse HTTP Proxy, Traffic Shaper, Video Streaming and much more.
Read the [...]
Occasionally, under circumstances involving high load on the server, multiple INSERTs and UPDATEs, coupled with many SELECTs (see Section 28.5 for the syntax of SQL code), or hardware failure, your database server may corrupt a table. This is something it shouldn’t happen, but of course this doesn’t help you if it does. According to the
Read [...]
This guide explains how to set up WebDAV with MySQL authentication
(using mod_auth_mysql) on Apache2 on a Debian Lenny server. WebDAV
stands for Web-based Distributed Authoring and Versioning and
is a set of extensions to the HTTP protocol that allow users to
directly edit files on the Apache server so that they do not need to be
downloaded/uploaded via FTP. [...]
Nginx (pronounced
“engine x”) is a free, open-source, high-performance HTTP server. Nginx
is known for its stability, rich feature set, simple configuration, and
low resource consumption. This tutorial shows how you can install Nginx
on a Debian Lenny server with PHP5 support (through FastCGI) and MySQL
support.
Read more at HowtoForge
I know that it is easy to forget your password, especially when it contains plenty of symbols, digits and upper/lower case. In WordPress, if you have forgotten your password, you can get it to reset your password via your email account. However, in the event that you also forget your username or the email you [...]
mtop allows you to monitor your MySQL instance in real-time. It shows you uptime of the instance, number of queries executed per second, slow queries, number active threads, etc.
If on Ubuntu/Debian: sudo apt-get -y install mtop
Use following command to watch your MySQL server stats with 1 second refresh interval.
mtop -se 1
Read more at Tux TRaining
There are various reasons to set up quick “sandbox” instances of MySQL.
You can use them to test different types of replication (such as
master-master or various slave topologies), to test your code against
different versions of MySQL, or to setup instances of MySQL on a per
developer basis where each person has their own database running on a
different [...]
MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries.
Read more at Ubuntu Geek