TECTED]; [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
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
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 op
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
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
-