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 <your user name> -p <password> samp_db | mysql -h <your > remote > host name or address> samp_db -u <your user name> -p <your password> > > 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 <mysql-unsubscribe- > [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