Yes, this is the way I am going to go. I was having problems with blobs but
I have just found a fix (--hex-blob) so I am going to keep dumps of the
databases and run them when installing.
Thanks all of you for the help.
2010/1/11 White, Tony <Tony.White@stripped>
> Good luck, but I do tend to agree with John - make a restore of a
> mysqldump as part of the install process - you would have better data
> integrity that way.
> Tony White
> DBA - MIS SSG
> Tel : 01252 390063
> Email:tony.white@stripped <Email%3Atony.white@stripped>
> -----Original Message-----
> From: Gerry Whitmarsh [mailto:gerry.whitmarsh@stripped]
> Sent: 11 January 2010 09:30
> To: win32@stripped
> Subject: Re: How to have one data file per database
> Hi Guys,
> Thanks a lot for the replies. @Tony, if I know it is possible I will
> persevere, thanks. @John, I definitely agree but it is so much easier to
> supply the data file with the fixed tables already filled. Also it would
> nice to keep the environments separate on my box.
> 2010/1/10 Bonnett, John <John.Bonnett@stripped>
> > 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.
> > John Bonnett
> > -----Original Message-----
> > From: Gerry Whitmarsh [mailto:gerry.whitmarsh@stripped]
> > Sent: Monday, 11 January 2010 3:40 AM
> > To: win32@stripped
> > Subject: How to have one data file per database
> > Hi, maybe this is a daft question and I am missing something, but here
> > goes.
> > I have two applications - app A and app B with two databases - db A
> > db B. I have a server running and ODBC connections to the two
> > 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
> > all kinds of errors.
> > I am running MySQL 5.1.
> > Any help would be greatly appreciated.
> > Gerry.
> > --
> > Life's journey is not to arrive at the grave safely, in a
> > body, but rather to slide in sideways, totally worn out, shouting
> > what a ride!!!
> 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!!!
> The opinions expressed are those of the individual and not the company.
> Internet communications are not secure and therefore Thomson Directories
> Limited ("the company") does not accept liability for any claims arising as
> a result of the use of this medium for transmissions by or to the company.
> This email and any files transmitted with it are confidential. If you are
> not the intended recipient, you are hereby notified that any disclosure,
> distribution or copying of this communication is strictly prohibited.
> Whilst we take every reasonable precaution to screen out computer viruses
> from emails, attachments to the email may contain such viruses. We cannot
> accept liability for loss or damage resulting from such viruses.
> Thomson Directories Ltd. Registered Office: Thomson House, 296 Farnborough
> Road, Farnborough, Hants. GU14 7NU. Incorporated in England. Registered No.
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!!!