Hello Roger, [snip] > Yes, but is there really a big difference as long as the data is > on the same > disk & computer? I would keep PROD on a separate physical > machine... Yes, either on a separate physical machine or a different HDD (to curtail costs, I'd first go for HDD).
> If the > databases are in the same physical files or not will only matter if the > inndb format itself is insecure, as far as I can see... and if > you actually > could destroy one table by doing some illegal operation to another table > with innodb, I would simply not use it in PROD... :) I'm certain InnoDB is 100% safe. My concern is probably related to being unfamiliar with MySQL/InnoDB. However, I take Heikki's point of the access impact of DEV on PROD - never thought of that. BTW, Heikki also assisted me to get multiple instances of MySQL going. So all is exactly as per my requirements. Until another time. Kind regards Emmanuel --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php