Much thanks, that did the trick.
Pierre
Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
P. Evans wrote:
> skip-innodb is commented out,thats why its not in the options I sent
> previously.
> The logs are showing something peculiar -
> InnoDB: Error: log file ./ib_logfile0 is of different si
P. Evans wrote:
skip-innodb is commented out,thats why its not in the options I sent
previously.
The logs are showing something peculiar -
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
ls shows
skip-innodb is commented out,thats why its not in the options I sent
previously.
The logs are showing something peculiar -
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
ls shows :
drwxr-x--- 2
Hello.
> Anywhere else I can check for that ?
Send the output of 'show variables'. I'm especially interested
in version, and have_innodb. Are there any lines in the error
log similar to "InnoDB: Started"? BTW, options to MySQL Server
could be passed in several different ways:
http://dev
P. Evans wrote:
Shawn,
as far as I can tell, no. Here's all my innodb options set in my.cnf :
Well, it's easy to check:
grep skip-innodb my.cnf
Is there anything interesting in the logs, maybe on MySQL startup?
Jasper
--
MySQL General Mailing List
For list archives: http://lists
Shawn,
as far as I can tell, no. Here's all my innodb options set in my.cnf :
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 4G
innodb_data_file_path = ibdata1:10M:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1
inno
Is your server configured with "skip-innodb" ? It's an option that turns
off support to that engine forcing it to elect a different method of
storage.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"P. Evans" <[EMAIL PROTECTED]> wrote on 11/10/2005 10:10:44 AM:
> Here's a
Here's an example :
mysql> create table petest (col1 integer,col2 char(5)) engine=innodb;
Query OK, 0 rows affected, 1 warning (0.07 sec)
mysql> show warnings
-> ;
+-+--++
| Level | Code | Message
P. Evans wrote:
Whenever I try to create a table using innodb, i get a 1266 warning that the
table has been created with myisam instead. I receive the error both at the
mysql command line and using the mysql query browser.
Can you please show us the CREATE TABLE command that you are using?
Whenever I try to create a table using innodb, i get a 1266 warning that the
table has been created with myisam instead. I receive the error both at the
mysql command line and using the mysql query browser.
I've also tried alterring the table to change the engine , which says it
complet
MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, October 02, 2003 5:39 PM
Subject: Creating InnoDB tables with ansi option fails
> >Description:
> I have a mysql serv
>Description:
I have a mysql server running with ansi option.
When I run my database create script I get:
ERROR 1005: Can't create table './pinball/B.frm' (errno: 150)
This seems to indicate that that:
150 = Foreign key constraint is incorrectly formed
David,
Wednesday, November 06, 2002, 10:00:45 PM, you wrote:
DAF> - Original Message -
DAF> From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
DAF> To: <[EMAIL PROTECTED]>
DAF> Sent: Wednesday, November 06, 2002 11:47 AM
DAF> Subject: re: Probl
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 11:47 AM
Subject: re: Problem creating InnoDB tables.
> David,
> Tuesday, November 05, 2002, 4:05:57 PM, you wrote:
>
> DAF
David,
Tuesday, November 05, 2002, 4:05:57 PM, you wrote:
DAF> I'm have trouble creating InnoDB tables. I'm using MySQL version
DAF> 3.32.51-max. I have "innodb_data_file_path = ibdata1:30M:autoextend" in my
DAF> "my.ini" file. According to the manual,
Hello,
I'm have trouble creating InnoDB tables. I'm using MySQL version
3.32.51-max. I have "innodb_data_file_path = ibdata1:30M:autoextend" in my
"my.ini" file. According to the manual, I should be able to use and create
InnoDB tables. When I specify "
: Demirchyan Oganes-AOD098 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 12:07 PM
To: '[EMAIL PROTECTED]'
Subject: Creating InnoDB tables
Hello everyone,
I really need your help. I have been stuck for couple of days on trying to
setup MySQL server such, that it supports Inn
Hello everyone,
I really need your help. I have been stuck for couple of days on trying to setup
MySQL server such, that it supports InnoDB tables. First of all I copy the following
into my.ini after [mysqld]
innodb_data_file_path = ibdata1:2000M
innodb_data_home_dir = c:\ibdata
set-variabl
18 matches
Mail list logo
