[Neshi]

Do you mean I should create a schema for the database in html and send it to you???

Sorry, I have no homepage to show the shema there 🙁 🙁 🙁

I have one question: is it possible at all to use MySQL 3.23 – max – nt and use the foreign keys properly?

[Neshi]

I need help!!! It is not working at the moment!!!

Here a copy of the table information

Table 1:

Column Information For – datenstand

---

Field Type Null Key Default Extra

---

---

---

---

---

---

Datenstand_ID bigint(6) unsigned PRI (NULL) auto_increment

Datenstand varchar(50) YES 0

Baureihe_ID bigint(6) unsigned MUL 0

Index Information For – datenstand

---

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment

---

---

---

---

---

---

---

---

---

---

datenstand 0 PRIMARY 1 Datenstand_ID A 6 (NULL) (NULL)

datenstand 0 DatenstandID 1 Datenstand_ID A 6 (NULL) (NULL)

datenstand 1 Baureihe_ID 1 Baureihe_ID A 2 (NULL) (NULL)

DDL Information For – datenstand

---

Table Create Table

---

---

datenstand CREATE TABLE `datenstand` (

`Datenstand_ID` bigint(6) unsigned NOT NULL auto_increment,

`Datenstand` varchar(50) default '0',

`Baureihe_ID` bigint(6) unsigned NOT NULL default '0',

PRIMARY KEY (`Datenstand_ID`),

UNIQUE KEY `DatenstandID` (`Datenstand_ID`),

KEY `Baureihe_ID` (`Baureihe_ID`)

TYPE=InnoDB ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 21504 kB'

Information table 2:

Column Information For – baureihe

---

Field Type Null Key Default Extra

---

---

---

---

---

---

Baureihe_ID bigint(6) unsigned PRI (NULL) auto_increment

Baureihe varchar(50) YES 0

Index Information For – tolassist.baureihe

---

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment

---

---

---

---

---

---

---

---

---

---

baureihe 0 PRIMARY 1 Baureihe_ID A 4 (NULL) (NULL)

baureihe 0 BaureiheID 1 Baureihe_ID A 4 (NULL) (NULL)

baureihe 1 Baureihe_ID 1 Baureihe_ID A 4 (NULL) (NULL)

DDL Information For – baureihe

---

Table Create Table

---

---

baureihe CREATE TABLE `baureihe` (

`Baureihe_ID` bigint(6) unsigned NOT NULL auto_increment,

`Baureihe` varchar(50) default '0',

PRIMARY KEY (`Baureihe_ID`),

UNIQUE KEY `BaureiheID` (`Baureihe_ID`),

KEY `Baureihe_ID` (`Baureihe_ID`)

TYPE=InnoDB

I want to have a relationship between the Baureihe_IDs! Baureihe_ID should be foreign key in the table datenstand !!!!!!!!

I hope somebody can help me 😮 😮 😮

[Neshi]

I am really glad that I solved the problem! I really hope it is working! I will test the database soon….

Well it was really a little bit tricky to use the inno tables… I changed the my.ini, but it is not working exactly! For example the logs are not saved to my iblog directorty but in another directory. It seems as if it's not reading the ini file correctly…

[Neshi]

I solved the problem! I created lots of indices (sometimes twice or three times, now I have to find out which one I can delete!). I am using InnoDB table type and MySQL 3.23-max-nt!!!!

[Neshi]

I can't create foreign keys!

I always get the following message:

Could not create relation. The possible causes of error are –

1) the reference table does not have InnoDB table handler

2) no index was found on selected columns. you need to explicitly create index on selected columns

3) the selected columns will create incorrect foreign defination

5)you did not select correct columns

4) selected columns were not found in the reference table.

@CalEvans: what do you mean with build the index first? Every column I want to use for foreign key has an index!!! What kind of index does it have to be?

@Medozas: I don't understand what I should show you? Do you want to have all tables with their properties?!

Thank you!!!!!!!!!!!

[Neshi]

Well, this is excactly what they write on the innodb homepage!!!!!!!

[Neshi]

Well, everything right in there!

[Neshi]

MySQL Control Center???

Do you mean the Winmysqladmin?

[Neshi]

more information: it seems as if its working sometimes! i found an iblogfile in my datadir (well, it shouldn't be there as I created a directory for the iblogs).

But the my.ini is not working with the values and options I found in the manual…

[Neshi]

okay, thank you so much for your reply!

I am using windows!

What kind of information should i get from the permission box?

[Neshi]

Ritesh, it is not working with those options:

[mysqld]

datadir=C:/mysql/data

innodb_data_file_path=ibdata1:30M:autoextend

innodb_data_home_dir=C:/mysql/ibdata

default-table-type = innodb

innodb_log_file_path = C:/mysql/iblogs

set-variable = innodb_buffer_pool_size=80M

set-variable = innodb_additional_mem_pool_size = 20M

set-variable = innodb_log_file_size = 20M

set-variable = innodb_log_buffer_size = 8:

innodb_flush_log_at_trx_commit = 1

I can't connect to MySQL and it ist not possible to start the MySQL manually!!!

I tried this:

[mysqld]

datadir=C:/mysql/data

innodb_data_file_path=ibdata1:30M:autoextend

innodb_data_home_dir=C:/mysql/ibdata

#default-table-type = innodb

#innodb_log_file_path = C:/mysql/iblogs

#set-variable = innodb_buffer_pool_size=80M

#set-variable = innodb_additional_mem_pool_size = 20M

#set-variable = innodb_log_file_size = 20M

#set-variable = innodb_log_buffer_size = 8:

#innodb_flush_log_at_trx_commit = 1

and it is working!? So there must be a problem?!

[Neshi]

I forgot: It is still not possible to manage the relationships.

[Neshi]

okay done!

Thank you so much!

are there any more values/options I should in put in my.ini?

[Neshi]

innodb_log_file_path = C:/mysql/log

is this okay?

[Neshi]

where do I have to create the log directory???

On C: or on C:mysql or somewhere else???

[Author]

Posts