Mercurial > p > roundup > code
comparison doc/mysql.txt @ 2860:653c7ffce402
remove obsolete configuration notes
| author | Alexander Smishlajev <a1s@users.sourceforge.net> |
|---|---|
| date | Wed, 03 Nov 2004 09:23:50 +0000 |
| parents | c0d6d5004464 |
| children | ad4fb8a14a97 |
comparison
equal
deleted
inserted
replaced
| 2858:0357a9c93933 | 2860:653c7ffce402 |
|---|---|
| 1 ============= | 1 ============= |
| 2 MySQL Backend | 2 MySQL Backend |
| 3 ============= | 3 ============= |
| 4 | 4 |
| 5 :version: $Revision: 1.10 $ | 5 :version: $Revision: 1.11 $ |
| 6 | 6 |
| 7 This notes detail the MySQL backend for the Roundup issue tracker. | 7 This notes detail the MySQL backend for the Roundup issue tracker. |
| 8 | 8 |
| 9 | 9 |
| 10 Prerequisites | 10 Prerequisites |
| 47 | 47 |
| 48 The MySQL database should not contain any tables. Tests will not | 48 The MySQL database should not contain any tables. Tests will not |
| 49 drop the database with existing data. | 49 drop the database with existing data. |
| 50 | 50 |
| 51 | 51 |
| 52 Additional configuration | |
| 53 ======================== | |
| 54 | |
| 55 To initialise and use the MySQL database backend, roundup's configuration | |
| 56 file (``config.py`` in the tracker's home directory) should have the following | |
| 57 entries (substituting real values of course):: | |
| 58 | |
| 59 MYSQL_DBHOST = 'localhost' | |
| 60 MYSQL_DBUSER = 'rounduptest' | |
| 61 MYSQL_DBPASSWORD = 'rounduptest' | |
| 62 MYSQL_DBNAME = 'rounduptest' | |
| 63 MYSQL_DATABASE = ( MYSQL_DBHOST, MYSQL_DBUSER, MYSQL_DBPASSWORD, | |
| 64 MYSQL_DBNAME ) | |
| 65 | |
| 66 Fill in the first four entries with values for your local MySQL installation | |
| 67 before running "roundup-admin initialise". Use the commands in the | |
| 68 `Running the MySQL tests`_ to set up a database if you have privilege, or | |
| 69 ask your local administrator if not. | |
| 70 | |
| 71 | |
| 72 Showing MySQL who's boss | 52 Showing MySQL who's boss |
| 73 ======================== | 53 ======================== |
| 74 | 54 |
| 75 If things ever get to the point where that test database is totally hosed, | 55 If things ever get to the point where that test database is totally hosed, |
| 76 just:: | 56 just:: |
| 80 # rm -rf /var/lib/mysql/rounduptest | 60 # rm -rf /var/lib/mysql/rounduptest |
| 81 # /etc/init.d/mysql start | 61 # /etc/init.d/mysql start |
| 82 | 62 |
| 83 and all will be better (note that on some systems, ``mysql`` is spelt | 63 and all will be better (note that on some systems, ``mysql`` is spelt |
| 84 ``mysqld``). | 64 ``mysqld``). |
| 85 |