A thread-compatible interface to the popular MySQL database server that provides the Python database API.
2
votes
0answers
127 views
Why does SIGINT sent to Python script kill MySQL connection?
I'm having an issue with sending SIGINT's to python scripts which are connecting to a MySQL database using MySQLdb (mysql-python). The python script runs in an infinite loop, and I want to catch the ...
2
votes
0answers
194 views
Python MySQLdb SScursor slow in comparison to exporting and importing from CSV-file. Speedup possible?
As part of building a Data Warehouse, I have to query a source database table for about 75M rows.
What I want to do with the 75M rows is some processing and then adding the result into another ...
2
votes
0answers
170 views
Copy unicode data from MSSql to MySql in Python error
I am trying to copy unicode data from MSSql to MySql. Below is the code that I am trying for past few days, but unable to do it successfully.
#!/usr/bin/python
# -*- coding: utf-8 -*-
import MySQLdb
...
2
votes
0answers
148 views
How to connect MAMP based MYSQL in Python?
I recently upgraded Python on my Macbook to 2.7 via Macport and eventually I had to upgrade MySQL driver too. I tried to install it via Macport but that guy installed another copy of MySQL server too. ...
1
vote
0answers
180 views
Python MySQL connection randomly lost
I have the following problem:
I am using Python with MySQLdb and a SSDictCursor to iterate over a pretty large database (250M lines). Because I am unable to load everything into RAM, I am using the ...
1
vote
0answers
102 views
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql55/mysqld.sock' (2),
Can anyone please help !! following similar queries on stackoverflow did not help.
I get the below error when I start mysql (by typing mysql in the terminal).
More info:
I updated macports before ...
1
vote
0answers
352 views
Python MySQLdb - Programming Around SQL Injection Code
First, i'm very new to stack overflow (first question posted) and forums in general.
In addition to this downfall, I'm also new to development and databases other than at a Systems Administration type ...
1
vote
0answers
45 views
Make database I/O reliable in multithreaded program
First, my apologies for posting this entire block of code. I think it's important to be able to answer my (broad) question.
I have this application. It collects data (eventually from an external ...
1
vote
0answers
149 views
Unable to Insert into database
I want to insert data into the database using following script.There can be 3 suppliers and with respect to each of them I need to store the Warehouse state and zip code .
import MySQLdb as mdb
...
1
vote
0answers
79 views
Intellij not seeing python module MySQLdb
I have installed the python mysqldev
sudo apt-get install python-mysqldb
It is working on command line python. But IJ does not see it
File "/shared/git2/etl/appminer/hive/DB.py", line 7, in ...
1
vote
0answers
58 views
ImportError: No localization support for language 'eng' in python
i am getting ImportError: No localization support for language 'eng' when using MySQL Connector Python.
My Traceback is as below.
Traceback (most recent call last):
File \"DB_Module.py\", line 151, ...
1
vote
0answers
124 views
MySql child processes are consuming a lot RAM space
I have a problem with RAM consumption on my server. Where at certain hour of day RAM usage increases to critical limit.
To check the issue I tried to run htop command and found that most of the RAM ...
1
vote
0answers
355 views
Twitter API getting follower ids for huge number, without getting error
[I am using Python, and ruby gem twurl to request with OAuth.]
I am trying to get follower ids from Twitter, for @BarackObama, who has 24,265,751 followers currently.
Mathematically, 24,265,751 ...
1
vote
0answers
160 views
install MySQLdb to run in Pydev on Mac OS X 10.8
I had been stuck in some incompatible conflicts while trying to install mysql-python in Mac OS X 10.8 for a few days. After looking at some forums I found the solution to force Python run in 32 bit ...
1
vote
0answers
225 views
Improve multithreading with network IO and database queries
I'm writing a script that:
fetch a list of urls from a db (about 10000 urls)
download all the pages and insert them into the db
parse the code
if(some condition) do other inserts into the db
I ...
