data copy from mysql to samba server

Zafermalik · 07-18-2011, 11:42 AM

Can anyone help me how i can copy data from mysql server to local system or samba server. I want to know the command.

Thanks,
Zafar

acid_kewpie · 07-18-2011, 12:02 PM

what does that mean?? How would you copy data from a database to a file system? do you just want to look at mysqldump??

TB0ne · 07-18-2011, 12:03 PM

Quote:

Originally Posted by Zafermalik

Can anyone help me how i can copy data from mysql server to local system or samba server. I want to know the command.

There isn't one. MySQL is a database engine. Samba is a network sharing protocol.

You can export data from MySQL using the mysqldump command, and COPY it to a Samba share, for use with another database. You COULD edit your MySQL config and move the database file(s) to a Samba share (but that would NOT be a good thing...very poor performance).

Your question is vague. Provide more details, tell us what your goal is, and perhaps we can help.

Zafermalik · 07-18-2011, 12:09 PM

Quote:

Originally Posted by acid_kewpie

what does that mean?? How would you copy data from a database to a file system? do you just want to look at mysqldump??

I have dumped data through mysql dump in linux mysql system and now want to copy/move this .sql backup file from mysql server to my local system. Please help me through which command i can do it.

acid_kewpie · 07-18-2011, 12:14 PM

I would download winscp and connect to the server that way and pull the file out, not push it.

TB0ne · 07-18-2011, 05:06 PM

Quote:

Originally Posted by Zafermalik

I have dumped data through mysql dump in linux mysql system and now want to copy/move this .sql backup file from mysql server to my local system. Please help me through which command i can do it.

That's like asking "how high is up?". You don't say what you've got available on the Windows system, if you want to script this and/or automate it, or if you want to do it manually. Again, with no details, you can get no answers.

If it was me, I'd share a folder on the Windows box, and use the "net" command in Linux to attach to it (read the man page on the net command). A simple script to attach, copy the file, and detach would be trivial.