homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / WebmasterWorld / Webmaster General
Forum Library, Charter, Moderators: phranque

Webmaster General Forum

Download .sql file in ASCII or Binary Mode?

10+ Year Member

Msg#: 4975 posted 5:55 am on Mar 17, 2004 (gmt 0)

We have a dump.sql file which is a daily backup from the database on our UNIX server. I then download the dump.sql file to my local Windows computer. My question is: Do I download it in ASCII or Binary mode? I used to download it in ASCII mode. But then I found the following instructions from WS_FTP:

Binary mode is used for transferring files that are not text (ASCII files). Executable programs, word processing documents, spreadsheets, databases, graphics files, and sound files are some examples of files that must be transferred in binary mode.

So what do the experts say?



WebmasterWorld Administrator coopster us a WebmasterWorld Top Contributor of All Time 10+ Year Member

Msg#: 4975 posted 1:47 pm on Mar 18, 2004 (gmt 0)

If the sql is just standard text, it will download fine in ASCII. I often tend to use binary transfer though, just because it keeps line endings and other whitespace intact when moving from one OS to another (bringing a UNIX generated text file down to a Windows or MAC development platform). It will still open just fine in any text editor.

Global Options:
 top home search open messages active posts  

Home / Forums Index / WebmasterWorld / Webmaster General
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved