Mercurial > p > roundup > code
comparison doc/mysql.txt @ 2594:c0d6d5004464
rdbms doc updates
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Tue, 20 Jul 2004 04:38:54 +0000 |
| parents | 096063697f77 |
| children | 653c7ffce402 |
comparison
equal
deleted
inserted
replaced
| 2592:5a8d9465827e | 2594:c0d6d5004464 |
|---|---|
| 1 ============= | 1 ============= |
| 2 MySQL Backend | 2 MySQL Backend |
| 3 ============= | 3 ============= |
| 4 | 4 |
| 5 :version: $Revision: 1.9 $ | 5 :version: $Revision: 1.10 $ |
| 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 |
| 51 | 51 |
| 52 Additional configuration | 52 Additional configuration |
| 53 ======================== | 53 ======================== |
| 54 | 54 |
| 55 To initialise and use the MySQL database backend, roundup's configuration | 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 | 56 file (``config.py`` in the tracker's home directory) should have the following |
| 57 entries:: | 57 entries (substituting real values of course):: |
| 58 | 58 |
| 59 MYSQL_DBHOST = 'localhost' | 59 MYSQL_DBHOST = 'localhost' |
| 60 MYSQL_DBUSER = 'rounduptest' | 60 MYSQL_DBUSER = 'rounduptest' |
| 61 MYSQL_DBPASSWORD = 'rounduptest' | 61 MYSQL_DBPASSWORD = 'rounduptest' |
| 62 MYSQL_DBNAME = 'rounduptest' | 62 MYSQL_DBNAME = 'rounduptest' |
| 63 MYSQL_DATABASE = ( MYSQL_DBHOST, MYSQL_DBUSER, MYSQL_DBPASSWORD, | 63 MYSQL_DATABASE = ( MYSQL_DBHOST, MYSQL_DBUSER, MYSQL_DBPASSWORD, |
| 64 MYSQL_DBNAME ) | 64 MYSQL_DBNAME ) |
| 65 | 65 |
| 66 Fill in the first four entries with values for your local MySQL installation | 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 `Running the | 67 before running "roundup-admin initialise". Use the commands in the |
| 68 MySQL tests` to set up a database if you have privilege, or ask your local | 68 `Running the MySQL tests`_ to set up a database if you have privilege, or |
| 69 administrator if not. | 69 ask your local administrator if not. |
| 70 | 70 |
| 71 | 71 |
| 72 Showing MySQL who's boss | 72 Showing MySQL who's boss |
| 73 ======================== | 73 ======================== |
| 74 | 74 |
| 80 # rm -rf /var/lib/mysql/rounduptest | 80 # rm -rf /var/lib/mysql/rounduptest |
| 81 # /etc/init.d/mysql start | 81 # /etc/init.d/mysql start |
| 82 | 82 |
| 83 and all will be better (note that on some systems, ``mysql`` is spelt | 83 and all will be better (note that on some systems, ``mysql`` is spelt |
| 84 ``mysqld``). | 84 ``mysqld``). |
| 85 |