Tweet
When saving a mysqldump .sql file onto my pc, is it better to save it as a binary or ascii file?
-
. -
i alway use AUTO.. you mean via ftp ?:: Always Back Up Forum Database + Attachments BEFORE upgrading !
:: Nginx SPDY SSL - World Flags Demo [video results]
:: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ] -
Since a SQL Dump is in fact an ASCII file, you should use ASCII.
Comment
-
Attachments are binary though, included in the SQL dump.Originally posted by OdysseusSince a SQL Dump is in fact an ASCII file, you should use ASCII.Comment
-
No. The actual SQL backup file itself is ASCII and needs to be transferred as ASCII.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Yes, I am refering to FTP.
I'm not using the backup tool inside vb.
I'm doing mysqldump via ssh. Then I use ftp to download the .sql files.
So is it confirmed that I should download them as ascii?
Thanks a lot..Comment
-
-
The binary attachments in the sql dump are escaped and represented as ASCII.Comment
Comment