Re^3: DBI/MySQL/MariaDB clone tables across DB Connections

But on MyISAM transactions and rollbacks are not supported

They are also quite old and can be unstable. I never did find out why but I had some intermittent data loss from MyISAM so I am now using Aria tables instead, or InnoDB if I really need to enforce referrential integrity (which is rare).

The only downside I have found with the Aria storage engine is that MySQL Workbench doesn't recognise them so can't generate forward engineered code. But that has the positive of improving my DDL familiarity which had got very rusty!

Comment on Re^3: DBI/MySQL/MariaDB clone tables across DB Connections Select or Download Code

Replies are listed 'Best First'.
Re^4: DBI/MySQL/MariaDB clone tables across DB Connections by LanX (Saint) on Apr 06, 2023 at 21:58 UTC
> They are also quite old and can be unstable. I'm not the one to decide how my client wants to footgun himself despite my warnings ... =) Cheers Rolf _{(addicted to the 𐍀𐌴𐍂𐌻 Programming Language :) Wikisyntax for the Monastery}	[reply]