At 1:10 PM +0300 4/19/02, cristian ditoiu wrote: >hi , i have a little mysql problem . >: >got 2 servers .. 1 got a dump from server1 via myadmin , but when trying to >insert the data into server 2 i got a strange errror and i got disconected >from server2 . > >any ideeas ? > >------------------ >Your MySQL connection id is 752533 to server version: 3.23.37-log > >Type 'help' for help. > >mysql> INSERT INTO ref_data VALUES (186, 139, 'Tess of the D\'Urbervilles', >'THOMAS HARDY\r\nTESS OF THE D'URBERVILLES\r', 'tess.DOC', '2002-02-06',
...............................^ There's an unescaped ' there; if you created this dump from phpmydmin, perhaps there's a quote handling bug somewhere... That's a strange error, though, since AFAIK there's no place to put a hostname in an INSERT. -steve >648, 15872, 1, '', 10); >ERROR 2005: Unknown MySQL Server Host ''tess.DOC',' (2) >mysql> >---------- -- +------------------------------------------------------------------------+ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ | +------------------------------------------------------------------------+ | "If only life would imitate toys." | | - Ted Raimi, March 2002 | | - http://www.whoosh.org/issue67/friends67a.html#raimi | +------------------------------------------------------------------------+ --------------------------------------------------------------------- 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