Installation problem

Help
Walzilla
2006-02-10
2013-04-08
  • Walzilla
    Walzilla
    2006-02-10

    I  cant install phpMyWap on mi linux system, whe i try to load into database the sql archive i have the next error paga on my phpMyAdmin:

    SQL-query:

    -- MySQL dump 8.23
    --
    -- Host: mysql4-p Database: p115906_phpmywap
    ------------------------------------------------------- --
    -- Server version 4.1.10a
    --
    -- Table structure for table `file`
    --
    CREATE TABLE `file` (
    id mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
    datatype varchar( 60 ) NOT NULL default 'application/octet-stream',
    name varchar( 120 ) NOT NULL default '',
    description varchar( 250 ) default NULL ,
    `type` varchar( 20 ) default NULL ,
    size bigint( 20 ) unsigned NOT NULL default '1024',
    filedate datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY ( id )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1

    MySQL said: Documentation
    #1064 - 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 '---------------------------------------------------------
    -- Se

    how can i fix the problem.

    Thanks and best regards

    Walter

     
    • Kurt Steiner
      Kurt Steiner
      2006-03-11

      Delete all instances of
      ENGINE = MYISAM DEFAULT CHARSET = latin1  int he sql file. Be sure that there is a ; after the closing brace.
      You are having this error because you are using an older version of MySQL than created the dumpfile