Linux Tutorials on the topic “mysql”

• Installing Lighttpd With PHP5 And MySQL Support On Fedora 12

  Author: Falko Timme • Tags: fedora, lighttpd, mysql, php • Comments: 0

  Installing Lighttpd With PHP5 And MySQL Support On Fedora 12 Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a Fedora 12 server with PHP5 support (through FastCGI) and MySQL support.

  read more... | view as pdf

• Creating MySQL Backups With AutoMySQLBackup On Ubuntu 9.10

  Author: Falko Timme • Tags: mysql, backup, ubuntu • Comments: 1

  Creating MySQL Backups With AutoMySQLBackup On Ubuntu 9.10 AutoMySQLBackup is a shell script that lets you take daily, weekly and monthly backups of your MySQL databases using mysqldump. It can back up multiple databases, compress the backups, back up remote databases, and email the logs. This tutorial explains how to install and use it on an Ubuntu 9.10 server.

  read more... | view as pdf

• How To Set Up MySQL Database Replication With SSL Encryption On CentOS 5.4

  Author: Falko Timme • Tags: mysql, centos • Comments: 13

  How To Set Up MySQL Database Replication With SSL Encryption On CentOS 5.4 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). 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 replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

  read more... | view as pdf

• Installing Lighttpd With PHP5 And MySQL Support On Mandriva 2010.0

  Author: Falko Timme • Tags: lighttpd, mandriva, mysql, php • Comments: 0

  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.

  read more... | view as pdf

• How To Set Up MySQL Database Replication With SSL Encryption On Ubuntu 9.10

  Author: Falko Timme • Tags: mysql, security, ubuntu • Comments: 3

  How To Set Up MySQL Database Replication With SSL Encryption On Ubuntu 9.10 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). 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 replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

  read more... | view as pdf

• How To Set Up Database Replication In MySQL On Ubuntu 9.10

  Author: Falko Timme • Tags: mysql, ubuntu • Comments: 10

  How To Set Up Database Replication In MySQL On Ubuntu 9.10 This 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 replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

  read more... | view as pdf

• How To Back Up MySQL Databases With mylvmbackup On Debian Lenny

  Author: Falko Timme • Tags: backup, debian, mysql • Comments: 0

  How To Back Up MySQL Databases With mylvmbackup On Debian Lenny 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 shows how to use it on a Debian Lenny server.

  read more... | view as pdf

• Installing Lighttpd With PHP5 And MySQL Support On CentOS 5.4

  Author: Falko Timme • Tags: centos, lighttpd, mysql, php • Comments: 2

  Installing Lighttpd With PHP5 And MySQL Support On CentOS 5.4 Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a CentOS 5.4 server with PHP5 support (through FastCGI) and MySQL support.

  read more... | view as pdf

• Installing Apache2 With PHP5 And MySQL Support On Fedora 12 (LAMP)

  Author: Falko Timme • Tags: apache, fedora, mysql, php • Comments: 0

  Installing Apache2 With PHP5 And MySQL Support On Fedora 12 (LAMP) LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Fedora 12 server with PHP5 support (mod_php) and MySQL support.

  read more... | view as pdf

• Installing Lighttpd With PHP5 And MySQL Support On Ubuntu 9.10

  Author: Falko Timme • Tags: lighttpd, mysql, php, ubuntu • Comments: 0

  Installing Lighttpd With PHP5 And MySQL Support On Ubuntu 9.10 Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on an Ubuntu 9.10 server with PHP5 support (through FastCGI) and MySQL support.

  read more... | view as pdf