Pada Sun, 7 Jul 2002 17:53:08 +0500
"Impex Holidays Maldives / Hasan" <[EMAIL PROTECTED]> menulis :
> Hi,
>
> This may be out of topic,but still I'm working on a mysql back up file.
> Does any one have a shell script to ftp a file to another location, so that I can
>schedule to run this file with cron.
>
> Many thanks,
> Hasan
1. you can use replication configuration, but not running it as "real time"
replication ...
your cronjob just do "load table <tablename> from master"
2. your cronjob do
mysqldump -> ftp
3. or just ftp the data ... but you'll have table error/corrupt for result.
;-)
--
Linux! Guerrilla UNIX Development Venimus, Vidimus, Dolavimus.
-- Mark A. Horton KA4YBR, [EMAIL PROTECTED]
MySQL 3.23.51 : up 16 days, Queries : 368.371 per second (avg).
---------------------------------------------------------------------
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