Python database access using single file/already build file

Question

I have to save some data into MySQL from Python.

I have tried MySQLdb, but it needs to be built. Build fails on my Mac; moreover, I need to have one file to copy to server. I don't have access to install anything.

Can you recommend me any solution, please! Even where I can find MySQLdb build for specific platforms.

Thanks in advance!

One solution I'm thinking about is to use php for database access. But this is not elegant, temporary solution. — mxg
– mxg, Commented Feb 2, 2010 at 13:58
What difference would php do - it still will copy the file to the server in the same way python does — mmmmmm
– mmmmmm, Commented Feb 2, 2010 at 17:14

Peter Hansen · Accepted Answer · 2010-02-02 15:05:33Z

2

MySQL has a command line interface (similar to psql from Postgres or sqlite3 from the database of the same name). I would be surprised if this wasn't installed on the same server already.

You could then generate input for that utility using Python and call it with subprocess. Depending on the data, this can be as simple as generating INSERT commands from scratch, or you can generate a temporary input file (e.g. in CSV format) and pass it to the utility by name.

edited Feb 2, 2010 at 15:05

answered Feb 2, 2010 at 14:34

Peter Hansen

22.3k6 gold badges56 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mmmmmm · Accepted Answer · 2010-02-02 13:08:12Z

1

I find the easiest way to use C extensions from python on a Mac is to use Macports

Yo will need to install macports and then install the port py26-mysql this will install python 2.6 and MySQL.

However in this case I would have thought MySQLdb should be an easy install - to help with that can you edit your question to show the error and tell us where the mySql libraries are installed

answered Feb 2, 2010 at 13:08

mmmmmm

32.8k28 gold badges92 silver badges124 bronze badges

1 Comment

mmmmmm Over a year ago

Can you give the actual error message and what file do you need to copy to the server - python mysql does not need more that a working MySQL on the server

Collectives™ on Stack Overflow

Python database access using single file/already build file

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related