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
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
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
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
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