All BUG Database {- Help me-**

[minhdang3101]

I can't Restor Database Rose from c:\server\sql\
If i Restor with Php My Admin
Bug:

Error:
SQL-query:

/* MySQL Data Transfer Source Host: localhost Source Database: rose Target Host: localhost Target Database: rose Date: 7/22/2006 5:56:45 AM */-- ----------------------------
-- Table structure for accounts
-- ----------------------------
CREATE TABLE `accounts` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`username` varchar( 32 ) default NULL ,
`password` varchar( 32 ) default NULL ,
`accesslevel` int( 11 ) default '100',
`lastip` varchar( 15 ) default '0.0.0.0',
`lasttime` int( 11 ) default '0',
`lastchar` varchar( 32 ) default NULL ,
`email` varchar( 100 ) default NULL ,
`nb_donation` int( 11 ) default '0',
`donation` varchar( 255 ) default '0',
`active` int( 11 ) default '0',
`active_key` varchar( 255 ) default NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1


If i use Navicat,when Execute Batch FIle
BUG

[Err] 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 'DEFAULT CHARSET=latin1' at line 28
[Msg] Finished - Unsuccessfully

++++++++++++++++++++++++++++++++++++++

Anyone Please Help me ......please....


note: I'm From Viet Nam >>> My Bad English.............

[MentaL]

[JimmyBobJoe]

what version of mysql and phpmyadmin are you using?

[minhdang3101]

I user all soft support for Server from Link Download of "..SIN..."

Thank's for Reply !

[Kuraisama]

dude youre simply missing a semicolon ";" after latin1

ENGINE=MyISAM DEFAULT CHARSET=latin1;

[minhdang3101]

HI ! Thank's Kuraisama and JimmyBobJoe

[minhdang3101]

I can't Restor Database Rose from c:\server\sql\
If i Restor with Php My Admin
Bug:

Error:
SQL-query:

/* MySQL Data Transfer Source Host: localhost Source Database: rose Target Host: localhost Target Database: rose Date: 7/22/2006 5:56:45 AM */-- ----------------------------
-- Table structure for accounts
-- ----------------------------
CREATE TABLE `accounts` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`username` varchar( 32 ) default NULL ,
`password` varchar( 32 ) default NULL ,
`accesslevel` int( 11 ) default '100',
`lastip` varchar( 15 ) default '0.0.0.0',
`lasttime` int( 11 ) default '0',
`lastchar` varchar( 32 ) default NULL ,
`email` varchar( 100 ) default NULL ,
`nb_donation` int( 11 ) default '0',
`donation` varchar( 255 ) default '0',
`active` int( 11 ) default '0',
`active_key` varchar( 255 ) default NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1


If i use Navicat,when Execute Batch FIle
BUG

[Err] 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 'DEFAULT CHARSET=latin1' at line 28
[Msg] Finished - Unsuccessfully

++++++++++++++++++++++++++++++++++++++

Anyone Please Help me ......please....


note: I'm From Viet Nam >>> My Bad English.............

>>> Version MySQL don't Suppor for database of Rose.Update NEW Version of MySQL (WAMP or Appsever).