4 {{ upvoteCount | shortNum }}
4 {{ upvoteCount | shortNum }}

MYSQL command line syntax error

by Michael Travis
3 replies
I have beat my head against the wall on this. I am loging in as the root user on a dedicated server hosted by Hostgator. Once logged in through the terminal program I type in mysql at the command line and get
mysql>

I then type in the following at that mysql prompt
--key_buffer_size=384M;

Just like the darn book shows. The I get a reply of: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--key_buffer_size=384M' at line 1

Can anyone tell me what I am doing wrong?

Thanks,

Michael
#command #error #line #mysql #syntax
  • Profile picture of the author ALicenseToCode
    It should be the semicolon at the end causing your error, try issuing the command :

    mysqld --key_buffer_size=384M --verbose --help

    From shell> That should change it and give you a lot of information about the change and if it was applied successfully. That's always worked fine on my servers in the past, but if it doesn't send hostgator a ticket and ask them to do it and send you the shell command they did it with. They will usually oblige simple requests, especially for dedicated server customers.
    {{ DiscussionBoard.errors[6725625].message }}
  • Profile picture of the author brianng
    Drop that book. Those settings should be in my.cnf
    Most used cmd should be mysql mysqldump, mysqlbinlog, reset master, reset slave
    Some books went too far into those unnccessary stuffs..
    {{ DiscussionBoard.errors[6747534].message }}
    • Profile picture of the author krialex
      What is your operating system?
      {{ DiscussionBoard.errors[6748546].message }}

Trending Topics