Based on a related post on one of my favorite python-lists I remembered, that I wrote a similar snipplet some time ago.
So if you want to dump your whole MySQL database to csv-files you can recycle the following code:
?Download mysql2cvs.R
1 2 3 4 5 6 7 8 9 | require(RMySQL) m<-MySQL() summary(m) con<-dbConnect(m, dbname = "YOURDB", host="localhost", port=8889, user="YOURUSER", pass="YOURPASS", unix.sock="/Applications/MAMP/tmp/mysql/mysql.sock") # in case you are using MAMP tables<-dbListTables(con) for (i in 1 : length(tables)){ temp<-(dbReadTable(con, tables[i])) write.table(temp, tables[i], row.names=F)} |
This also is a great way to use my new source-code plugin (WP-CodeBox)
Enjoy!