Free backup mysql database software for linux

PHP MySQL Database Layer Class is a php class providing some very useful methods to work with a mySQL database.
Main features:
- connects you to a mySQL host and select a database in a single call (opposed to PHPs native functions which requires two steps)
- has a "query" method that has the same role as PHPs mysql_query but this one will tell you about the affected rows (through the "affectedRows" property) when executing an INSERT, UPDATE, DELETE query and about the found rows (through the "foundRows" property) when executing a SELECT query - the "foundRows" property tells you how many records would the query return if there was no LIMIT applied to it - very useful when creating listing so you dont have to do a query to determine how many records you have in a database and the again a query to show only the records from a page
- has an "escape_string" method that will "mysql_real_escape_string" your string weather the magic_quotes are on or not
- has a "dlookup" method that i am sure you will find VERY useful once you get to know it: it return data from a single table cell based on standard mySQL WHERE criteria - see the manual for detailed info! (yes, it acts exactly like the function with the same name from microsft access)
- provides you with a very useful debug interface which shows you each query your script is running, for how long, the total number of queries made, the total execution time of your queries, errors of your queries and what are the values of $_GET, $_POST, $_COOKIES and $_SERVER superglobal variables. The debug interface is template driven and supports localisation.
- it will notify you if a specific query is executed more than once and will advise you to optimize the script
- you can instruct it to send you an email if a query runs longer then a specified time
- the code is heavily documented so you can easily understand every aspect of it and even maybe use it as a php tutorial
Enhancements:
- the state of $_FILES and $_SESSION superglobals are now also shown in the debug window
- better integration with XTemplate (previously, there was a variable assigned to each entry in the language file now the XTemplates feature to handle arrays is used)
- properties will now have default values in PHP 4

Backup Manager is a command line backup tool for GNU/Linux, designed to help you make daily archives of your file system.
Backup Manager is written in bash and perl and it can make tar, tar.gz, tar.bz, and zip archives and can be run in a parallel mode with different configuration files.
Archives are kept for a given number of days and the upload system can use ftp or scp to transfer the generated archives to a list of remote hosts. The configuration file is very simple and basic and gettext is used for internationalization.
Main features:
- Make tar, tar.gz, tar.bz and zip archives.
- Automatically burn the archives on CDR/CDRW media.
- Logging to syslog is possible
- Perform MD5 checksums when burning data on CDR to be sure that archives arent corrupted.
- Backup MySQL databases with mysqldump
- Can be run in a parallel mode with different configuration files.
- Keep and purge all the archives for a given number of days.
- Upload the generated archives to remote hosts, either with ftp or scp.
- Provide two diffrent ways of naming the tarballs.
- Is completly integrated to the Debian environment.
- The Debian package uses debconf to provide a quick and easy setup.

MP3-Database project is a tool to organize your MP3 collection. If you insert a CD with MP3 files in your CDROM drive, MP3DB can read all ID3 tags of the MP3 files.
With this information MP3DB creates a database which can be searched for a specific song, artist, or CD.
A GUI makes it easy to use the program. Any title found in the database can easily be added to a playlist or can instantly be played by XMMS.
Main features:
- MySQL (Is needed as database backend)
- Perl5
- Perl Modules:
- Tk
- Tk-MesgBox
- Tk-LabFrame
- Tk-Pane
- DBI
- MP3-Info
- Msql-Mysql-modules
- To play MP3 files the MP3 player XMMS should be installed on your system. MP3-Database can easily be adapted to other MP3 players
Enhancements:
- NEW Data Structure: The MySQL database is much more complex than before. I used 3 Tables for Artists, Albums and Titles to store the data. This ensures that I have no redundancies in the tables. This has also enabled me to store additional fields in the database (for example the date of birth of an artist, or the release year of an album).
- NEW Temporary Database: I added some tables to store all new artists, albums and titles in a temporary database. This enables the user to check the new entries before adding them to the permanent database.
- NEW FEATURES: Additional Artist and Album information can be stored in the database, MP3DB can now create a random playlist and a playlist with the top 20 MP3 titles, MP3DB can show you a statistic how many artists, albums and titles are stored in the database.

Large Database Backup is a PHP class can be used to backup large MySQL databases into multiple files.

It can list the tables of a given MySQL database and generate SQL statements to create and insert records with the current values of the table rows, as if it was creating a new database. The class stores the generated SQL statements in files.

A full backup process can be split in multiple iterations to not exceed PHP default script execution time limit. Each iteration dumps a limited number of table rows. An iteration can be executed by a script that redirects the page request to itself at the end to proceed to the next iteration.

mysqlApache is a MySQL database backend and browser based frontend for managing large numbers of Apache web servers (each of more than a 1000 virtual and IP-based web sites).

It is part of the OpenISP project and works if you like with mysqlBind, mysqlISP, mysqlIPM, and mysqlSendmail.

Our mysqlISP component systems focus is on a very stable telco quality ISP services via static configuration of servers from mySQL, but with mySQL not required to be live.

IAMBACKUP provides a set of classes for backing up and restoring a MySQL database.

IAM backup is package made of two classes. One performs the backup of the selected MySQL database, and the second restores the database.

Both classes support gzip-compressed files for improved performance. When performing the backup, the user is prompted to download the backup file, straight from the browser.

Alternately, the backup can be stored on the local server at a predefined location. Restoring the database (or copying it to another server) is just as easy.

cbMySQL is a PHP Class witch can create, alter, and modify MySQL databases and tables. For backup issues, you can export CSV data directly with only one class method.
The MySQL object is much easier to handle than PHPs built in functions, and theres no need to install anything like PEAR.
Enhancements:
- This version is completely compatible with PHP5 and mysqli.
- The mysql extension is still supported.
- Some bug were removed and examples were added.
- The licence was changed to the LGPL.

MySQL Backup for lazy sysadmins (mysqlblasy) is a Perl script for automating MySQL database backups. It uses "mysqldump" for dumping mysql databases to the files sytem. MySQL Backup for lazy sysadmins program was written with automated usage in mind.
For example, it is silent during operation, and only produces noise on errors/problems. It rotates backups automatically to prevent the backup disk from getting full when the administrator is on vacation (or is lazy).
Main features:
- syslog facility
- unix output (loglevels, errors to stderr)
- dump some or all databases from a database instance
- compress dumps (using gzip,bzip2 or perl modules)
- backup rotation to avoid disc overflow
- no shell on external commands!
- can be run as unpriviledged user
- perfect for cron jobs