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:
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.