Re: MySQL with InnoDB on a readonly filesystem.

2005-11-25 Thread Heikki Tuuri
23, 2005 7:32 PM Subject: Re: MySQL with InnoDB on a readonly filesystem. Ralph, Not sure why your trying to open a innodb file on a read-only filesystem. Personally I'd place the innod onto a read-write file syste, and grant the users connect and select priveleges only. -- MySQL General

Re: MySQL with InnoDB on a readonly filesystem.

2005-11-24 Thread Ralph Koning
Jeremy Cole wrote: Is it possible to run MySQL with InnoDB enabled on a readonly filesystem. We only intend to run some select query's on this server. I guess I can ask the obvious question. Why are you trying to use InnoDB, if your data/filesystem is read only? Why not use M

Re: MySQL with InnoDB on a readonly filesystem.

2005-11-23 Thread Jeremy Cole
Hi Ralph, Is it possible to run MySQL with InnoDB enabled on a readonly filesystem. We only intend to run some select query's on this server. I guess I can ask the obvious question. Why are you trying to use InnoDB, if your data/filesystem is read only? Why not use MyISAM instead? Re

MySQL with InnoDB on a readonly filesystem.

2005-11-23 Thread Ralph Koning
Hello, Is it possible to run MySQL with InnoDB enabled on a readonly filesystem. We only intend to run some select query's on this server. This is the errormessage from InnoDB Nov 23 13:36:30 aliao mysqld[16073]: InnoDB: Error number 30 means 'Read-only file system'. Nov 23

Re: problems starting MySQL with InnoDB tables

2005-05-16 Thread kevin korngut
PROTECTED]> wrote: [-- text/plain, encoding 7bit, charset: ISO-8859-1, 74 lines --] I'm attempting to configure mysql with InnoDB tables and I'm running into problems. And am using the following version of mysqld-max, Ver 4.0.18-Max for suse-linux on i686 (Source distribution) F

Re: problems starting MySQL with InnoDB tables

2005-05-13 Thread Gleb Paharenko
, charset: ISO-8859-1, 74 lines --] > > I'm attempting to configure mysql with InnoDB tables and I'm running > into problems. And am using the following version of mysqld-max, Ver > 4.0.18-Max for suse-linux on i686 (Source distribution) > > First I uncomment

problems starting MySQL with InnoDB tables

2005-05-13 Thread kevin korngut
I'm attempting to configure mysql with InnoDB tables and I'm running into problems. And am using the following version of mysqld-max, Ver 4.0.18-Max for suse-linux on i686 (Source distribution) First I uncommented the following lines in /etc/my.cnf: # Uncomment the following if you

Re: MySQL with InnoDB

2002-12-01 Thread Heikki Tuuri
Stefan, - Original Message - From: ""Stefan Sturm"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, December 01, 2002 1:33 PM Subject: MySQL with InnoDB > Hello, > > we are starting a new Projekt and we going to use MySQL with

MySQL with InnoDB

2002-12-01 Thread Stefan Sturm
Hello, we are starting a new Projekt and we going to use MySQL with InnoDB Tables. Which Version of MySQL should we use? 3.23.53 or 4.0.x? Which is the best Version for InnoDB-Tables? Thanks for your help, Stefan Sturm

Re: MySQL with InnoDb Tables - A Big Confusion

2002-10-21 Thread Scott Pippin
change your my.cnf to use the following variables:(I left our info in them for reference) innodb_data_file_path = ibdata1:400M innodb_data_home_dir = c:\ibdata innodb_log_group_home_dir = c:\iblogs innodb_log_arch_dir = c:\iblogs also make sure the MySQL my.cnf is place in the /etc directory in U

RE: Mysql with innodb support

2002-09-11 Thread Iago Sineiro
septiembre de 2002 8:41 Para: [EMAIL PROTECTED] Asunto: Mysql with innodb support I am setting up a web site with Linux (redhat 7.1), apache, php and mysql. I need the version of mysql with innodb support. Can anyone indicate to me what file or files I need to obtain to install thecorrect version

Mysql with innodb support

2002-09-10 Thread Peter Goggin
I am setting up a web site with Linux (redhat 7.1), apache, php and mysql. I need the version of mysql with innodb support. Can anyone indicate to me what file or files I need to obtain to install thecorrect version of mysql and where I can down load them? Thanks in advance Regards Peter

Refix my opinion (Was MySQL with InnoDB is not reliable ? :()

2001-11-15 Thread Ady Wicaksono
After investigating my system, MySQL database server and application, i found that something wrong with my configuration, Thanks a lot for Mr. Heikki Tuuri for helping me. Now, i do really believe that innodb is faster that myISAM, and more reliable, just remember that you have to configu

Re: MySQL with InnoDB is not reliable ? :(

2001-11-15 Thread Heikki Tuuri
;SEND-PR: will all comments (text enclosed in `<' and `>').SEND-PR: >From: [EMAIL PROTECTED]: [EMAIL PROTECTED] >Subject:mysql with innodb not reliable >Description: >05 09:58:46 mysqld started05 9:58:48 InnoDB: Started >/usr/sbin/mysqld: ready for con

MySQL with InnoDB is not reliable ? :(

2001-11-14 Thread Ady Wicaksono
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject:mysql with innodb not reliable >Descri

Re: compiling mysql with InnoDB for AMD Athlon cpu

2001-08-29 Thread Sinisa Milivojevic
Stanislav Dmitrenko writes: > G'day, > > Is it possible to compile mysql with InnoDB for AMD Athlon processor ? > Error produced during compilation follows: > > make[4]: Entering directory `/usr/local/src/mysql-3.23.41/innobase/sync' > gcc -DHAVE_CONFIG_H

compiling mysql with InnoDB for AMD Athlon cpu

2001-08-28 Thread Stanislav Dmitrenko
G'day, Is it possible to compile mysql with InnoDB for AMD Athlon processor ? Error produced during compilation follows: make[4]: Entering directory `/usr/local/src/mysql-3.23.41/innobase/sync' gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include -DDBUG_OFF -O3

Re:How to start mysql with innoDB.

2001-07-02 Thread Heikki Tuuri
Hi! Have you specified the InnoDB startup options in your my.cnf, in the [mysqld] section of my.cnf? You can look at the manual at http://ww.innodb.com where you see what kind of values you should specify. When InnoDB starts the first time it will say: InnoDB: The first specified data file /hom

RE: How to start mysql with innoDB.

2001-07-02 Thread Paul Linehan
> > We want to use the Windows GUI tool to connect to a database on > > a Linux box. > You have to grant privileges to user@ip_address and enter ip_address > in host table. Or grant privilege to user@"%". I entered these records by hand from the > ./mysql -u root -p mysql command line to

How to start mysql with innoDB.

2001-07-02 Thread Gerlinde Fischer
Hi, I need a transaction Database with Mysql. I have compiled the sourccode 3.23.39 the following on Linux. ./configure --with-innodb after that I have stopped and restartet mysql. but if I make "create table .. type=InnoDB"; I create a ISAM-Table. How can I make a InnoDB-Table. Please help.