Re: innoDB confusion

2002-01-25 Thread Heikki Tuuri
L PROTECTED]> To: Heikki Tuuri <[EMAIL PROTECTED]> Cc: Philip Molter <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, January 25, 2002 10:22 AM Subject: Re: innoDB confusion >On Tue, Jan 15, 2002 at 08:36:16PM +0200, Heikki Tuuri wrote: >> >

Re: innoDB confusion

2002-01-25 Thread Jeremy Zawodny
On Tue, Jan 15, 2002 at 08:36:16PM +0200, Heikki Tuuri wrote: > > > >This brings up an interesting point. If you've lost your .frm > >files, are you totally screwed, or does InnoDB contain enough > >information to restore those .frm files? It's not a big deal if > > With some work, yes. innodb_

RE: innoDB confusion

2002-01-15 Thread Weaver, Walt
Cool. Thanks, John. --Walt -Original Message- From: John Kemp [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 1:06 PM To: Weaver, Walt Cc: [EMAIL PROTECTED] Subject: Re: innoDB confusion Walt, It'll go to the database_machine_name.err file on that machine. John W

Re: innoDB confusion

2002-01-15 Thread John Kemp
fused In Bozeman > > -Original Message- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 15, 2002 11:18 AM > To: [EMAIL PROTECTED] > Subject: Re: innoDB confusion > > > Hi! > > "Weaver, Walt" wrote in message ... >

RE: innoDB confusion

2002-01-15 Thread Weaver, Walt
m confused as to how I capture this. I'm running on Linux Redhat 6.2 with the 2.4 kernel, mysql 3.23.44. Thanks, -- Confused In Bozeman -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 11:18 AM To: [EMAIL PROTECTED] Subject: Re: innoDB

RE: innoDB confusion

2002-01-15 Thread Rutledge, Aaron
12:24 PM To: [EMAIL PROTECTED] Subject: Re: innoDB confusion Aaron, "Rutledge, Aaron" wrote in message ... > >Woah... > >Heikki Tuuri wrote: >"With some work, yes. innodb_table_monitor prints the internal schema of >InnoDB. There are fewer column types inside I

Re: innoDB confusion

2002-01-15 Thread Heikki Tuuri
Aaron, "Rutledge, Aaron" wrote in message ... > >Woah... > >Heikki Tuuri wrote: >"With some work, yes. innodb_table_monitor prints the internal schema of >InnoDB. There are fewer column types inside InnoDB than in MySQL. For >example, a DATE column will appear as an integer." > >Now I am confused

Re: innoDB confusion

2002-01-15 Thread Rutledge, Aaron
Woah... Heikki Tuuri wrote: "With some work, yes. innodb_table_monitor prints the internal schema of InnoDB. There are fewer column types inside InnoDB than in MySQL. For example, a DATE column will appear as an integer." Now I am confused again. Do you only have access to column types specifi

RE: innoDB confusion

2002-01-15 Thread Rutledge, Aaron
Molter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 11:24 AM To: Heikki Tuuri Cc: [EMAIL PROTECTED] Subject: Re: innoDB confusion On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heikki Tuuri wrote: : Hi! : : "Weaver, Walt" wrote in message ... : >Do a "show table status&qu

Re: innoDB confusion

2002-01-15 Thread Heikki Tuuri
Hi! -Original Message- From: Philip Molter <[EMAIL PROTECTED]> To: Heikki Tuuri <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, January 15, 2002 8:24 PM Subject: Re: innoDB confusion >On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heik

Re: innoDB confusion

2002-01-15 Thread Philip Molter
On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heikki Tuuri wrote: : Hi! : : "Weaver, Walt" wrote in message ... : >Do a "show table status" at the mysql prompt. Under "type" you should see : >InnoDB. : : Yes, and in really problematic situations, where you have lost your .frm : files, for example, y

Re: innoDB confusion

2002-01-15 Thread Heikki Tuuri
>From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, January 15, 2002 10:57 AM >To: Mysql List (E-mail) >Subject: RE: innoDB confusion > > >One final question, and I am done. You have helped me >tremendously--thank you. Wow, I really didn't expect the develop

Re: innoDB confusion

2002-01-15 Thread John Kemp
lespace? Aaron > > > > -Original Message- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 15, 2002 10:43 AM > To: Rutledge, Aaron > Cc: [EMAIL PROTECTED] > Subject: Re: innoDB confusion > > > Aaron, > > -Original

RE: innoDB confusion

2002-01-15 Thread Weaver, Walt
Do a "show table status" at the mysql prompt. Under "type" you should see InnoDB. --Walt Weaver Bozeman, Montana -Original Message- From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 10:57 AM To: Mysql List (E-mail) Subject: RE: in

RE: innoDB confusion

2002-01-15 Thread Rutledge, Aaron
ssage- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 10:43 AM To: Rutledge, Aaron Cc: [EMAIL PROTECTED] Subject: Re: innoDB confusion Aaron, -Original Message- From: Rutledge, Aaron <[EMAIL PROTECTED]> To: Heikki Tuuri <[EMAIL PROTECTED]> Date:

Re: innoDB confusion

2002-01-15 Thread Heikki Tuuri
Aaron, -Original Message- From: Rutledge, Aaron <[EMAIL PROTECTED]> To: Heikki Tuuri <[EMAIL PROTECTED]> Date: Tuesday, January 15, 2002 7:13 PM Subject: RE: innoDB confusion >Thank You Heikki, > That information helps a lot. A couple quick questions if you dont &g

Re: innoDB confusion

2002-01-15 Thread Heikki Tuuri
Aaron, please look at http://www.innodb.com/features.html, http://www.innodb.com/division.html, and http://www.innodb.com/ibman.html Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and la