1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 importing db with ssh

Discussion in 'Troubleshooting and Problems' started by Ian S, Nov 21, 2014.

  1. Ian S

    Ian S Active Member

    hi all im stuck again, now last night after the problem with a import i deleted the table in the db, i then tried to get the dump that i had back onto the db but i got a timeout error, so i contacted the host and he said to use ssh cli, i downloaded putty for windows and i cant get it to work, i uploaded the db dump to the server and the host gave me the line to use for the life of me i cant get it to work, sorry for asking but ive checked google and on here before posting i tried using the cli on winscp but all i get is errors, thanx anyone that can help here my sql line

    mysql -u **** -p**** /etc/psa/.psa.shadow` --default_character_set utf8 <DB name> < <filename.sql>
     
  2. Liam W

    Liam W Well-Known Member

    What errors is it giving you?

    Are you running the command in the same directory as the file?

    Liam
     
  3. Ian S

    Ian S Active Member

    sorry i get this running from the directory the sql file is
    500 MYSQL not understood

    using cli on winscp
     
  4. Liam W

    Liam W Well-Known Member

    Could you screenshot the full error message and the command?

    (Blank out any sensitive information)

    Liam
     
  5. Ian S

    Ian S Active Member

    does the command look good above matey
     
  6. Ian S

    Ian S Active Member

    cant get putty to work not sure why is the cli on winscp good enough boss??

    500 MYSQL not understood

    i get this after i execute the command line above
     
  7. Ian S

    Ian S Active Member

    here mate
     

    Attached Files:

    • cli.jpg
      cli.jpg
      File size:
      58.7 KB
      Views:
      12
  8. Liam W

    Liam W Well-Known Member

    Don't put the table and file names in the chevrons.

    Liam
     
  9. Ian S

    Ian S Active Member

    table? how should it look mate
     
  10. Ian S

    Ian S Active Member

    ive tried removing chevs didnt work
     
  11. Ian S

    Ian S Active Member

    pishing me off whatever i do i get same 500 error
     
  12. MattW

    MattW Well-Known Member

    /etc/psa/.psa.shadow suggest you are running in the plesk environment, and using that for the root password. That won't work on localhost xamp
     
  13. Ian S

    Ian S Active Member

    roger that lol, yes its a plesk panel but im not using it to access ssh,

    im using winscp cli matt, how would your command line read if i was in root or root is /httpdocs/ obviously its not the root threw the admin root though
     
  14. MattW

    MattW Well-Known Member

    I do it slightly differently.

    I connect to MySQL

    mysql -u root -p

    Once in there, choose the database you want to import into

    use databasename;

    and then import with

    source /full/path/to/sql/file.sql;
     
  15. Ian S

    Ian S Active Member

    thanx mate so for example if i open winscp and open the cli in the root how do i connect to mysql ill give it a try matey
     
  16. MattW

    MattW Well-Known Member

    What is the exact command you are using now that isn't working? Liam has already told you to remove the <> around the database name and the file name. You still need to include the single < to tell MySQL to import the sql file. You also need to either be in the same directory as the file, or specify the full directory path to it.
     
  17. Ian S

    Ian S Active Member

    cool yep ill try it 2morrow was just checking winscp 5 cli works as well as anything else really as i cant get putty to except the server password, the keyboard dont seem to type anything but the return key works :confused::confused::confused::confused::confused:

    ill report back later as it currently 1.15am in the UK(y)
     
  18. MattW

    MattW Well-Known Member

    I know ;) I'm in Sheffield
     
  19. Ian S

    Ian S Active Member

    pmsl;)

    take it easy fella thanx for everyones advice ill report 2morrow (y)
     
    MattW likes this.
  20. Ian S

    Ian S Active Member

    ok nothing worked i dont think the shell is working correctly on the winscp, i tried my xmapp version for my offline site and just typing mysql bought it straight up, ill have to find where its located on the server i think, please help anyone im loosing hair:cry::cry:
     

Share This Page