Convert MS Access to MySQL

Bullzip can be used to convert MS Access to MySQL

Filed under: mysql | |No Comments

Configure php 5 for Mysql 5

-Edit php.ini and uncomment 'extension=php_mysql.dll'

-Check php.ini

extension_dir = ".\"

or

extension_dir = ".\ext"

-Copy to system32 directory:

/php/libmysql.dll
/php/ext/php_mysql.dll

-Restart Apache 2

Filed under: mysql, php | |No Comments

Mysql Windows Manual install

Download mysql community server from mysql.com: mysql-noinstall-5.0.51b-win32.zip

Unzip

Choose a my.ini template file (e.g. my-small.ini)

Add to my.ini if mysql root directory is NOT c:\mysql (Note the forward slash).
[mysqld]
# set basedir to your installation path
basedir=C:/mysql/mysql-5.0.51b-win32
# set datadir to the location of your data directory
datadir=C:/mysql/mysql-5.0.51b-win32/data

Copy my.ini to C:\windows directory

Install mysql as a service: C:\jml\prog\org\mysql\mysql-5.0.51b-win32\mysqld --install MySQL

Filed under: mysql | |No Comments