Re: looks like one database from the outside, but it's two inside

And unfortunately I don't know enough about MySQL to be more helpful.
Database links may be an Oracle-only thing.

On 7/19/07, Theron Stanford <shixilun@xxxxxxxxx> wrote:
This sounds like a good idea. I guess I just don't know enough about
databases yet to know how to do this linking. Mostly I just know
about how to get DBI to interact with MySQL.

I should mention that I'd also like to be able to make some rules in
the "real" database temporarily disappear while testing, but I fear
this will make things even more complicated.

On 7/19/07, Sven Miller <ngdvakigyotuia@xxxxxxxxx> wrote:
> I would consider setting up the test database to consist of a database
> link to the "real" database, along with views for all the tables.
> Then on those tables where I wanted to interject some data, I would
> create test-data tables and alter the views to merge the data.
>
> Then switching from "test" to "real" is a matter of changing where you
> connect to. Alternately, you could change the views to only
> incorporate test-data if a certain flag is set in yet another test
> table.
>

.

Relevant Pages

  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)
  • ANN: Database Designer for MySQL version 1.6 is released
    ... The new version 1.6 of MicroOLAP Database Designer for MySQL has been ... The secure shell (SSH) tunneling is now implemented in Database ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: PICK OPENDB provides connection in shopping cart startup
    ... we MIS folks are required to take on tasks that we don't ... developer, nor the database. ... Why do you need MySQL?. ... in size that KTP experienced, evolving to the current 90,000+ sq. ...
    (comp.databases.pick)
  • Re: Java and MySql program example ?
    ... > I am trying to learn Java and need an example program with MySql ... > MySql database. ... Database connection established ...
    (comp.lang.java.programmer)
  • Re: Creating Mysql DB with PHP
    ... >> userID and password for that MySQL server. ... > I am only going by what I have to do when setting up a new database. ...
    (alt.php)