Extremely Basic mySQL question.

[Tyler Cruz]

Hi,

I was wondering how should I download the mySQL dump to my computer via FTP?
ASCII or binary? Or does it matter?

Thanks a lot,

Tyler

 

[Gregory Toomey]

Hi,

I was wondering how should I download the mySQL dump to my computer via FTP?
ASCII or binary? Or does it matter?

Thanks a lot,

Tyler

Try both! I use binay. The ascii option is there because of different line
termination characters in different operating systems.

gtoomey

 

[Tyler Cruz]

lol.. you need to get a life man. I did try both ways but wasn't sure..
maybe there was some bad characters that got in.. so i was asking to make
sure

don't you have anything better to do than just flame? life it TOO short
man.. hope you have a good day

Tyler

 

[Ivan Marsh]

Hi,

I was wondering how should I download the mySQL dump to my computer via
FTP? ASCII or binary? Or does it matter?

Thanks a lot,

Tyler

Typically all FTP transfers are binary these days. There's no reason, that
I know of anyway, to use ASCII transfer specificly.

 

[Eric Schwartz]

lol.. you need to get a life man. I did try both ways but wasn't sure..
maybe there was some bad characters that got in.. so i was asking to make
sure

So you check.

don't you have anything better to do than just flame? life it TOO short
man.. hope you have a good day

Too short for clpm to become flooded with tons of irrelevant questions
because people like you can't be arsed to actually find a relevant
newsgroup.

-=Eric

 

[Rob Petty]

(you will find my comments at the BOTTOM of the post...)

lol.. you need to get a life man. I did try both ways but wasn't sure..
maybe there was some bad characters that got in.. so i was asking to make
sure

don't you have anything better to do than just flame? life it TOO short
man.. hope you have a good day

Tyler

Okay, unlike the MLDBM question, this one actually has bugger-all to
do with Perl. But since some people somehow think clpm should be a
haven to answer all questions, no matter what they have to do with the
actual topic of the newsgroup, I'll be helpful anyway:

If I were you, I'd try one, and then if it didn't work, I'd try the
other. You know, if you had just tried, you probably would have
already found out by now, and wouldn't have had to wait. Trying isn't
fatal, you know.


Glad to help.

-=Eric

He doesn't need to get a life, you need to get another group. Try mailing.database.mysql!

Your post is off topic. No one here really deals with the issue since this is a PERL group. MySQL is a different product
(programming language vs database). You using Net::FTP?.... Still doesn't matter. The question is Still a MySQL question. Not
a Perl issue.

The issue really comes down to whether you're dumping blob data or not. If not then it really doesn't matter. If so, then you
better stick with binary.

Rob

 

[Bart Lateur]

Typically all FTP transfers are binary these days. There's no reason, that
I know of anyway, to use ASCII transfer specificly.

The fact that fields might contain CR characters after import? Or none,
where there originally were?

 

[Alan J. Flavell]

Typically all FTP transfers are binary these days. There's no reason, that
I know of anyway, to use ASCII transfer specificly.

That's the trouble with off-topic posts, they often contain
misinformation.

 

[Jonathan Stowe]

Typically all FTP transfers are binary these days. There's no reason, that
I know of anyway, to use ASCII transfer specificly.

So when the manpage for ftp client says:

type [type-name]
Set the file transfer type to type-name. If no type is speci­
fied, the current type is printed. The default type is net­
work ASCII.


it is lying then? Right.

/J\