* Nitin
> mysql doesn't support anything called rollback upto 4.0
This is not correct.
The concept of "rollback" is related to transactional table types, and both
InnoDB and BDB are available in the 3.23 version of mysql.
The first mention of "rollback" I could find in the manual was 3.23.17:
h
mysql doesn't support anything called rollback upto 4.0
Nitin
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "debug" <[EMAIL PROTECTED]>
Sent: Wednesday, October 15, 2003 8:37 PM
Subject: Re: assorted
* DeBug
> >> How does one restore a mysql database if it crashes in
> >> the middle of a large operation?
>
> RB> Not sure what you mean...
>
> What if i on purpose turn off the computer when mysql is in the middle of
> transaction execution ?
Then someone should smack your fingers...! ;)
> Will
>> How does one restore a mysql database if it crashes in
>> the middle of a large operation?
RB> Not sure what you mean...
What if i on purpose turn off the computer when mysql is in the middle of
transaction execution ? Will the server on restart automatically
rollback the crashed transaction ?
* Tofu Optimist
> Three questions from a Mysql newcomer
>
> Syntax question:
>
> Can a table in database A have a foreign key
> relationship with a table in database B? (both INNODB,
> both with appropriate indexes, etc)
Yes, but I suspect that you really meant foreign key constraints?
Constr
Hi
Three questions from a Mysql newcomer
Syntax question:
Can a table in database A have a foreign key
relationship with a table in database B? (both INNODB,
both with appropriate indexes, etc)
Architecture question:
What is the rule-of-thumb to use use multiple
databases, rather than
