How did you try to do it on the remote system? I copied and pasted your query to a server running MySQL 4.1.12-standard-log, and another running MySQL 5.0.19-standard-log, and they both created the table just fine.
Have you tried copying and pasting the table creation itself to see if that works? Or using the commandline to do it on the remote machine -- mysql -u root -p -h host db < file.sql -Sheeri On 4/3/06, julian oliver <[EMAIL PROTECTED]> wrote: > --apologies if you receive this email from another account-- > > hi, > > i exported a *.sql using phpMyAdmin on a system running: > > mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i486) using > readline 5.1 > > i'm trying to import it from this localhost to a remote host > running: > > mysql Ver 14.12 Distrib 5.0.18, for pc-linux-gnu (i486) using > readline 5.1 > > the 13MB file fails during import with this error: > > //---------------------------------------------------------> > > Error > > SQL query: > > -- phpMyAdmin SQL Dump > -- version 2.8.0.2-Debian-3 > -- http://www.phpmyadmin.net > -- > -- Host: localhost > -- Generation Time: Apr 03, 2006 at 07:09 PM > -- Server version: 5.0.19 > -- PHP Version: 4.4.2-1+b1 > -- > -- Database: `nuke` > -- > -- -------------------------------------------------------- > -- > -- Table structure for table `cur` > -- > CREATE TABLE `cur` ( > `cur_id` int( 8 ) unsigned NOT NULL AUTO_INCREMENT , > `cur_namespace` tinyint( 2 ) unsigned NOT NULL default '0', > `cur_title` varchar( 255 ) CHARACTER SET latin1 COLLATE latin1_bin NOT > NULL default '', > `cur_text` mediumtext NOT NULL , > `cur_comment` tinyblob NOT NULL , > `cur_user` int( 5 ) unsigned NOT NULL default '0', > `cur_user_text` varchar( 255 ) CHARACTER SET latin1 COLLATE latin1_bin > NOT NULL default '', > `cur_timestamp` varchar( 14 ) CHARACTER SET latin1 COLLATE latin1_bin > NOT NULL default '', > `cur_restrictions` tinyblob NOT NULL , > `cur_counter` bigint( 20 ) unsigned NOT NULL default '0', > `cur_is_redirect` tinyint( 1 ) unsigned NOT NULL default '0', > `cur_minor_edit` tinyint( 1 ) unsigned NOT NULL default '0', > `cur_is_new` tinyint( 1 ) unsigned NOT NULL default '0', > `cur_random` double unsigned NOT NULL default '0', > `cur_touched` varchar( 14 ) CHARACTER SET latin1 COLLATE latin1_bin NOT > NULL default '', > `inverse_timestamp` varchar( 14 ) CHARACTER SET latin1 COLLATE > latin1_bin NOT NULL default '', > UNIQUE KEY `cur_id` ( `cur_id` ) , > KEY `cur_namespace` ( `cur_namespace` ) , > KEY `cur_title` ( `cur_title` ( 20 ) ) , > KEY `cur_timestamp` ( `cur_timestamp` ) , > KEY `cur_random` ( `cur_random` ) , > KEY `name_title_timestamp` ( `cur_namespace` , `cur_title` , > `inverse_timestamp` ) , > KEY `user_timestamp` ( `cur_user` , `inverse_timestamp` ) , > KEY `usertext_timestamp` ( `cur_user_text` , `inverse_timestamp` ) , > KEY `namespace_redirect_timestamp` ( `cur_namespace` , `cur_is_redirect` > , `cur_timestamp` ) > ) ENGINE = MYISAM DEFAULT CHARSET = latin1 PACK_KEYS =1 AUTO_INCREMENT > =1028; > > MySQL said: Documentation > #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 'collate > +latin1_bin NOT NULL default '', > `cur_text` mediumtext > > > //<--------------------------------------------------------- > > as i know very little about mysql generally, i'm having a hard time > deriving what the right syntax might be here. > out of interest the same *.sql imports on the local system just fine > using mysql on the commandline ('mysql -u <user> -p <database> < > file.sql'), > but on the remote machine fails with the same error as seen above. > > if someone could point me in the right direction i'd be very grateful. > > cheers, > > julian > -- > julian oliver > [EMAIL PROTECTED] > > -- > http://www.fastmail.fm - Does exactly what it says on the tin > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
