Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2011
    Posts
    9

    Unanswered: Importing SQL dump ERROR in Syntax TYPE=MyISAM

    Guys can anybody point me in the right direction for resolving this? I am recieving Error in Syntax on TYPE=MyISAM for my import.

    I am migrating a journals server to a new server and need to get this done.

    Thanks in advance.
    -Mike

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by OpK View Post
    I am recieving Error in Syntax on TYPE=MyISAM for my import.
    did you check the syntax in the manual like the error message said you should?

    if you had, you would've seen that it's engine=myisam, not type=myisam

    dat manual, she be so helpful
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2011
    Posts
    9
    Making the change from TYPE to ENGINE did the trick but I did see some import errors.

    Thanks
    -Mike

  4. #4
    Join Date
    Jun 2011
    Posts
    9
    WAEFRTFM ... yes very helpful.

Posting Permissions

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