RE: Archive on remote Machine.
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
Re: Archive on remote Machine.
If you have ssh installed on your target machine couldn't you do the following? mysqldump | scp @:. KH Chiu wrote: It will then be a networking problem. As far as I know, you may need a networking file system like NFS or Samba. You should mount your remote machine as a network drive. Then you can use mysqldump to make a backup but redirect the output to the network drive. There may be other methods. In fact, I have a project that has more complex remote backup requirement. I am working on it using C right now but not yet completed. Regards, Thanx for the suggestion. Is there any way i can Archive data to remote machine where MySQL is not installed. Anis "KH Chiu" <[EMAIL PROTECTED]> Wednesday, February 19, 2003 8:46:46 AM >>> You may try the following command mysqldump -u -p samp_db | mysql -h remote host name or address> samp_db -u -p Please also note that samp_db must be exist on your remote machine. Of course, you should sub. samp_db with your to be achieve database name. Regards, -- Charles Lewis Reliable Computer Services [EMAIL PROTECTED] - 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
Re: Archive on remote Machine.
It will then be a networking problem. As far as I know, you may need a networking file system like NFS or Samba. You should mount your remote machine as a network drive. Then you can use mysqldump to make a backup but redirect the output to the network drive. There may be other methods. In fact, I have a project that has more complex remote backup requirement. I am working on it using C right now but not yet completed. Regards, > Thanx for the suggestion. > Is there any way i can Archive data to remote machine where MySQL is > not installed. > > Anis > > > >>> "KH Chiu" <[EMAIL PROTECTED]> Wednesday, February 19, 2003 > 8:46:46 AM >>> > You may try the following command > > mysqldump -u -p samp_db | mysql -h remote > host name or address> samp_db -u -p > > Please also note that samp_db must be exist on your remote machine. Of > > course, you should sub. samp_db with your to be achieve database name. > > Regards, > > > 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 > > -- > Yours, > KH Chiu > C&A Computer Consultants Ltd. > Tel: 3104 2070 Fax: 3010 0896 > Email: [EMAIL PROTECTED] > Website: www.caconsultant.com > > - > 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 -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com - 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
Archive on remote Machine .
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). Also Note the target machibe does not have MySQL installed. Yes Mapping to new machine and then giving path is an option. Any other opton.? >>> Victoria Reznichenko <[EMAIL PROTECTED]> Tuesday, February 18, 2003 7:15:01 PM >>> On Tuesday 18 February 2003 12:51, Ahmed S K Anis wrote: > 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.? You can't use SELECT .. INTO OUTFILE for this. Use for example mysqldump program. For more info look at: http://www.mysql.com/doc/en/SELECT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
Re: Archive on remote Machine.
You may try the following command mysqldump -u -p samp_db | mysql -h samp_db -u -p Please also note that samp_db must be exist on your remote machine. Of course, you should sub. samp_db with your to be achieve database name. Regards, > 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 > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com - 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
re: Archive on remote Machine.
On Tuesday 18 February 2003 12:51, Ahmed S K Anis wrote: > 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.? You can't use SELECT .. INTO OUTFILE for this. Use for example mysqldump program. For more info look at: http://www.mysql.com/doc/en/SELECT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
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