2

How do I read a very large amount of .sql file in R? I don't have MySQL database I just have the raw data file? I tried using MS Access but couldn't able to find a solution.

Daniel Osben
  • 21
  • 1
  • 3
  • 1
    Guess you need to install MySQL, import your file into the database and then you can connect to the DB from R with the `RMySQL` or `RODBC` packages. Don't think you can do anything without MySQL. – nicola Apr 28 '16 at 10:42
  • 1
    Is the file created by mysqldump? If yes, check this out http://stackoverflow.com/questions/36738301/import-mysql-dump-into-r-without-requiring-mysql-server – chinsoon12 Apr 28 '16 at 12:28
  • There is an extended explanation in this page: http://stackoverflow.com/questions/16042384/read-sql-function-in-r-using-r-as-an-sql-browser – amonk Mar 02 '17 at 11:41

0 Answers0