Upgrading a database

I recently purcased a website and it has a database phpMyAdmin 2.6.4-pl2 and my host has phpMyAdmin 2.8.0.2. I am trying to move it and I get an error saying

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 11, 2006 at 11:47 PM
-- Server version: 4.1.19
-- PHP Version: 4.3.11
--
-- Database: `kjnetwor_directory`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
CREATE TABLE `admin` (

`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`username` varchar( 30 ) NOT NULL default '',
`password` varchar( 30 ) NOT NULL default '',
`name` varchar( 40 ) NOT NULL default '',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;



MySQL said:

#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 AUTO_INCREMENT=2' at line 7

Can you help me?

 

Try without "DEFAULT CHARSET = latin1".

Not sure if it works, buy I have had a similar problem and it worked.

 

I tried it and it said

Error
SQL query:

-- --------------------------------------------------------
--
-- Table structure for table `ban`
--
CREATE TABLE `ban` (

`ip` varchar( 15 ) NOT NULL default '',
PRIMARY KEY ( `ip` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;



MySQL said:

#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 4

 

You didn't remove "DEFALT CHARSET=latin1"