search

BIDS-collaborative / brainspell

brainspell is a web platform to facilitate the creation of an open, human-curated, classification of the neuroimaging literature
https://gitter.im/BIDS-collaborative/brainspell
2 stars 6 forks source link

Strip CDATA blocks out of Concepts table #33

Open davclark opened 8 years ago

davclark commented 8 years ago

This could be done in the database with PHP, or alternatively by a script that modifies files in docker/postgres/data/*.txt.

davclark commented 8 years ago

@r03ert0 has a function in brainspell.php, and will try to sanitize the Concepts table using PHP.

davclark commented 8 years ago

@jbpoline can you check with @r03ert0 to see if this has been done and if we should get a new dump of the mysql database?

Also, this style of dump is much easier to work with programmatically:

$ mysqldump -u root -p --tab=/var/lib/mysql-files brainspell