Masalah saat import database


Status
Not open for further replies.

shara nurul

Apprentice 1.0
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
 
coba file sqlnya edit pake text editor dan buang semua "TYPE = MYISAM" CMIIW
 
Status
Not open for further replies.
Back
Top