Results 1 to 2 of 2

Thread: Problem with importing mysql table

  1. #1
    Join Date
    Aug 2005
    Beans
    1

    Question Problem with importing mysql table

    Hi, I'm trying to import the wikipedia database in my Mysql installation for a project. I have this strange error:
    Code:
    ERROR 1064 (42000) at line 4: 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 '-------------------------------------------------------
    
    
    DROP TABLE IF EXIS' at line 1
    Here's the head of the file:

    Code:
    -- MySQL dump 8.23
    --
    -- Host: 10.0.0.240    Database: enwiki
    ---------------------------------------------------------
    -- Server version	4.0.40-wikimedia-log
    
    --
    -- Table structure for table `pagelinks`
    --
    
    DROP TABLE IF EXISTS `pagelinks`;
    What is the problem?
    Nobody on the internet has this problem, so I don't really know what I can do to fix it.

    Thanks in advance!
    Cristian

  2. #2
    Join Date
    Mar 2008
    Beans
    4,714
    Distro
    Ubuntu 9.10 Karmic Koala

    Re: Problem with importing mysql table

    On line 4, put a space after the first two hypens.

    See http://dev.mysql.com/doc/refman/5.1/en/comments.html

Tags for this Thread

Bookmarks

Posting Permissions

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