Results 1 to 2 of 2
Mar 16, 2011, 11:42 #1
Exporting data incl HTML using PHPMyAdmin as csv
I'm having trouble trying to export a csv file from a Joomla database which contains some HTML. I can see the data laid out perfectly in PHPMyAdmin when I carry out an SQL command like this:
SELECT `id` , `title` , `alias` , `introtext` , `fulltext` FROM `jos_content`
The settings I'm using in PHPMyAdmin to export the data are:
Export : CSV
Fields terminated by : ,
Fields enclosed by : "
Fields escaped by : \
Lines terminated by : AUTO
Replace NULL by : NULL
Mar 17, 2011, 02:38 #2
Anyone got any ideas? Sorry for urgency, but I need to do this asap.