primary keys

[kwyjibo]

I created a bunch of tables in SQLyog and some of them are fairly lengthy too.

When I was assigning row formats and the assorted stuffs, I couldnt find out a way to specify the primary key in each table.

Is this just an intrinsic limitation of SQLyog?

Am I gonna have to use the dreaded CLI? 🙂

Worse, am I going to have to “RECREATE” all those tables?

Plus, while I have your attention, how do I check for InnoDB's support/presence in mySQL?

My many frustrated attempts to change from myISAM to InnoDB is getting annoying.

This is all on RH8 btw.

[kwyjibo]

Boy am I red in the face.

PK = Primary Key, correct?

Argh…

Well, at least this only leaves me with the innoDB thing.

My attempts to change to innoDB on the command line have been frustrating too.

I can only hope the solution to this is as simple as my previous one.

[Ritesh]

Yes !!! To assign PRIMARY KEY property to a column check the corresponding PK checkbox.

Which version of MySQL are your running?

[Shadow]

To change the table type right click on the table name in the object explorer and select “Change table type to” and specify the desired type. Of course, you must have correct InnoDB settings, but that's in the my.ini or my.cnf.

[kwyjibo]

Thanks Ritesh,

Hope I didnt ruffle your feathers too much on the PK thing 🙂

I usually RTFM before I ask a question, but I guess I didnt catch the PK thing immediately when flipping thru the documentation.

I am running whatever the latest version of mysql is available for download from the mySQL website which I think is 4.0

I read in the mySQL manual that innoDB is ready to go by default upon installation of 4.0

Is that possibly not the case?

Shadow, I actually went to /etc and looked at that the my.cnf file and there is no mention of anything innoDB in the file.

I guess this means I somehow changed the default settings during installation of mySQL 4.0 such that I disabled innoDB?

[Shadow]

InnoDB is enabled by default. I don't even know, whether you can disable it or not. You should check the mysql.err file (data directory) to see any error messages concerning InnoDB. But the best is to read MySql's manual about InnoDB first. A few hints:

innodb_data_file_path = ibdata1:20M:autoextend:max:1000M

innodb_data_home_dir = path

innodb_log_group_home_dir =path

innodb_log_arch_dir = path

set-variable = innodb_mirrored_log_groups=1

set-variable = innodb_log_files_in_group=3

set-variable = innodb_log_file_size=5M

set-variable = innodb_log_buffer_size=2M

innodb_flush_log_at_trx_commit=1

innodb_log_archive=0

set-variable = innodb_buffer_pool_size=10M

set-variable = innodb_additional_mem_pool_size=2M

set-variable = innodb_file_io_threads=4

set-variable = innodb_lock_wait_timeout=50

[Author]

Posts