Uploading Database and Got this Error::

[PvtPulse]

www.3lwavenue.com/gallery

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 20, 2006 at 04:59 AM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `lwavenue_gallery`
--
-- --------------------------------------------------------
--
-- Table structure for table `agb_book_auth`
--
CREATE TABLE `agb_book_auth` (

`ID` smallint( 5 ) NOT NULL AUTO_INCREMENT ,
`username` varchar( 60 ) NOT NULL default '',
`password` varchar( 60 ) NOT NULL default '',
`session` varchar( 32 ) NOT NULL default '',
`last_visit` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM AUTO_INCREMENT =2DEFAULT 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 8

[Nibbler]

You are transferring to an older version of mysql so you need to use the compatibility options when you make the dump.

[PvtPulse]

Why am I still getting this error message now that I have transferred the database:

www.3lwavenue.com/gallery

[Joachim Müller]

Don't edit out your postings! The page is in maintenance mode, we can't see any errors, so you should copy the error message and paste it into your reply.
You have another thread running (with a silly subject line btw) that appears to dealing with the same issue: YET ANOTHER PROBLEM, so I'm locking this one. In the future, respect board rules!