Results 1 to 6 of 6
  1. #1

    Importing a .gz file via SSH

    Is it possible to import a .gz file via SSH?

    I was looking at a documentation and it said i have to upload the SQL file, but my sql file is HUGE. It'll probably take me 5 hours to upload, and knowing my luck it'll time out or something.

  2. #2
    Join Date
    Feb 2004
    mysqldump -uuser -ppassword database | gzip > database.gz

  3. #3
    I've done that and extract the file so the sql file is there. But it doesn't seem to be working, i recieved this error when i had to enter my password to begin the restore process

    ERROR 1045: Access denied for user: [email protected]' (Using password: YES)
    -jailshell: syntax error near unexpected token `('

    Note: This is the first time i'm using SSH so i may have done something wrong. The program i'm using is Putty.

  4. #4
    Join Date
    Jul 2004
    That means the username and password combination you used is incorrect.

    Bare in mind that this should be your SQL username and password, not your SSH username and password.

  5. #5
    Join Date
    Dec 2002
    chica go go
    gzip -d file.gz
    mysql -u you -p databasename < file(without .gz)
    (enter pass and hit enter)
    (wait for a while)
    (return to shell)

  6. #6
    Join Date
    Dec 2004

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts