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

Discussion in 'Site & Server Administration' started by basketmen, Sep 21, 2010.

  1. #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?
     
    basketmen, Sep 21, 2010 IP
  2. AnthonyG

    AnthonyG Well-Known Member

    Messages:
    114
    Likes Received:
    3
    Best Answers:
    2
    Trophy Points:
    135
    #2
    ssh shell:
    ftp newip
    login
    bin
    put

    Use binary in this case as you will most likely have non-english char's coding in a sql file.
     
    AnthonyG, Sep 21, 2010 IP