Re: Mysql dynamic database location

2009-09-18 Thread Claudio Nanni
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 manasi.s...@artificialmachines.com Hi

Re: Mysql dynamic database location

2009-09-18 Thread Johan De Meersman
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#

RE: Mysql dynamic database location

2009-09-18 Thread Andrew Braithwaite
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

R: Re: Mysql dynamic database location

2009-09-18 Thread Claudio Nanni
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 vegiv...@tuxera.be ha scritto: You can do that at runtime no problem, you just need to do OS calls for it.

Re: R: Re: Mysql dynamic database location

2009-09-18 Thread Johan De Meersman
On Fri, Sep 18, 2009 at 12:54 PM, Claudio Nanni claudio.na...@gmail.comwrote: 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