Problem with command: mysql -u root -p < localhost.sql

[chromis]

Hi,

I'm trying to import a mysqldump of all the databases from one server to another. First I attempted to use phpMyAdmin, I exported using the export to file option (drop database and drop tables selected) and then tryed to paste the resulting file (8mb into the text input field) not the brightest of moves i admit. That failing I then tryed this command from the command console (windows server 2003):

C:\mysql\binmysql -u root -p < localhost.sql

Having placed the localhost.sql (sql dump file) in the c:/mysql/bin directory.

This is the error that is output:

C:\mysql\bin>mysql -u root -p < localhost.sql
Enter password: ********
ERROR 1064 at line 21: You have an error in your SQL syntax.  Check the manual t
hat corresponds to your MySQL server version for the right syntax to use near 'E
NGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCR
 

and this is the relevant sql from the dump:

CREATE DATABASE `adam_db`;
USE adam_db;
 
# --------------------------------------------------------
 
#
# Table structure for table `about`
#
 
CREATE TABLE `about` (
  `about_id` mediumint(9) NOT NULL auto_increment,
  `text` text NOT NULL,
  UNIQUE KEY `about_id` (`about_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
 

Does anyone know where I am going wrong?

I am using MySQL version 4.0.12-nt, phpMyAdmin 2.5.3-rc1 and PHP 5.1.2.

Thanks!

Chromis

[chromis]

Ok found the problem, the version of the database I was trying to copy in was slightly newer.

Thanks anyway,

Chromis