I have a mysql database whose contents I want to put in a Drupal website. So far I have been able to import quite a few of these mysql databases by simply converting them to csv files then using the Node Import module, which worked fabulously.
The databases I was able to import this way were relatively simple, but now I have several complex ones that have articles and such and therefore do not lend themselves to converting easily to csv. Every time I try I get the final column in my table being transported to a whole new row and split up horribly, my database gets massacred. I did manage at some point to do the conversion to csv but when I imported into Drupal the column with detailed info had almost no punctuation left, the separate lines of content ran into each other, and such.
Is there an automatic way to do this, to take any mysql database and import it into Drupal without losing your formatting?