Fix traceback on .../msgN/ url, this requests the file content and for

[roundup.git] / doc / mysql.txt

diff --git a/doc/mysql.txt b/doc/mysql.txt
index 9e5c5ab4c4fa211346c88826d462c84a70f0bafb..c59e70c0f2170a0b5a70bd65e1e52b8fb702eab8 100644 (file)
--- a/doc/mysql.txt
+++ b/doc/mysql.txt
@@ -2,7 +2,7 @@
 MySQL Backend
 =============
 
-:version: $Revision: 1.6 $
+:version: $Revision: 1.13 $
 
 This notes detail the MySQL backend for the Roundup issue tracker.
 
@@ -13,14 +13,13 @@ Prerequisites
 To use MySQL as the backend for storing roundup data, you also need 
 to install:
 
-1. MySQL RDBMS 4.0 or higher - http://www.mysql.com. Your MySQL
+1. MySQL RDBMS 4.0.18 or higher - http://www.mysql.com. Your MySQL
    installation MUST support InnoDB tables (or Berkeley DB (BDB) tables
-   if you have no other choice)
+   if you have no other choice). If you're running < 4.0.18 (but not <4.0)
+   then you'll need to use BDB to pass all unit tests. Edit the
+   ``roundup/backends/back_mysql.py`` file to enable DBD instead of InnoDB.
 2. Python MySQL interface - http://sourceforge.net/projects/mysql-python
 
-:Note: the InnoDB implementation has a bug that Roundup tickles. See
-       http://bugs.mysql.com/bug.php?id=1810
-
 Running the MySQL tests
 =======================
 
@@ -41,26 +40,21 @@ this:
    you can modify MYSQL_* constants in the file test/test_db.py with 
    the correct values.
 
-Note that the MySQL database should not contain any tables. Tests will not 
+The MySQL database should not contain any tables. Tests will not 
 drop the database with existing data.
 
 
-Additional configuration
+Showing MySQL who's boss
 ========================
 
-To initialise and use the MySQL database backend, roundup's configuration 
-file (config.py in the tracker's home directory) should have the following
-entries::
-
-    MYSQL_DBHOST = 'localhost'
-    MYSQL_DBUSER = 'rounduptest'
-    MYSQL_DBPASSWORD = 'rounduptest'
-    MYSQL_DBNAME = 'rounduptest'
-    MYSQL_DATABASE = ( MYSQL_DBHOST, MYSQL_DBUSER, MYSQL_DBPASSWORD,
-        MYSQL_DBNAME )
-
-Fill in the first four entries with values for your local MySQL installation 
-before running "roundup-admin initialise".  Use the commands in the `Running the
-MySQL tests` to set up a database if you have privilege, or ask your local
-administrator if not.
+If things ever get to the point where that test database is totally hosed,
+just::
+
+  $ su -
+  # /etc/init.d/mysql stop
+  # rm -rf /var/lib/mysql/rounduptest
+  # /etc/init.d/mysql start
+
+and all will be better (note that on some systems, ``mysql`` is spelt
+``mysqld``).