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