Go back to fronty page View most popular entries View latest additions Submit tutorials to UnixTutorials.info
UnixTutorials logo

Search results for How To Back Up MySQL Databases Without Interrupting MySQL

Linux

How To Back Up MySQL Databases Without Interrupting MySQL

Post date: May 12, 2007, 23:05 Category: System Views: 3563 Comments
Tutorial quote: 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 do not 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.
Ubuntu

Creating MySQL Backups With AutoMySQLBackup On Ubuntu 9.10

Post date: February 19, 2010, 11:02 Category: Miscellaneous Views: 2982 Comments
Tutorial quote: 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.
Debian

Preventing MySQL Injection Attacks With GreenSQL On Debian Etch

Post date: October 28, 2008, 12:10 Category: Security Views: 3690 Comments
Tutorial quote: GreenSQL (or greensql-fw) is a firewall for MySQL databases that filters SQL injection attacks. It works as a reverse proxy, i.e., it takes the SQL queries, checks them, passes them on to the MySQL database and delivers back the result from the MySQL database. It comes with a web interface (called greensql-console) so that you can manage GreenSQL through a web browser. This guide shows how you can install GreenSQL and its web interface on a Debian Etch server.
Unix+clones

Optimizing DSPAM + MySQL 4.1

Post date: April 2, 2006, 22:04 Category: Optimizing Views: 3807 Comments
Tutorial quote: DSPAM is a scalable and open-source content-based spam filter designed for multi-user enterprise systems. It's great at filtering out spam but on busy mailservers the pruning of the MySQL databases takes way too long time ...
Ubuntu

How To Set Up Database Replication In MySQL On Ubuntu 9.10

Post date: January 12, 2010, 12:01 Category: Miscellaneous Views: 2729 Comments
Tutorial quote: 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.
CentOS

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

Post date: February 18, 2010, 13:02 Category: Miscellaneous Views: 4374 Comments
Tutorial quote: 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.
Ubuntu

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

Post date: February 9, 2010, 01:02 Category: Installing Views: 2665 Comments
Tutorial quote: 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.
Unix+clones

How To Set Up Database Replication In MySQL

Post date: December 14, 2005, 19:12 Category: Software Views: 3806 Comments
Tutorial quote: 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.

In this tutorial I will show how to replicate the database exampledb from the master with the IP address 192.168.0.100 to a slave. Both systems (master and slave) are running Debian Sarge; however, the configuration should apply to almost all distributions with little or no modification.
Gentoo

HOWTO Linux Virtual Hosting Server

Post date: April 9, 2006, 14:04 Category: Software Views: 6590 Comments
Tutorial quote: This document will explain how to install and configure a mail server capable of handling hundreds of domains and users. This how-to uses Postfix, Courier-imap, Mysql, and Apache as the core of this virtual system. If these packages don't appeal to you, Gentoo has a number of how-to's built around other MTA's or databases.
Linux

Tunneling MySQL connections through SSH

Post date: January 2, 2007, 20:01 Category: Security Views: 3412 Comments
Tutorial quote: This is a description of how to set up a secure tunnel between your MySQL Server and a locally running MySQL Administrator using Putty. By creating a secure tunnel to your MySQL server using Putty, you can grant localhost access to powerful applications like MySQL Administrator while at the same time, make your server appear as if it isn't even there. In effect, make your MySQL server disappear from the outside world.
Web-based applications and online marketing solutions - LumoLink