Hi Everyone.

I'm having a bit of a problem importing a dumpfile to mysql. When doing a " 
mysql -u database_mgr -p -h host.domain database < file.dump " I get this 
error:

--cut--
ERROR 1064 at line 11: You have an error in your SQL syntax near '(15),
  surname TEXT(15),
  company TEXT(20),
  email TEXT(20),
  tel TEXT(15),
' at line 4
--cut--

The first part of the dump file is:
--cut--
#
# mSQL Dump  (requires mSQL 2.0 Beta 5 or newer)
#
# Host: localhost    Database: venuesearch
#--------------------------------------------------------


#
# Table structure for table 'enquire'
#
CREATE TABLE enquire (
  session CHAR(19),
  dated INT,
  firstname TEXT(15),
  surname TEXT(15),
  company TEXT(20),
  email TEXT(20),
  tel TEXT(15),
  telcode CHAR(7),
  fax TEXT(15),
  faxcode CHAR(7),
  addr TEXT(80)
)
--cut--

Am I missing something? 

MySQL details:
mysql  Ver 11.15 Distrib 3.23.37, for sun-solaris2.7 (sparc)

Thanks in advance.
Regards
JvdW

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to