Hello.
I don't know if it is a good idea, but at least check that you have the
same version of MySQL on Linux. On Windows, lower_case_table_names is
set to 1 by default. See:
http://dev.mysql.com/doc/mysql/en/moving.html
Marcin Lewandowski <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've
Marcin,
- Original Message -
From: "Marcin Lewandowski" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Sunday, April 24, 2005 4:36 AM
Subject: Using InnoDB on 2 OSes
Hi,
I've got Win2k on one FAT32 partition, and I use MySQL 4.0.23 there.
I've got gentoo linux on second pa
I can use innodb in Redhat9 but failed in redhat 7.2. I find the
version of mysql in both redhat is identical. I wonder why it is the
case.
Version of mysql
mysqladmin Ver 8.23 Distrib 3.23.56, for redhat-linux-gnu on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This
On Wed, Jul 30, 2003 at 12:34:54PM +0800, unplug wrote:
> I use rpm to update the previous version. I can use innodb in redhat 9
> with version 2.23.56. But it failed in redhat 7.2. I wonder it is the
> kernel problem.
Why would you suspect the kernel? How did it fail?
> BTW, I want to ask
I use rpm to update the previous version. I can use innodb in redhat 9
with version 2.23.56. But it failed in redhat 7.2. I wonder it is the
kernel problem.
BTW, I want to ask whether I can do replication in the following case.
innodb (master) --replication --> myisam (slave)
unplug
Jerem
On Tue, Jul 29, 2003 at 03:08:42PM +0800, unplug wrote:
> Hi all,
>
> I am trying to use mysql with innodb. After I set it up as follow.
> The db start failed.
> I wonder why it failed to use innodb. Does anyone can tell me?
>
> OS: redhat 7.2 with kernel 2.4.20-18.7
> mysql version: 3.23.
Deryck,
in MySQL -Max the only thing that differs from
MySQL is the binary mysqld. To install MySQL -Max
in place of MySQL you only need to replace the binary.
You do not need to uninstall MySQL-3.23.41.
If you have defined InnoDB options in my.cnf like
explained in the manual http://www.innodb.
: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Using InnoDb table type - Urgent help required
At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote:
>innodb_data_file_path=ibdata1:200M
>innodb_data_home_dir=f:/mysql/innodb/ibdata
>innodb_log_group_home_dir=f:/mysql/innodb/iblogs
>
>
At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote:
>innodb_data_file_path=ibdata1:200M
>innodb_data_home_dir=f:/mysql/innodb/ibdata
>innodb_log_group_home_dir=f:/mysql/innodb/iblogs
>
>The directories specified in the above variables exist.
>However when I try to run the service I get the error "C
George,
the default in MySQL is
set autocommit = 1;
To be able to do rollbacks you have to execute
set autocommit = 0;
Then you can do
insert into ...;
rollback;
I assume you specified in CREATE TABLE ... (...) TYPE=INNODB?
Regards,
Heikki
Copied message:
.
Hello everybody
10 matches
Mail list logo
