Forum Moderators: phranque

Message Too Old, No Replies

Want to restore db,upload the .sql file to new host using ftp, using ASCII or binary?

         

basketmen

10:30 am on Sep 21, 2010 (gmt 0)

10+ Year Member



guys i want to move to another host, i already backup the mysql using ssh and get the .sql file, downloading to computer, and i want to uploading to new host using ftp and restore it there using ssh too

my question is in uploading to new host using ftp part, do i need using ASCII mode or binary mode when uploading the .sql file?

jdMorgan

4:05 pm on Sep 21, 2010 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I would definitely opt for binary in this case, in case there are any non-character 'codes' in your database.

Jim