List:General Discussion« Previous MessageNext Message »
From:Steve Edberg Date:April 19 2002 4:27pm
Subject:Re: problem
View as plain text  
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                                      sbedberg@stripped |
| 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 |
+------------------------------------------------------------------------+
Thread
problemcristian ditoiu19 Apr
  • Re: problemSteve Edberg19 Apr
    • RE: problemRoger Baklund20 Apr