0

I want to import a local sql dump-file as n data.frames, that can be downloaded here (170 MB) from http://www.ahschulz.de/enron-email-data/, into my R workspace.

Before you ask: "Why won't you download the .Rdata file?" - Proxy problems at my location

I researched for solutions but couldn't find any and I don't want do create my own database locally with a new server.

Any suggestions for importing? Packages or anything? Thanks!

Paavo Pohndorff
  • 323
  • 1
  • 2
  • 17
  • I think you will probably need MySQL in some way or form to convert those dump files to another format, e.g. CSV. These files were intended to import into MySQL. – Tim Biegeleisen Aug 16 '17 at 11:38
  • 1
    @TimBiegeleisen I wonder if it's possible to convert MySQL to sqlite, which can be used in R with far less pain than the rest of SQL databases. – Roman Luštrik Aug 16 '17 at 11:38
  • 1
    @RomanLuštrik You might be on to something: https://stackoverflow.com/questions/5164033/export-a-mysql-database-to-sqlite-database – Tim Biegeleisen Aug 16 '17 at 11:40
  • @TimBiegeleisen only two indirect dependencies, sweet. – Roman Luštrik Aug 16 '17 at 11:41
  • @TimBiegeleisen I have been down that road before... Unless the data is pretty simple don't try it - none of the scripts I found handled every situation. Just install mySQL server and be done with it. My advice to the questioner is to download the file at another location in the Rdata format. – Ian Wesley Aug 16 '17 at 14:50
  • 1
    @IanWesley Yes, if I only had the SQL dump files I would just install MySQL and go from there. Or, as you said, get the `.RData` files from a non blocked location. When asked to build a car using a boat, the answers tend to get stretched pretty thin. – Tim Biegeleisen Aug 16 '17 at 14:59

0 Answers0