Projects tagged ‘backup’ and ‘mysql’

mylvmbackup is a Perl script for quickly creating backups of MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes ... [More] an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations, while the actual file backup proceeds. [Less]

Staggered import of large and very large MySQL Dumps (like phpMyAdmin 2.x Dumps) even through the web-servers with hard runtime limit and those in safe mode. The script executes only a small part ... [More] of the huge dump and restarts itself. The next session starts where the last was stopped. [Less]

Please go to the official project website for more information: http://www.mysql-mmm.org

These scripts allow you to export and back-up your MySQL databases to Amazon's S3 Storage.

Backup System

Easy PHP Backup is a ph class designed to simplify the creation of full backups of your mysql database. Using this class you can create and schedulate backup of your database with very few lines of php code.

mysqlbackup uses mysqldump to make a backup of all databases or a single database and compress the backup and optionally saves it to a remote location using scp

On first run this script will detect auto-incremental columns from the database tables, store it's max(value) into a special file called point file, and on the next runs will run mysqldump with ... [More] --where param auto-incremental column > last max(value). As output is small, it's a perfect candidate to send the incremental backups to some email every some hours. It's not a replacement for full backups or for binary logs. It cannot detect deleted or updated rows. [Less]

Automated backup of your files and mysql-DBs and optimization of your DBs.

phpMyImporterphpMyImporter is a php class, that can be used to import database tables into a MySQL database from a sql file. This is useful if filesize of the sql file is too large to be imported with ... [More] phpMyAdmin. TodoVersion History1.00: (2009-10-26) Initial release Support for compressed sql files Support for UTF-8 connections Progress information [Less]