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?
You can use phpmyadmin to upload and import the sql file. You won't need to worry about mode this way.
ZA's advice is correct for as far as it goes. What will be missing will be ALL the website files, all the e-mail and the authentication information for the database (user permissions) from the db. cPanel is designed to move it all. I stand by my advice above.
SQL files are ascii - but you should be using cPanel to move EVERYTHING for you.