Linux Tutorials on the topic “mysql”
-
Quick DB Setups With MySQL Sandbox
Author: jgoulah •
Tags: mysql •
Comments: 1 Quick DB Setups With MySQL Sandbox 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 port so they can breakdown/setup the DB easily or make schema changes without affecting other team members. A perfect tool to do all of these things easily is MySQL Sandbox.
-
Adding An ODBC Driver For MySQL On Ubuntu
Author: clawoo • Tags: mysql, ubuntu • Comments: 4Adding An ODBC Driver For MySQL On Ubuntu Sometimes you may find the need to develop cross platform applications which make use of a database. ODBC can be a solution to your portability needs, but unfortunately it is not as easy to set up an ODBC connection on Linux as it is on Windows. This tutorial attempts to shed some light on this process by guiding you towards adding an ODBC driver on Ubuntu. The process described below has been tested on Ubuntu 8.04 and Ubuntu 8.10.
-
How To Back Up MySQL Databases With mylvmbackup On Ubuntu 8.10
Author: Falko Timme •
Tags: backup, mysql, ubuntu •
Comments: 2 How To Back Up MySQL Databases With mylvmbackup On Ubuntu 8.10 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 an Ubuntu 8.10 server.
-
-
ZRM 2.1: Backing Up MySQL Partitioned Tables
Author: paddy •
Tags: mysql, backup, centos •
Comments: 2 ZRM 2.1: Backing Up MySQL Partitioned Tables MySQL 5.1 is generally available for production use. One of the key features of MySQL 5.1 is partitioning. This how to shows how to install and configure Zmanda Recovery Manager for MySQL (ZRM) 2.1 to perform backup and recovery of MySQL partitioned tables.
-
Setting Up Master-Master Replication On Four Nodes With MySQL 5 On Debian Etch
Author: Falko Timme •
Tags: mysql, debian, high-availability •
Comments: 15 Setting Up Master-Master Replication On Four Nodes With MySQL 5 On Debian Etch This tutorial explains how you can set up MySQL master-master replication on four MySQL nodes (running on Debian Etch). The difference to a two node master-master replication is that if you have more than two nodes, the replication goes in a circle, i.e., with four nodes, the replication goes from node1 to node2, from node2 to node3, from node3 to node4, and from node4 to node1.
-
Shell Script To Back Up All MySQL Databases, Each Table In An Individual File And Upload To Remote FTP
Author: marchost •
Tags: mysql, backup •
Comments: 10 Shell Script To Back Up All MySQL Databases, Each Table In An Individual File And Upload To Remote FTP This script will create a backup of each table in every database (one file per table), compress it and upload it to a remote ftp.
-
The Umlaut Problem - How To Successfully Back Up And Restore MySQL Databases With Special Characters Using MySQLDumper
Author: Been Told •
Tags: mysql, backup •
Comments: 2 The Umlaut Problem - How To Successfully Back Up And Restore MySQL Databases With Special Characters Using MySQLDumper There are lots of forums with heaps of reports of umlauts or other special characters being displayed erroneously. Attempts to help come from many sides, but hardly anyone seems to have a really complete picture of the problem. Even web hosts' support hotlines seem to reach their limit of knowledge with this one. There are incredible amounts of half-truths. They prove correct in certain circumstances, but they do not help all people. Simply because setups vary so much. In my role as developer of MySQLDumper I naturally spent a lot of time evaluating this situation. And I now believe to be able to offer a complete overview which covers the different aspects of this problem. A lot, and I mean a lot of research has gone into the explanations in this article.
-
Creating MySQL Backups With AutoMySQLBackup
Author: Falko Timme •
Tags: mysql, backup •
Comments: 9 Creating MySQL Backups With AutoMySQLBackup 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.
-
Preventing MySQL Injection Attacks With GreenSQL On Debian Etch
Author: Falko Timme •
Tags: debian, mysql, security •
Comments: 1 Preventing MySQL Injection Attacks With GreenSQL On Debian Etch 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.
-
Installing ehcp (Easy Hosting Control Panel) On Any Debian Or Apt-Get Based Distro, Including Ubuntu
Author: bvidinli • Tags: apache, control panels, debian, dns, ftp, ispconfig, linux, mysql, other, php, postfix, ubuntu • Comments: 6Installing ehcp (Easy Hosting Control Panel) On Any Debian Or Apt-Get Based Distro, Including Ubuntu In this tutorial I will show you howto install ehcp on any debian based distro, or any distro that has apt-get support. ehcp stands for Easy Hosting Control Panel. It may be used by anyone wanting to host multiple domains in his dedicated/vps server. It is a hosting control panel under development.
