On Tuesday 04 March 2003 22:38, François Roussel wrote: > I want to add transaction support to an > existing database running > on mysql 3.23.49-3 distributed with Red Hat 7.3. > > After browsing through the Mysql and the Innodb documentation, it appears > that > I have the following options: > > 1) Configure mysql 3.23.49-3 to support innodb tables. Since the > have_innodb variable displays as "disabled", not "no", it should be > possible in theory. > > After some experimenting, I did succeed in creating and using an innodb > table but at the expense of the server sometimes refusing to stop. > I had just added to my.cnf: > > innodb_data_file_path=ibdata1:30M.
If you use 3.23.xx you should also install -MAX package or configure with --with-innodb option. > 2) Install the server from the "Max" package and configure to activate > Innodb tables. > This appears to be the recommended option in the documentation. > > Since the "Max" RPM for 3.23.49-3 is nowhere to be found, this implies > installing the latest binaries (currently 3.23.55). > I experimented with this option and after the installation, I had to create > a > "my.cnf" file which 3.23.55 does not install by default. I succeeded > in creating a innodb table. So far so good. my.cnf is not created by default, you should create it by yourself. 3.23.49 is a bit outdated and usage 3.23.55 is more recommended. > 3)Upgrade to 4.011 which has innodb in the standard binaries. > This is even easier as the default configuration enables innodb tables, > but this version is still gamma. > > Can option 1) work ? nope. > If not, should I go with option 2) or option 3) ? Up to you :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
