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]

"Tyler Cruz" <tylercruz@hotmail.com> wrote in message
news:hhf_a.738405$Vi5.16855702@news1.calgary.shaw. ca...

> 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

"Eric Schwartz" <emschwar@pobox.com> wrote in message
news:etosmo6o1l6.fsf@wormtongue.emschwar...

> "Tyler Cruz" <tylercruz@hotmail.com> writes:

> > I was wondering how should I download the mySQL dump to my computer via

FTP?

> > ASCII or binary? Or does it matter?

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

> > Thanks a lot,

>
> Glad to help.
>
> -=Eric
> --
> Come to think of it, there are already a million monkeys on a million
> typewriters, and Usenet is NOTHING like Shakespeare.
> -- Blair Houghton.

[Ivan Marsh]

On Wed, 13 Aug 2003 00:05:33 +0000, Tyler Cruz wrote:

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

--
i.m.
The USA Patriot Act is the most unpatriotic act in American history.

[Eric Schwartz]

"Tyler Cruz" <tylercruz@hotmail.com> writes:

> 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
--
Come to think of it, there are already a million monkeys on a million
typewriters, and Usenet is NOTHING like Shakespeare.
-- Blair Houghton.

[Rob Petty]

(you will find my comments at the BOTTOM of the post...)
"Tyler Cruz" <tylercruz@hotmail.com> wrote in message news:tsS_a.728744$3C2.16990275@news3.calgary.shaw. ca...

> 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
>
> "Eric Schwartz" <emschwar@pobox.com> wrote in message
> news:etosmo6o1l6.fsf@wormtongue.emschwar...

> > "Tyler Cruz" <tylercruz@hotmail.com> writes:

> > > I was wondering how should I download the mySQL dump to my computer via

> FTP?

> > > ASCII or binary? Or does it matter?

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

> > > Thanks a lot,

> >
> > Glad to help.
> >
> > -=Eric
> > --
> > Come to think of it, there are already a million monkeys on a million
> > typewriters, and Usenet is NOTHING like Shakespeare.
> > -- Blair Houghton.

>
>

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]

Ivan Marsh wrote:

>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?

--
Bart.

[Alan J. Flavell]

On Thu, Aug 14, Ivan Marsh inscribed on the eternal scroll:

> 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]

In comp.lang.perl.misc Ivan Marsh <annoyed@you.now> wrote:

> On Wed, 13 Aug 2003 00:05:33 +0000, Tyler Cruz wrote:
>

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

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\
--
Jonathan Stowe |
<http://www.gellyfish.com> | This space for rent
|