From: MySQL Database Backup
[db_backup@thishost.com]
Sent: Wed, 10 Mar 2004 00:07:57 -0800
Received: Wed, 10 March 2004
09:08 +0100
To: webmaster@thishost.com
Subject: MySQL Backup on
www.thishost.com of Wed 10. March 2004
Importance: Low
Expires: Wed, 17 March 2004
08:08 +0000
MySQL database backup $Revision: 1.3 $
Copyright (c) 2003, 2004 by Alain Wolf, Zurich - Switzerland
Website: http://restkultur.ch/personal/wolf/scripts/db_backup/
----------------------------------------------------------------------
PHP 4.3.4 - SAPI: cli - OS: Linux - PHP Safe-Mode: Off
----------------------------------------------------------------------
Starting backup on www.thishost.com
Wednesday 10. March 2004 00:00 PST
----------------------------------------------------------------------
Configuration Settings:
Backup to: /home/bill/db_backup
Weekly Backup: No
Monthly Backup: No
Keeping daily backups for 7 days
Keeping weekly backups for 4 weeks
Keeping monthly backups for 3 months
Archiving SQL files: Yes
Archive filename prefix: www_
Remove SQL-files after archiving: Yes
Compress archive-file: Yes
Send reports by email: Yes
Send backup archive by email: No
Send email message to: webmaster@restkultur.ch
Upload backup archive to FTP server: Yes
FTP server address: backup.otherhost.org
FTP server username: bill
FTP upload pathname: /uploads/db_backup/
----------------------------------------------------------------------
00:00:02: Diskspace used by MySQL database backup files: 12.9 MB
----------------------------------------------------------------------
00:00:02: Beginning backup of MySQL database bills_DB ...
----------------------------------------------------------------------
Current database settings:
MySQL Server: localhost
MySQL User: bill
Excluded tables: *_test phpbb_* pma_* phpmyadmin
Add "drop table" statements: Yes
All Tables in single SQL file: No
----------------------------------------------------------------------
00:00:02: Connecting to database server ...
MySQL Server: Localhost via UNIX socket
MySQL Server Version: 4.0.17-Max
----------------------------------------------------------------------
00:00:02: Database storage size is 2.5 MB
00:00:04: 22 tables found.
00:00:04: 1 tables excluded from backup.
----------------------------------------------------------------------
00:00:05: Extracting previous archive www_bills_DB.tar.gz ...
00:00:12: Archive extraction successfull.
00:00:12: Previous archive file deleted.
----------------------------------------------------------------------
00:00:12: Starting backup of table bills_DB.adr ...
00:00:13: Creating backup file days/adr.2004-03-10.sql ...
00:00:13: Deleting old daily backup file days/adr.2004-03-03.sql.
00:00:13: Backup of table bills_DB.adr finished.
----------------------------------------------------------------------
00:00:13: Table adr_test is excluded from backup.
----------------------------------------------------------------------
00:00:13: Starting backup of table bills_DB.apb1_board_news ...
00:00:13: Creating backup file days/apb1_board_news.2004-03-10.sql ...
00:00:13: Deleting old daily backup file days/apb1_board_news.2004-03-03.sql.
00:00:13: Backup of table bills_DB.apb1_board_news finished.
----------------------------------------------------------------------
00:00:13: Starting backup of table bills_DB.apb1_boards ...
00:00:13: Creating backup file days/apb1_boards.2004-03-10.sql ...
00:00:13: Deleting old daily backup file days/apb1_boards.2004-03-03.sql.
00:00:13: Backup of table bills_DB.apb1_boards finished.
----------------------------------------------------------------------
00:00:13: Starting backup of table bills_DB.apb1_chat ...
00:00:13: Creating backup file days/apb1_chat.2004-03-10.sql ...
00:00:13: Deleting old daily backup file days/apb1_chat.2004-03-03.sql.
00:00:13: Backup of table bills_DB.apb1_chat finished.
----------------------------------------------------------------------
00:00:13: Starting backup of table bills_DB.apb1_config ...
00:00:13: Creating backup file days/apb1_config.2004-03-10.sql ...
00:00:13: Deleting old daily backup file days/apb1_config.2004-03-03.sql.
00:00:13: Backup of table bills_DB.apb1_config finished.
----------------------------------------------------------------------
00:00:13: Starting backup of table bills_DB.apb1_posts ...
00:00:14: Creating backup file days/apb1_posts.2004-03-10.sql ...
00:00:14: Deleting old daily backup file days/apb1_posts.2004-03-03.sql.
00:00:14: Backup of table bills_DB.apb1_posts finished.
----------------------------------------------------------------------
00:00:14: Starting backup of table bills_DB.apb1_statistik ...
00:00:14: Creating backup file days/apb1_statistik.2004-03-10.sql ...
00:00:14: Deleting old daily backup file days/apb1_statistik.2004-03-03.sql.
00:00:14: Backup of table bills_DB.apb1_statistik finished.
----------------------------------------------------------------------
00:00:14: Starting backup of table bills_DB.apb1_threads ...
00:00:14: Creating backup file days/apb1_threads.2004-03-10.sql ...
00:00:14: Deleting old daily backup file days/apb1_threads.2004-03-03.sql.
00:00:14: Backup of table bills_DB.apb1_threads finished.
----------------------------------------------------------------------
00:00:14: Starting backup of table bills_DB.apb1_user_table ...
00:00:14: Creating backup file days/apb1_user_table.2004-03-10.sql ...
00:00:14: Deleting old daily backup file days/apb1_user_table.2004-03-03.sql.
00:00:14: Backup of table bills_DB.apb1_user_table finished.
----------------------------------------------------------------------
00:00:14: Starting backup of table bills_DB.apb1_useronline ...
00:00:14: Creating backup file days/apb1_useronline.2004-03-10.sql ...
00:00:14: Deleting old daily backup file days/apb1_useronline.2004-03-03.sql.
00:00:14: Backup of table bills_DB.apb1_useronline finished.
----------------------------------------------------------------------
00:00:14: Starting backup of table bills_DB.calendar ...
00:00:15: Creating backup file days/calendar.2004-03-10.sql ...
00:00:15: Deleting old daily backup file days/calendar.2004-03-03.sql.
00:00:15: Backup of table bills_DB.calendar finished.
----------------------------------------------------------------------
00:00:15: Starting backup of table bills_DB.jgb_entries ...
00:00:15: Creating backup file days/jgb_entries.2004-03-10.sql ...
00:00:15: Deleting old daily backup file days/jgb_entries.2004-03-03.sql.
00:00:15: Backup of table bills_DB.jgb_entries finished.
----------------------------------------------------------------------
00:00:15: Starting backup of table bills_DB.jgb_settings ...
00:00:15: Creating backup file days/jgb_settings.2004-03-10.sql ...
00:00:15: Deleting old daily backup file days/jgb_settings.2004-03-03.sql.
00:00:15: Backup of table bills_DB.jgb_settings finished.
----------------------------------------------------------------------
00:00:15: Starting backup of table bills_DB.jgb_smilies ...
00:00:15: Creating backup file days/jgb_smilies.2004-03-10.sql ...
00:00:15: Deleting old daily backup file days/jgb_smilies.2004-03-03.sql.
00:00:15: Backup of table bills_DB.jgb_smilies finished.
----------------------------------------------------------------------
00:00:15: Starting backup of table bills_DB.linkster_cats ...
00:00:15: Creating backup file days/linkster_cats.2004-03-10.sql ...
00:00:15: Deleting old daily backup file days/linkster_cats.2004-03-03.sql.
00:00:15: Backup of table bills_DB.linkster_cats finished.
----------------------------------------------------------------------
00:00:15: Starting backup of table bills_DB.linkster_links ...
00:00:15: Creating backup file days/linkster_links.2004-03-10.sql ...
00:00:15: Deleting old daily backup file days/linkster_links.2004-03-03.sql.
00:00:15: Backup of table bills_DB.linkster_links finished.
----------------------------------------------------------------------
00:00:15: Starting backup of table bills_DB.phpMyAdmin ...
00:00:15: Creating backup file days/phpMyAdmin.2004-03-10.sql ...
00:00:15: Deleting old daily backup file days/phpMyAdmin.2004-03-03.sql.
00:00:15: Backup of table bills_DB.phpMyAdmin finished.
----------------------------------------------------------------------
00:00:15: Starting backup of table bills_DB.sitenews ...
00:00:15: Creating backup file days/sitenews.2004-03-10.sql ...
00:00:15: Deleting old daily backup file days/sitenews.2004-03-03.sql.
00:00:15: Backup of table bills_DB.sitenews finished.
----------------------------------------------------------------------
00:00:15: Starting backup of table bills_DB.sm_address ...
00:00:15: Creating backup file days/sm_address.2004-03-10.sql ...
00:00:15: Deleting old daily backup file days/sm_address.2004-03-03.sql.
00:00:15: Backup of table bills_DB.sm_address finished.
----------------------------------------------------------------------
00:00:15: Starting backup of table bills_DB.sm_userprefs ...
00:00:15: Creating backup file days/sm_userprefs.2004-03-10.sql ...
00:00:15: Deleting old daily backup file days/sm_userprefs.2004-03-03.sql.
00:00:15: Backup of table bills_DB.sm_userprefs finished.
----------------------------------------------------------------------
00:00:15: Starting backup of table bills_DB.useronline ...
00:00:15: Creating backup file days/useronline.2004-03-10.sql ...
00:00:15: Deleting old daily backup file days/useronline.2004-03-03.sql.
00:00:15: Backup of table bills_DB.useronline finished.
----------------------------------------------------------------------
00:00:15: Backup of database bills_DB finished.
00:00:15: Looking for outdated SQL files ...
----------------------------------------------------------------------
00:00:15: Archiving SQL files in www_bills_DB.tar.gz ...
00:00:28: Archiving succesfull.
----------------------------------------------------------------------
00:00:28: Removing SQL-files ...
00:00:28: Removed 126 in 1 directories.
00:00:28: Removed 84 in 1 directories.
00:00:28: Removed 62 in 1 directories.
00:00:28: Directory "bills_DB" removed.
----------------------------------------------------------------------
00:00:28: Backup for database bills_DB completed with 0 errors.
----------------------------------------------------------------------
00:00:28: Uploading archive files to FTP Server ...
00:00:28: Successfully connected to backup.otherhost.org
00:00:29: Username "bill" and password accepted!
00:00:29: Changed directory to /uploads/db_backup on FTP server.
00:00:30: Starting upload of www_bills_DB.tar.gz ...
00:07:57: Upload of www_bills_DB.tar.gz successfull
----------------------------------------------------------------------
00:07:57: Diskspace used by MySQL database backup files: 13 MB
----------------------------------------------------------------------
00:07:57: Backup completed with 0 errors.
Have a nice day!