mromy 2005/05/09 11:10:10 CEST
Modified files:
html README_4_1.html
Log:
- modified the mysql issues part
Revision Changes Path
1.2 +6 -6 jahia_update/html/README_4_1.html
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia_update/html/README_4_1.html.diff?r1=1.1&r2=1.2&f=h
Index: README_4_1.html
===================================================================
RCS file: /cvs/jahia_update/html/README_4_1.html,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- README_4_1.html 4 May 2005 08:07:51 -0000 1.1
+++ README_4_1.html 9 May 2005 09:10:10 -0000 1.2
@@ -143,23 +143,23 @@
The best way to ensure that the tables will be created in the
correct format during the upgrade process is to change
the settings of MySQL in the configuration file
(<em>my.cnf</em>/<em>my.ini</em>) to set the default type for new tables
to InnoDB before executing the upgrade tool. <br/>
- Edit the <em>my.cnf</em>(linux) or <em>my.ini</em>(windows) and add
the following line in the [mysqld] part of the file :<br/>
+ Edit the <em>my.cnf</em>(Unix/Linux) or <em>my.ini</em>(windows) and
add the following line in the [mysqld] part of the file :<br/>
<p class="code">
default-table-type=InnoDB
</p>
- If your database server runs under <strong>Linux</strong>, you also
<span class="red"><strong>need</strong></span> to change a default setting to
allow case-insensitive
- SQL requests.
+ Once you restart your MySQL server, new tables will be created by
default in InnoDB format.<br/><br/>
+ If your database server runs under <strong>Unix/Linux</strong>, you
also <span class="red"><strong>need</strong></span>
+ to change a default setting to allow case-insensitive SQL requests.
Under Windows and MacOSX, case-insensitive SQL requests are
activated by default, but not under Linux, so you need to edit the
<em>my.cnf</em> configuration file of MySQL and add the following
statement in the [mysqld] part of the file :
<p class="code">
lower_case_table_names=1
</p>
- Then restart your MySQL instance. You can now launch the jahia
upgrade tool. New tables will now be
- created by default in InnoDB format. <br/><br/>
+ Then restart your MySQL instance. You can now launch the jahia
upgrade tool. <br/><br/>
<p>
- To check if the new tables (all tables beginning with "jahia_sl2")
are of the correct type, issue the following
+ To check if the new tables (all tables beginning with "jahia_sl2")
were correctly created in InnoDB, issue the following
sql command once logged into you MySQL database :<br/>
<br/>
<p class="code">SHOW TABLE STATUS FROM your_database LIKE
'jahia_sl2%';</p>
