|
Posted by snapcount on 10/08/49 11:35
Hi, I have a serious problem exporting a largish database (23000
records) with PHPMYADMIN. The problem is that the records which contain
lower quotes ( ,, ) in any of the fields get truncated in the exported
..sql file, for example if there's a record with three fields id, name,
occupation and the contents are respectively 235, Jessy ,,The Body"
Ventura, wrestler then the exported line would be
INSERT INTO BLAH VALUES (235, "Jessy ;
instead of
INSERT INTO BLAH VALUES (235, "Jessy ,,The Body" Ventura",
"wrestler");
My hosting company is using phpMyAdmin 2.7.0-pl1
Can anyone think of a way to work around this? I need to transfer the
data to another database, so I need to export it somehow. If nothing
else, I can replace the double lower quote with a double upper quote
(it's all the same) but I don't know which query should I use (my SQL
is amateurish at best). Also if there is a more elegant way of
exporting this database, please let me know, thanks!
[Back to original message]
|