basketmen — 2010-09-21T06:26:17-04:00 — #1
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?
zarvixe — 2010-09-26T11:36:53-04:00 — #2
You can use phpmyadmin to upload and import the sql file. You won't need to worry about mode this way.
dklynn — 2010-09-26T17:48:39-04:00 — #3
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.
dklynn — 2010-09-21T07:52:15-04:00 — #4
SQL files are ascii - but you should be using cPanel to move EVERYTHING for you.