Today, I tried to install mysql client library for python. I got client library from http://sourceforge.net/projects/mysql-python . After download and I change mysql_config in site.cfg. I gave

mysql_config= /Application/MAMP/library/bin/mysql_config

and then

$python setyp.py clean
$python setyp.py build

and the I got many errors.

gcc-4.0 failed with exit code 1

I didn’t know Why occur like that. Most of .c files are not found in error message. So, I search in My Mac and I couldn’t find it. I decied to install mysql 5 again. Only client library not include server.

sudo port install mysql5

After installation, I change site.cfg like that

mysql_config = /opt/local/lib/mysql5/bin/mysql_config

after that

$python setup.py clean
$sudo python setup.py build
$sudo python setup.py install

No problem. So, I tried in python from terminal

>>import MySQLdb

I got error again. There is no sock in /opt/local/var/run/mysql5/mysqld.sock

Ok. We can make from MAMP sock. I add following code in terminal

sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /opt/local/var/run/mysql5/mysqld.sock

After that, I tried again in python and connect mysql database that from MAMP. Yayyy… it’s working fine.

This will be help for hosting script installation like Fantastico. Fantastico install with Latin Encoding and this code can covert to UTF-8. Now I can convert Zawgyi Latin Encoding To Zawgyi UTF8 Encoding.

What mean of Latin Encoding and UTF-8 Encoding ?

Latin encode က is like က but UTF-8 encode just only က. So, Latin encoding may be use more spacing in database than UTF-8 encoding.

What benefit of this code ?

Most of the hosting panel conatain Fantastico De Luxe . It’s easy to install wordpress, joomla,etc. But a problem is ,it is using Latin Base Database when installation the wordpress. Most of the myanmar people can’t use this because of the Latin Base. Myanmar Character need UTF-8 encoding in Database.

So, you use this script and run easily.It’s will convert all field to UTF-8 including database. Now, We use Fantastico De Luxe. After the install from Fantastico De Luxe , you need to run this script. You need to some requirement.

Technology

• PHP
• MySQL

Link

http://code.google.com/p/mysqlutf8convertor/

I am making new run_xampp.bat. The new code can be stop MSSQL server and IIS also. Sometime, we can’t run apaceh because of MSSQL service. So, we need to stop it or we need to change apaceh port. I choice to stop MSSQL service because I just use MySQL. Ok… This is my new code

iisreset.exe/stop
net stop IISADMIN
net stop MSSQLSERVER
net stop MSSQLServerOLAPService
net stop MsDtsServer100
net stop SQLWriter
net stop ReportServer
C:\xampp\xampp_start.exe

If we want to change excel file to mysql, we can change with MySQL Migration Toolkit that contain in MySQL GUI Tool.

1. Change .Excel file to MS Access. You can import excel file in MS Access.

2. Open MySQL Migration Toolkit and choose MS Access. You will do setp by step with wizard. It’s easy, don’t worry it.

3. You will see new database in mysql. Ok. Export only tables from phpmyadmin and then import the another database that you want to import.

It’s easy and you can do csv to mysql like that. You need to open csv with excel and save as xls. After that you can do from step 1.

Cheer!!!