The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' started by basketmen, Sep 21, 2010.

  1. basketmen

    basketmen Well-Known Member

    Joined:
    Sep 9, 2010
    Messages:
    118
    Likes Received:
    0
    Trophy Points:
    16
    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?
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,474
    Likes Received:
    202
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
  3. basketmen

    basketmen Well-Known Member

    Joined:
    Sep 9, 2010
    Messages:
    118
    Likes Received:
    0
    Trophy Points:
    16
    hmm there is no exactly .sql file text there

    is it binary?
     
  4. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    Plain text files are transferred using ASCII mode and files like graphics files, spreadsheets, sound files etc are transferred in Binary mode. However, it is good to transfer the .sql file in Binary mode as well as it will keep the spaces and line endings intact.
     
Loading...

Share This Page