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?

Dont think it matters.

A MySQL dump is ASCII. MS-SQL can export to ASCII or Binary, depending on how you do it.

EDIT: If it's a .sql file, it's ASCII.