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.
It
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
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
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
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 oth