Re: MySQLdb reconnect

[Damjan]

 Does MySQLdb automatically reconnect if the connection to the database is
 broken?

It seems so.

 I'm asking this since I have a longrunning Python precess that is
 connected to Mysql-4.1.11, and I execute set names utf8 when I connect
 to it.
 
 But after running a day the results from the python program were displayed
 as if the set names utf8 was not executed i.e. I got question marks
 where utf-8 cyrillics should've appeared. After restarting the Python
 program everything was ok, just as when I first started it.

This is the sollution I've come to:

try:
# This will fail on MySQL  4.1
db = MySQLdb.connect(godot.dbhost, godot.dbuser, godot.dbpass,
godot.dbname, use_unicode=1, init_command=set names utf8)
except MySQLdb.OperationalError:
db = MySQLdb.connect(godot.dbhost, godot.dbuser, godot.dbpass,
godot.dbname, use_unicode=1)
db.charset = 'utf8'


-- 
damjan
-- 
http://mail.python.org/mailman/listinfo/python-list

MySQLdb reconnect

[Damjan]

Does MySQLdb automatically reconnect if the connection to the database is
broken?

I'm asking this since I have a longrunning Python precess that is connected
to Mysql-4.1.11, and I execute set names utf8 when I connect to it.

But after running a day the results from the python program were displayed
as if the set names utf8 was not executed i.e. I got question marks where
utf-8 cyrillics should've appeared. After restarting the Python program
everything was ok, just as when I first started it.

The long running Python process is actually a scgi quixote web application.


-- 
damjan
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: MySQLdb reconnect

[Eloff]

I don't beleive that it does. You can however call ping() on the
connection which should attempt an automatic reconnection.

See the docs for mysql_ping:

http://dev.mysql.com/doc/mysql/en/mysql-ping.html

I've never tested that, but I have a need for it also so let me know if
it works or not.

-Dan

-- 
http://mail.python.org/mailman/listinfo/python-list