Importing multiple CSV files

  • pschnetz

    (@pschnetz)


    10 years, 11 months ago

    I have a huge database I need to upload, (150,000+) records (each record will become its own post). I have this database in about 4 different related csv files (related by a common ID)…basically what I have is a relational database in the form of 4 csv files.
    My question is should I combine these 4 files into a single master csv file to import it, or should I import each file individually and then figure out how to link them together again using phpmyadmin? When dealing with this many records would it be wise to keep the tables separate in terms of query speed?
    I will be using something like ‘csv importer’ plugin so I kind of unsure about whether I need to merge all csv files into a single file…I just fear in doing this I defeat the purpose of having a relational mysql database…
    So, to merge or not, that is the question.

Viewing 1 replies (of 1 total)
  • Krishna

    (@1nexus)

    10 years, 11 months ago

    So, to merge or not, that is the question.

    Sorry, no easy answer as these are in separate databases and when you import into one database, we can’t predict how the result will turn out. The best thing is to try on a test site or on a server setup on your local machine and if the results are as expected, then you can export the resulting database into your live site.

Viewing 1 replies (of 1 total)
  • The topic ‘Importing multiple CSV files’ is closed to new replies.