<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="content-type">
<title>mysql4.1</title>
</head>
<body>
<h1>Using MySQL4.1 with bibus</h1>
<br>
Note: This may presumably also be true for MySQL5.0 but I never test it.<br>
<br>
<h2>MySQL-python package<br>
</h2>
<a href="http://sourceforge.net/projects/mysql-python/">MySQL-python</a>
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.
<h3>linux</h3>
You distribution presumably provide this package under the name
python-mysql. It is presumably the best way to get it. You can also <a
href="http://prdownloads.sourceforge.net/mysql-python/MySQL-python-1.2.1c3.tar.gz?download">download
the source</a> and <a href="MySQL41.html">compile it</a>. For this you
will need to get the
developpement package of mysql which is available in your distribution.<br>
<h3>Windows</h3>
Last time I checked the last Windows version available on the main site
was <a
href="http://prdownloads.sourceforge.net/mysql-python/MySQL-python.exe-1.2.0.win32-my4.0-py2.3.exe?download">mysql-python-1.2.0</a>.
This version is only compatible with MySQL up to version 4.0<br>
<br>
If you use a newer MySQL release, you have two choices:<br>
<ul>
<li>Get the source of <a
href="http://prdownloads.sourceforge.net/mysql-python/MySQL-python-1.2.1c3.tar.gz?download">version
1.2.1c3</a> and compile it using one of the following documents:</li>
<ul>
<li>This one prepared by <a href="MySQL41.html">Claude PAOLI</a>.</li>
<li>This <a
href="http://www.transana.org/developers/setup/MySQLPython_Win_MU.htm">doc</a>
from <a href="http://www.transana.org">http://www.transana.org.</a></li>
</ul>
<li>Used the compiled version from <a href="http://www.transana.org/">http://www.transana.org.</a>
This is <a
href="http://www.transana.org/developers/setup/..%5C..%5Cdownload%5CFiles%5CMySQL-python-1.2.1c3.win32-py2.3-MySQL4.1.14.zip">version
1.2.1c3</a> and it works well with bibus and MySQL-4.1.<a
href="http://www.transana.org/"><br>
</a></li>
</ul>
<h3>Setting the database</h3>
<ul>
<li>Go to the directory bibus-1.1.0/db_models/</li>
<li>type: mysql -u root -p < mysql_41.sql</li>
<li>Enter the mysql root password</li>
<li>A database called Biblio_41 wil be created with the correct tables</li>
<li>If you have a previous bibus database called Biblio created with
MySQL4.0 or 3.3, perform the following command:</li>
<ul>
<li>mysqldump -p -u root -t Biblio | mysql Biblio_41<br>
</li>
</ul>
<li>Give the correct grants to the users that will use the database
as explained <a href="usingBibus.html#mozTocId383419">here</a>.<br>
</li>
</ul>
<br>
</body>
</html>
