I don't think you should be deploying the ibdata1 file anywhere. You
should regard that file as part of the MySQL installation on a
particular machine. To deploy a database you should dump the database
using MySQLDump or similar and restore it to the target machine.
From: Gerry Whitmarsh [mailto:gerry.whitmarsh@stripped]
Sent: Monday, 11 January 2010 3:40 AM
Subject: How to have one data file per database
Hi, maybe this is a daft question and I am missing something, but here
I have two applications - app A and app B with two databases - db A and
db B. I have a server running and ODBC connections to the two databases.
I can run the applications and app A accesses db A and app B access db
B. I now need to deploy these two applications to two different users
but there is only one ibdata1 file.
Is there a way to keep the two databases apart and have one ibdata1(or
another name) file per database?
I have tried creating a new service pointing to a different ini file
where innodb_data_home_dir points to a different location but I just get
all kinds of errors.
I am running MySQL 5.1.
Any help would be greatly appreciated.
Life's journey is not to arrive at the grave safely, in a well-preserved
body, but rather to slide in sideways, totally worn out, shouting ****,
what a ride!!!