syntax problem with import DB in putty

  • Hey, I need to resubmit my DB. I am user RACK, the DB name is MYKICK and the file is MYKICK.SQL (164 megs) which is in my /rack.com directory
    In putty I am at the msql> prompt and been messing now for many painful hours and I can’t seem to get the syntax right. This is what I use and it fails

    mysql> -u rack -p mykick < /home/webmaster/rack.com/mykick.sql;

    SYNTAX ERROR!

    Thanx!

    kicker

Viewing 1 replies (of 1 total)
  • Moderator t-p

    (@t-p)

    Just clarify, are you trying to restore or backup db?

    to restore DB, try:
    mysql -u rack -p mykick < mykick.sql

    Put mykick.sql in the root of your website

Viewing 1 replies (of 1 total)
  • The topic ‘syntax problem with import DB in putty’ is closed to new replies.