You could just ftp them wherever you want for storage. I made a simple script where I took the provided "mysqlhotcopy" script, added it and used it every day as a cron to make a copy of all my databases, then run through a check of each one then tar them all up and ftp them to a remote server.
Its been running without a flaw for about 6 months now so personally I think its a good solution to archiving. -Chris >> -----Original Message----- >> From: Ahmed S K Anis [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, February 18, 2003 5:52 AM >> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; >> [EMAIL PROTECTED] >> Subject: Archive on remote Machine. >> >> >> Hi, >> I use Select * into outfile "filepath" from table to archive the >> database. >> Is there any way to archive this into a different machine. (Not current >> machine) >> >> Yes Mapping to new machine and then giving path is an option. Any other >> opton.? >> Anis >> >> >> >> --------------------------------------------------------------------- >> 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 >> >> >> >> --------------------------------------------------------------------- >> 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 --------------------------------------------------------------------- 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
