newbie installing MySQL/InnoDB on RH 7.1

2002-03-28 Thread Egor Egorov

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




Re: newbie installing MySQL/InnoDB on RH 7.1

2002-03-28 Thread voytek

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




Re: newbie installing MySQL/InnoDB on RH 7.1

2002-03-28 Thread Curtis Maurand


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

2002-03-28 Thread Egor Egorov

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




newbie installing MySQL/InnoDB on RH 7.1

2002-03-27 Thread Voytek Eymont

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