Masalah saat import database

Discussion in 'Masalah Teknik dan Keamanan' started by shara nurul, 10 Jan 2013.

Thread Status:
Not open for further replies.
  1. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    234
    Likes Received:
    1
    Trophy Points:
    18
    Mohon maaf para master ,saya mau numpang tanya

    saya ada amsalah saat import database,muncul error berikut

    Error

    SQL query:

    # phpMyAdmin MySQL-Dump
    # version 2.2.3
    # http://phpwizard.net/phpMyAdmin/
    # http://phpmyadmin.sourceforge.net/ (download page)
    #
    # Host: localhost
    # Generation Time: Dec 17, 2008 at 02:10 PM
    # Server version: 3.23.47
    # PHP Version: 4.1.1
    # Database : `datasms`
    # --------------------------------------------------------
    #
    # Table structure for table `admin`
    #
    CREATE TABLE admin(
    id int( 11 ) NOT NULL AUTO_INCREMENT ,
    user varchar( 20 ) NOT NULL default '',
    pass varchar( 18 ) NOT NULL default '',
    nama varchar( 50 ) default NULL ,
    alamat varchar( 100 ) default NULL ,
    telepon varchar( 20 ) default NULL ,
    bank varchar( 50 ) default NULL ,
    norekening varchar( 20 ) default NULL ,
    PRIMARY KEY ( id )
    ) TYPE = MYISAM ;

    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 'TYPE=MyISAM' at line 27

    Mohon pencerahannya ,apa yang harus saya lakukan

    terimakasih sebelumnya
     
  2. idcolo

    idcolo Apprentice 1.0 Web Hosting (Company)

    Messages:
    336
    Likes Received:
    29
    Trophy Points:
    28
    mysql nya versi brp om?
     
  3. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    234
    Likes Received:
    1
    Trophy Points:
    18
    MySQL version 5.5.28-cll

    itu mas idcolo versinya
     
  4. idcolo

    idcolo Apprentice 1.0 Web Hosting (Company)

    Messages:
    336
    Likes Received:
    29
    Trophy Points:
    28
    coba ganti baris paling bawah itu, dari

    menjadi

     
  5. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    234
    Likes Received:
    1
    Trophy Points:
    18
    baik mas,berati nanti pakai sistem dump database ya
     
  6. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    234
    Likes Received:
    1
    Trophy Points:
    18
    masih belum bisa mas

    mohon pencerahannya
     
  7. galuh82

    galuh82 Hosting Guru Web Hosting (Company)

    Messages:
    2,514
    Likes Received:
    186
    Trophy Points:
    63
    coba file sqlnya edit pake text editor dan buang semua "TYPE = MYISAM" CMIIW
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...