Re: newbie installing MySQL/InnoDB on RH 7.1
voytek, Thursday, March 28, 2002, 3:45:48 PM, you wrote: >>You must first install original MySQL (rpm) package and then you can >>install MySQK-max RPM. You can read about mysqld-max at: >> http://www.mysql.com/doc/m/y/mysqld-max.html >> >>If you want to use InnoDB tables you should specify InnoDB startup >>options in my.cnf file, take a look at: >> http://www.mysql.com/doc/I/n/InnoDB_start.html >>You can find info about configuration parametrs and example if you >>check this link. v> Egor, thanks ! v> as I'm rather new to rpm thing, can you pls tell me: v> if I installed RedHat7.1, and, MySQL that came with RH CD; v> them I download latest MySQL rpm file: v> am I supposed to: v> rpm -UPGRADE OPTION rpm file; v> or v> rpm -INSTALL OPTION rpm file v> ? It would be better if you download MySQL (rpm) and MySQL-max (rpm) from the MySQL site and install them by using: rpm --install rpm_package_name v> also, after I install MySQL 3.23 binary rpm, followed by MySQLMAX 3.23 binary rpm, and, edit the my.cnf as you note: v> do I end up with two MySQLd ? so, I can run either max, or, not max ? You can run mysqld-max or safe_mysqld script. safe_mysqld will try to start any mysqld with the -max prefix. If you want to check InnoDB support you should run the following command: SHOW VARIABLES LIKE 'have_%'; The value for 'have_innodb' must be 'YES'. v> does these rpms include mysql client, or what do I need to d/l ? v> (doing the RH install, it has separate option for client, and mysqld, hence, I'm asking) No, you should install client rpm package. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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
Re: newbie installing MySQL/InnoDB on RH 7.1
rpm -e the mysql product from the CD's to uninstall the originals. then rpm -ivh MySQL-Max-3.23.49a-1.i386.rpm to install the mysql-max product and you're golden. Curtis Voytek Eymont said: > I need some newbie help... > > I've installed RedHat7.1 off RH7.1 CDs, also, installed MySQL that came > with it, > > the installed MySQL did NOT have InnoDB support; > > I then d/l off mysql.com > > MySQL-Max-3.23.49a-1.i386.rpm > > I installed it using: > > rpm --install MySQL-Max-3.23.49a-1.i386.rpm > > (I think that's how it's meant to be installed, I'm a newbie) > > howver, on restart. the 'original CD revison' started, NOT, MAX > > then, i tried starting MySQL-Max by explicitly calling it, it said: > > 'you have wrong error files' > > SO: > > using webmin, I removed all mysql packages; > then, using webmin, installed MySQL-Max-3.23.49a-1.i386.rpm > > now it tell me, the MySQL-Max-3.23.49a is only an extension: > > > Optional MySQL server binary that supports features > like transactional tables. To active this binary, just > install this package after the MySQL package. > - > > but, reading on mysql download page, implies, > MySQL-Max-3.23.49a-1.i386.rpm is all I need... > > help > > so, at this time: > > accoriding to webmin I have: > > Packages matching mysql > > Package Class Description > MySQL-Max 3.23.49a-1 Applications/Databases MySQL - server with > Berkeley DB and Innodb support > > perl-DBD-MySQL 1.2215-1 Applications/CPAN A MySQL interface for perl > > php-mysql 4.0.4pl1-9 Development/Languages A module for PHP > applications that use MySQL databases. > > -- > > webmin says: > > MySQL Database Server > The MySQL admin program /usr/bin/mysqladmin was not found on your > system. Maybe MySQL is not installed, or your module configuration is > incorrect. > > > can this MySQL run as a server ? > where is a client > > [root@charly /]# /etc/rc.d/init.d/mysqld start > bash: /etc/rc.d/init.d/mysqld: No such file or directory > [root@charly /]# > > > > clueless, > > > > > Voytek Eymont > http://www.sbt.net.au/links/ > > > - > 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 - 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
Re: newbie installing MySQL/InnoDB on RH 7.1
On Thu, 28 Mar 2002 14:46:01 +0200, Egor Egorov wrote: >You must first install original MySQL (rpm) package and then you can >install MySQK-max RPM. You can read about mysqld-max at: > http://www.mysql.com/doc/m/y/mysqld-max.html > >If you want to use InnoDB tables you should specify InnoDB startup >options in my.cnf file, take a look at: > http://www.mysql.com/doc/I/n/InnoDB_start.html >You can find info about configuration parametrs and example if you >check this link. Egor, thanks ! I obviously misunderstood mysql.com's pages at: Downloads for the Max 3.23 version http://www.mysql.com/downloads/mysql-max-3.23.html MySQL has during the years grown to be a quite big and capable SQL server with a lot of useful extensions that can be enabled at compile time. As not all users will have use for all extensions, we have solved this by providing two different MySQL binaries. The standard MySQL 3.23 binary that is optimized for raw speed and without transactions. The MySQL-Max 3.23 binary which includes support for the most requested features, like support for Berkeley DB (BDB) and/or InnoDB tables. I took it as 'it's a stand alone, no need for non-max' thanks for the help, I'll try again, as I'm rather new to rpm thing, can you pls tell me: if I installed RedHat7.1, and, MySQL that came with RH CD; them I download latest MySQL rpm file: am I supposed to: rpm -UPGRADE OPTION rpm file; or rpm -INSTALL OPTION rpm file ? also, after I install MySQL 3.23 binary rpm, followed by MySQLMAX 3.23 binary rpm, and, edit the my.cnf as you note: do I end up with two MySQLd ? so, I can run either max, or, not max ? does these rpms include mysql client, or what do I need to d/l ? (doing the RH install, it has separate option for client, and mysqld, hence, I'm asking) - 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
newbie installing MySQL/InnoDB on RH 7.1
Voytek, Thursday, March 28, 2002, 6:54:13 PM, you wrote: VE> I've installed RedHat7.1 off RH7.1 CDs, also, installed MySQL that came with VE> it, VE> the installed MySQL did NOT have InnoDB support; VE> I then d/l off mysql.com VE> MySQL-Max-3.23.49a-1.i386.rpm VE> I installed it using: VE> rpm --install MySQL-Max-3.23.49a-1.i386.rpm VE> (I think that's how it's meant to be installed, I'm a newbie) VE> howver, on restart. the 'original CD revison' started, NOT, MAX VE> then, i tried starting MySQL-Max by explicitly calling it, it said: VE> 'you have wrong error files' VE> SO: VE> using webmin, I removed all mysql packages; VE> then, using webmin, installed MySQL-Max-3.23.49a-1.i386.rpm VE> now it tell me, the MySQL-Max-3.23.49a is only an extension: VE> VE> Optional MySQL server binary that supports features VE> like transactional tables. To active this binary, just install this VE> package after the MySQL package. VE> - VE> but, reading on mysql download page, implies, MySQL-Max-3.23.49a-1.i386.rpm VE> is all I need... VE> help VE> so, at this time: VE> accoriding to webmin I have: VE> Packages matching mysql VE> Package Class Description VE> MySQL-Max 3.23.49a-1 Applications/Databases MySQL - server with Berkeley DB VE> and Innodb support You must first install original MySQL (rpm) package and then you can install MySQK-max RPM. You can read about mysqld-max at: http://www.mysql.com/doc/m/y/mysqld-max.html If you want to use InnoDB tables you should specify InnoDB startup options in my.cnf file, take a look at: http://www.mysql.com/doc/I/n/InnoDB_start.html You can find info about configuration parametrs and example if you check this link. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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
newbie installing MySQL/InnoDB on RH 7.1
I need some newbie help... I've installed RedHat7.1 off RH7.1 CDs, also, installed MySQL that came with it, the installed MySQL did NOT have InnoDB support; I then d/l off mysql.com MySQL-Max-3.23.49a-1.i386.rpm I installed it using: rpm --install MySQL-Max-3.23.49a-1.i386.rpm (I think that's how it's meant to be installed, I'm a newbie) howver, on restart. the 'original CD revison' started, NOT, MAX then, i tried starting MySQL-Max by explicitly calling it, it said: 'you have wrong error files' SO: using webmin, I removed all mysql packages; then, using webmin, installed MySQL-Max-3.23.49a-1.i386.rpm now it tell me, the MySQL-Max-3.23.49a is only an extension: Optional MySQL server binary that supports features like transactional tables. To active this binary, just install this package after the MySQL package. - but, reading on mysql download page, implies, MySQL-Max-3.23.49a-1.i386.rpm is all I need... help so, at this time: accoriding to webmin I have: Packages matching mysql Package Class Description MySQL-Max 3.23.49a-1 Applications/Databases MySQL - server with Berkeley DB and Innodb support perl-DBD-MySQL 1.2215-1 Applications/CPAN A MySQL interface for perl php-mysql 4.0.4pl1-9 Development/Languages A module for PHP applications that use MySQL databases. -- webmin says: MySQL Database Server The MySQL admin program /usr/bin/mysqladmin was not found on your system. Maybe MySQL is not installed, or your module configuration is incorrect. can this MySQL run as a server ? where is a client [root@charly /]# /etc/rc.d/init.d/mysqld start bash: /etc/rc.d/init.d/mysqld: No such file or directory [root@charly /]# clueless, Voytek Eymont http://www.sbt.net.au/links/ - 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