> -----Original Message----- > From: Neil Tompkins [mailto:[EMAIL PROTECTED]]
> Can anyone recommend a software app. I could buy to be able > to dump data and > table structures to a text file. Ideally as mentioned before > I need to run > this on a hourly basis. Backing up the entire database on an hourly basis could be time- and processor-intensive, if the database gets large. I'd recommend backing up the full database at longer intervals (say, nightly) with mysqldump and then using the update log to fill in any gaps. If getting the backups onto a different machine is important you can always just copy the log. A backup plus all the update log entries since the backup was taken is sufficient to recover the database. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
