Blog Archives

find out how many open connection in mysql

mysqladmin –user=root –password=mysqlpass processlist -i 1 is a great thing 🙂 shows how many mysql connection/process open in server specially in python mysql you can get errors like this: OperationalError: (1040, ‘Too many connections’) this means you have many connection

Tagged with: , , , , ,
Posted in Linux, mysql, ploneCMS

Install:zmysqlda

download zMysqlda : http://www.zope.org/Members/adustman/Products/ZMySQLDA download Mysql- Python : http://sourceforge.net/projects/mysql-python First install mysql-python unpack it.Change directory to the unpacked folder in terminal type:PLONE_PATH/Python-2.4/bin/python setup.py install There maybe some mysql_config path error Like: EnvironmentError: mysql_config not found installing the libmysqlclient15-dev package solved

Tagged with: , , , ,
Posted in Uncategorized

pyExcelerator : Python exportar MySQL to Excel

Lets try to create Excel Files using python. There is a Addon for python named pyExcelerator. First you have to install it. Thats easy just go to http://sourceforge.net/projects/pyexcelerator download pyExcelerator. Unpack it any where. Point folder from terminal as root.

Tagged with: , , ,
Posted in ploneCMS, python
Disclaimer
All content provided on this "tareqalam.com" blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner of [tareqalam.wordpress.com] will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information.
August 2017
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 23 other followers