# Using MySQL4.1 with bibus

Note: This may presumably also be true for MySQL5.0 but I never test it.

## MySQL-python package

MySQL-python for python2.3 from <http://sourceforge.net/projects/mysql-python>. The last version is 1.2.1c3 and is compatible with MySQL4.1. If you use a previous version, including 1.2.0, you must use MySQL up to 4.0.

### linux

You distribution presumably provide this package under the name python-mysql. It is presumably the best way to get it. You can also download the source and compile it. For this you will need to get the developpement package of mysql which is available in your distribution.

### Windows

Last time I checked the last Windows version available on the main site was mysql-python-1.2.0. This version is only compatible with MySQL up to version 4.0
If you use a newer MySQL release, you have two choices:

- Get the source of version 1.2.1c3 and compile it using one of the following documents:

- This one prepared by Claude PAOLI.
- This doc from http://www.transana.org.

- Used the compiled version from http://www.transana.org. This is version 1.2.1c3 and it works well with bibus and MySQL-4.1.

### Setting the database

- Go to the directory bibus-1.1.0/db_models/
- type: mysql -u root -p < mysql_41.sql
- Enter the mysql root password
- A database called Biblio_41 wil be created with the correct tables
- If you have a previous bibus database called Biblio created with MySQL4.0 or 3.3, perform the following command:

- mysqldump -p -u root -t Biblio | mysql Biblio_41

- Give the correct grants to the users that will use the database as explained here.