I am trying to execute a file on mysql database and I get this message:
Code:
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.6.2-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 15 Nov, 2005 at 09:13 PM
-- Versione MySQL: 4.1.14
-- Versione PHP: 4.4.0
--
-- Database: `hypercube`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `torrent_bans`
--
CREATE TABLE `torrent_bans` (
`id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`ipstart` int( 10 ) unsigned NOT NULL default '0',
`ipend` int( 10 ) unsigned NOT NULL default '0',
`reason` varchar( 255 ) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `ip_unique` ( `ipstart` , `ipend` )
) 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 'DEFAULT CHARSET=latin1' at line 27