|
|
|
#!/usr/bin/perl
$now = time;
$directory = "/home/user/backups";
# these are the databases I back up
@databases = ("mysql", "accounts", "data");
foreach $database (@databases) {
$backup = "mysqldump \-\-add-drop-table -u user -ppass $database";
$zip = "| gzip > $directory/$database.$now.gz";
system("$backup $zip");
# This stays commented, because I don't want to restore to the test
# databases all the time.
# unless($database eq "mysql") {
# $restore = "|mysql -u user -ppass test_$database";
# system("$backup $restore");
# }
}
# This allows me to keep 7 copies of the backups at all times.
# They also get backed up to tape, but this is more convenient for me.
opendir BACKUPS, $directory;
foreach $file (readdir BACKUPS) {
if(-M "$directory/$file" > 6) {
unlink "$directory/$file";
}
}
|
|
| bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | PHP Object Example of the Perl DBI with MySQL
Categories : PHP, PHP Classes, MySQL, Databases, Perl | | | using a perl script to perform a mysql query
Categories : MySQL, Perl | | | Point and Click Interface ala MS Access for creating SQL statements.
Categories : MySQL, Complete Programs, General SQL, PHP, Databases | | | MySQL wrapper class (PHP 5+ only)
Categories : MySQL, Databases, Classes and Objects, Object Oriented | | | PHP4 MYSQL Authentication Script with cookie. Short & Sweet
Categories : Authentication, Apache, Cookies, PHP, MySQL | | | Message of the Day - Random Message (Needs MySQL!)
Categories : Databases, HTML and PHP, PHP, MySQL | | | Retrieve text from table and email to your e-
address in pipe delimited format.
Categories : PHP, MySQL | | | Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs.
Categories : Databases, PHP, MySQL, Complete Programs | | | a function that builds an HTML select list from any mysql table.
Categories : PHP, MySQL, HTML and PHP | | | phpAds, a complete banner and ad management system with detailled tracking and stats.
Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases | | | color codes for positive and negative numbers
Categories : PHP, MySQL, Databases, HTML | | | email new items in db
Categories : PHP, Email, Databases, MySQL, Beginner Guides | | | Alternating background color for HTML table rows
Categories : PHP, Databases, MySQL, HTML and PHP | | | Automatically printing the contents of an sql table in MySQL.
Categories : MySQL, PHP, HTML and PHP, Databases | |
|
|
|
