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.

Re: innoDB confusion

2002-01-25 Thread Heikki Tuuri
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: This brings up an interesting point. If you've lost your .frm files, are you totally screwed, or does InnoDB contain

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

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 mind: In regards

RE: innoDB confusion

2002-01-15 Thread Rutledge, Aaron
: 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: Tuesday, January 15, 2002 7:13

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: innoDB confusion One final

Re: innoDB confusion

2002-01-15 Thread Heikki Tuuri
, 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 developer of the software to answer my questions--this is terrific. Is there way to verify

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, you can

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, Heikki Tuuri wrote: : Hi! : : Weaver

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 at the mysql prompt

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

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 again. Do

RE: innoDB confusion

2002-01-15 Thread Rutledge, Aaron
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 InnoDB than in MySQL. For example, a DATE column will appear

RE: innoDB confusion

2002-01-15 Thread Weaver, Walt
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 confusion Hi! Weaver

Re: innoDB confusion

2002-01-15 Thread John Kemp
PROTECTED]] Sent: Tuesday, January 15, 2002 11:18 AM To: [EMAIL PROTECTED] Subject: Re: innoDB confusion 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

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 Weaver