Debian-news is about one simple thing - news about Debian GNU/Linux and the top free distributions based on Debian GNU/Linux.

Installing Apache2 With PHP5 And MySQL Support On Debian Wheezy

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Debian Wheezy server with PHP5 support (mod_php) and MySQL support.

About Gallery3 in Debian and MySQL

Then Gallery2 was released which used a database, either MySQL or PostgreSQL, and was a huge improvement in speed. My main galleries do have about 10-20.000 pictures each. But Gallery2 is aged nowadays and the next logical step would be to migrate to Gallery3. But what a mess!

How To Back Up MySQL Databases With mylvmbackup On Debian Squeeze

mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM’s snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article […]

Installing PowerDNS (With MySQL Backend) And Poweradmin On Debian Squeeze

This article shows how you can install the PowerDNS nameserver (with MySQL backend) and the Poweradmin control panel for PowerDNS on a Debian Squeeze system.

Reducing MySQL memory usage

If you are running your services on a low end virtual hosting every byte of memory you can save is important. The memory is often the limiting factor of how many applications you can run on VPS: CPUs are shared, memory not, on the same physical host.

Installing Nginx With PHP5 And MySQL Support On Debian Squeeze

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 Squeeze server with PHP5 support (through FastCGI) and MySQL support.

The Perfect Server – Debian Squeeze (Debian 6.0) With BIND & Courier [ISPConfig 3]

This tutorial shows how to prepare a Debian Squeeze (Debian 6.0) server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, […]

A simple Debian based dev environment

This is just a quick walkthrough describing how to setup a decent development environment allowing the easy setup of multiple sites. It already assumes you have a working Debian or Ubuntu OS installed and configured with PHP, MySql & Apache already running. You will also need to have a working sudo.

How To Set Up MySQL Database Replication With SSL Encryption On Debian Lenny

This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave).

Debian Server Guide Part 3

This section will help you get MySQL install, running, and configured. We’ll get PhpMyAdmin installed and configured to help get MySQL fully manageable. First run this command to get the correct packages installed logged in as root.

Installing PowerDNS (With MySQL Backend) And Poweradmin On Debian Lenny

This article shows how you can install the PowerDNS nameserver (with MySQL backend) and the Poweradmin control panel for PowerDNS on a Debian Lenny system. PowerDNS is a high-performance, authoritative-only nameserver – in the setup described here it will read the DNS records from a MySQL database (similar to MyDNS), although other backends such as […]

How to install MySQL on Ubuntu/Debian

It may seem easy for some, but for others, installing MySQL on Ubuntu or Debian Linux is not an easy task. This article explains to you how to install the MySQL Server and Client packages on a Ubuntu/Debian system.

Python script to backup mysql databases on Debian

Here’s a short python script I must have knocked up some time ago – and totally forgotten – hopefully it’ll be of some use to others….Purpose: backup all MySQL databases, one in each file with a timestamp on the end

Debian Linux and the PostgreSQL Database For Options To Build Library Information System-Based Open Source

We have two databases open source environment that is very reliable, namely PostgreSQL and MySQL. Both these databases have some significant differences either, PostgreSQL is an Object Relational Database Management System (ORDBMB). While MySQL is RDMS.

Virtual Hosting With vsftpd And MySQL On Debian Lenny

Vsftpd is one of the most secure and fastest FTP servers for Linux. Usually vsftpd is configured to work with system users. This document describes how to install a vsftpd server that uses virtual users from a MySQL database instead of real system users.

How to setup Ruby on Rails, Apache and Passenger on Debian Linux

For this article I’m going to install a single (virtual) server to run a standard Ruby on Rails application. I will be using Apache2 and passenger for the webserver stack and MySQL as a database server.

MySQL on Debian and Ubuntu

Debian Linux (the underlying foundation of Ubuntu) manages the startup/shutdown of MySQL quite differently from the ways I am used to. I am a long-time user of both the MySQL binary provided by Red Hat/SuSE (along with Fedora and clones like CentOS and Oracle Enterprise Linux) and the official binary from mysql.com.

Installing Cherokee With PHP5 And MySQL Support On Debian Lenny

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.

Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Debian Lenny

This document describes how to install a Proftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota with this setup.

Install Mysql 5.1 for SPARC64 under Debian Lenny

If you happen to own a SPARC64 box, you’ll probably already know that even if the kernel is 64bit the userland comes from the normal SPARC Debian port, so it’s 32bit. Mysql is no exception, with all the 32bit limitations – mainly the 4GB RAM per process limit.

Install PHP 5.3.0/Lighttpd On Debian (Lenny) With Imap, MySQL, Sqlite3 And ImageMagick Support

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.

MySQL backup on Ubuntu or Debian

This guide is for Sys Admins–or people who have a bit of Sys Admin skills. While there is a plethora of database backup products for MySQL that exist, this post is not about those products. We’ll use the built-in tools of MySQL for the backup process–it is in fact, a very simple process.

Upgrading MySQLdb on Ubuntu/Debian

Like I wrote about last week the stable version of MySQLdb leaks memory and it will crash your long running processes. These leaks are fixed in the upcoming version – which is 1.2.3c1 currently.

Installing MyDNS-NG & MyDNSConfig 3 On Debian Lenny

In this tutorial I will describe how to install and configure MyDNS-NG and MyDNSConfig 3 on Debian Lenny. MyDNS-NG is a DNS server that uses a MySQL database as backend instead of configuration files like, for example, Bind or djbdns.

MySQL at Debian and Ubuntu

Good news, mysql-server package doesn’t suck miserably on Debian 5.0 or Ubuntu 8.10, unlike previous versions did

Installing Debian Web-server with Apache, PHP, and MySQL on virtual machine

Why Debian? Because Debian is a popular Linux distribution vendor and has small install image file. I’ve tried to install Debian with Virtual PC, VirtualBox and VMWare and have different results on different PC.


Debian-News is not related to the Debian Project.
All logos and trademarks on this site are property of their respective owners.