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 one huge database with many tables? Is splitting one database into multiple databases just a way to organize data (eg I use folders and subfolders on my file system, not everything is at root) or are there performance / security / reliablity / backup / other issues? System question: Mysql doesn't use transaction logs, does it? How does one restore a mysql database if it crashes in the middle of a large operation? Thanks TO __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]