Ask Josephsen wrote:No need to use an ftp server on the PC.> The smartest would probably be to export the data with mysqldump -
> unfortunately my space left on the server is not enough, so I need to
> export the data to another computer. Here the question is, can I export
> it to my windows pc? It seems mysqldump can connect to a host (--host)
> so would it work if I set up an ftp-server at my local pc?
What I'd do is run the mysqldump utility on Windows, and specify the
hostname of your Linux server with the --host option. Then the output
of the mysqldump command can be written very easily on the Windows drive.
You might also reduce the volume of data going over the network, by
using mysqldump's --compress option.
You can use smbmount on the Linux box to mount a Windows share (similar> Another
> possibilty might be, I have a ssh connection to the linux server, maybe
> its possible to use this? Or can mysqldump pipe onto a shared windows
to what called "mapping a drive" on Windows). Then you could run
mysqldump on Linux and write its output to the Windows share via the
But I'd still prefer the solution above, since SMB is a notoriously