Changes between Version 14 and Version 15 of InstallationGuidelines/MySQL

Timestamp:

06/29/10 14:45:40 (14 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/MySQL

@@ -4 +4 @@
 ==== Notes ====
  1. The databases directory contains what web2py knows about your database
- 2. You need to set Migrate=True in {{{models/00_db.py}}} before you update the code and switch back to Migrate=False later on.
- 3. In case of database mismatches - check the databases directory for the appropriate table ( cat the file ) and change accordingly.
+ 2. You need to set deployment_settings.base.migrate=True in {{{models/000_config.py}}} before you update the code and switch back to deployment_settings.base.migrate=False later on.
+ 3. In case of database mismatches - check the databases directory for the appropriate .table file and change accordingly.
+
+=== Install MySQL ===
+{{{
+apt-get install mysql-server
+}}}
+
+=== Install phpMyAdmin ===
+optional, but highly recommended for easier GUI-based administration
+{{{
+apt-get install phpmyadmin
+}}}
 
 === Install Python support for MySQL ===
@@ -29 +40 @@
 
 === Configure Eden ===
-Suggest to use connection pools to reuse connections in {{{models/00_db.py}}}:
-{{{
-db=SQLDB('mysql://user:mypassword@hostname/sahana',pools=20)
-}}}
+Connection pools allow connections to be reused.
+
+The number used is defined in {{{models/000_config.py}}}
 
 ==== How many pools? ====
@@ -53 +63 @@
  * http://www.debiantutorials.net/mysql-database-replication-masterslave/
  * http://www.howtoforge.com/how-to-repair-mysql-replication
+
 ==== On Master: ====
 {{{