On Fri, Sep 18, 2009 at 12:54 PM, Claudio Nanni wrote:
> Nice!
> Bit are you sure that database is nowhere in the information schema?
>
didn't think of that :-) Just checked, and the table in remotedb appears and
vanishes in information_schema.tables as you create and remove the symlink.
> And/
Nice!
Bit are you sure that database is nowhere in the information schema?
And/or innodb tablespace info
Claudio
Il giorno 18 set, 2009 11:30 m., "Johan De Meersman" ha
scritto:
You can do that at runtime no problem, you just need to do OS calls for it.
r...@soulcake-duck:/var/lib/mysql# *mysql
Meersman
Sent: 18 September 2009 10:30
To: Claudio Nanni
Cc: manasi.s...@artificialmachines.com; mysql@lists.mysql.com
Subject: Re: Mysql dynamic database location
You can do that at runtime no problem, you just need to do OS calls for
it.
r...@soulcake-duck:/var/lib/mysql# *mysqlshow
You can do that at runtime no problem, you just need to do OS calls for it.
r...@soulcake-duck:/var/lib/mysql# *mysqlshow*
++
| Databases |
++
| information_schema |
| mysql |
++
r...@soulcake-duck:/var/lib/mysql# *m
As far as I know, you can't,
you can do it with symbolic linking but not at run time.
So if you have a clue you can (pre)build empty databases using symbolic
linking and switching to the right one at run time.
Cheers
Claudio Nanni
2009/9/18 Manasi Save
> Hi All,
>
> Is it possible to change