Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": No module named svn). Look in the Trac log for more information.

Changes between Version 9 and Version 10 of MySql


Ignore:
Timestamp:
08/22/06 04:10:47 (13 years ago)
Author:
jardous
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • MySql

    v9 v10  
    1 = MySQL Setup = 
     1= MySQL Installation = 
    22See DataBaseInstalation 
     3 
     4= Setup the database for TG to work with = 
     5Firstly need to set DB connection string in ''dev.cfg'' (for development environment, ''prod.cfg'' for production environment) like: 
     6{{{ 
     7sqlobject.dburi="mysql://george@localhost/test" 
     8}}} 
     9 
     10assuming ''george'' as database username, ''localhost'' as hostname and ''test'' as database name. 
     11 
     12Then we need to create database using shell: 
     13{{{ 
     14$ mysql -h localhost -u root -p menagerie 
     15 
     16mysql> CREATE DATABASE test; 
     17Query OK, 1 row affected (0.03 sec) 
     18 
     19mysql> GRANT ALL ON test.* TO 'george'@'localhost'; 
     20Query OK, 0 rows affected (0.11 sec) 
     21 
     22mysql> CTRL+d 
     23Bye 
     24}}} 
     25 
     26Now we can test the DB connection as follows: 
     27 
     28{{{ 
     29shell> mysql -h localhost -u george -p test 
     30Enter password: ENTER 
     31}}} 
     32 
     33Now it is everything prepared and we can create database structure using our model: 
     34 
     35{{{ 
     36tg-admin sql create 
     37}}} 
    338 
    439== To Transaction or Not to Transaction ==