[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    Re: How to have one data file per database
From:       Gerry Whitmarsh <gerry.whitmarsh () gmail ! com>
Date:       2010-01-11 12:44:13
Message-ID: 9b0745551001110444g2f71f29sc2db4fc1afa4fbe5 () mail ! gmail ! com
[Download RAW message or body]


 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.
Gerry.

2010/1/11 White, Tony <Tony.White@thomsonlocal.com>

> Gerry,
>
> 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
>
> Tony White
> DBA - MIS SSG
> THOMSONLocal
> Tel : 01252 390063
> Email:tony.white@thomsonlocal.com <Email%3Atony.white@thomsonlocal.com>
> www.thomsonlocal.com
>
>
> -----Original Message-----
> From: Gerry Whitmarsh [mailto:gerry.whitmarsh@gmail.com]
> Sent: 11 January 2010 09:30
> To: win32@lists.mysql.com
> 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
> be
> nice to keep the environments separate on my box.
>
> Gerry.
>
> 2010/1/10 Bonnett, John <John.Bonnett@vision.zeiss.com>
>
> > 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@gmail.com]
> > Sent: Monday, 11 January 2010 3:40 AM
> > To: win32@lists.mysql.com
> > 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
> 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.
> > Gerry.
> >
> > --
> > 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!!!
> >
>
>
>
> --
> 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.
> 902438
>



-- 
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!!!


[prev in list] [next in list] [prev in thread] [next in thread]