If you have ssh installed on your target machine couldn't you do the
following?
mysqldump <database> | scp <username>@<hostname>:.
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 <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,
--
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