Reply to Problem exporting with PHPMYADMIN

Your name:

Reply:


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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация