(non-free) hot incremental binary backup program for
InnoDB which will be even faster than SELECT INTO OUTFILE. It will run in
background.
Regards,
Heikki
-Original Message-
From: Boaz Yahav <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc: Manuel Lemos <[
Hi!
In MySQL-4.0.0 you can delete from several tables in a join:
DELETE t1, t2 FROM t1, t2, t3 WHERE ...;
But 4.0.0 is still alpha, and it will take some months for it to
stabilize. No compact or defrag is normally needed with
MySQL.
Regards,
Heikki
http://www.innodb.com
Shaun Honsvick wrote
under
>development). This is NOT the version you want to use for mission-critical
>applications.
>
>When version 4.x, golden version, is released, then it might be usable.
>Along with INNODB.
Regards,
Heikki
Innobase Oy
>-Original Message-
>From: Heikki Tuuri [ma
Hi!
MySQL-3.23.44 -Max and MySQL-4.0.0 support foreign keys
through transactional InnoDB type tables.
Regards,
Heikki
http://www.innodb.com
Rick Emery wrote in message ...
>Quoting from the MySQL manual, section 6.5.3, CREATE TABLE Syntax:
>
>The FOREIGN KEY, CHECK, and REFERENCES clauses don'
Hi!
MySQL-3.23.44 and MySQL-4.0.0 support foreign keys
through transactional InnoDB type tables.
See http://www.innodb.com for more info.
Regards,
Heikki
Innobase Oy
Rita Mikusch wrote in message
<10C5C8152BD5D31181AC006008AD5F416886AD@NEWCA2>...
>Foreign Keys? No such luck! You need to check
Hi!
Have you set max_allowed_packet in my.cnf big enough?
Is the type of your column LONGBLOB? A BLOB can
only store 64 kB.
Regards,
Heikki Tuuri
http://www.innodb.com
Joao Barreto wrote in message ...
>
>I forgot to say that php.ini file has 8Mb set as the maximum
>possible upload
Hi!
InnoDB type tables in MySQL provide row level locking
and transactions.
See http://www.innodb.com
Regards,
Heikki Tuuri
Innobase Oy
Barry L. Jeung wrote in message ...
Just wondering if anyone has tried doing quasi application based locking
with PHP? My scenario is this. I