I don't think using a dot is a good idea - that's the table.field separator.
On Fri, Feb 19, 2010 at 12:41 PM, Manasi Save <
> Hi Johan,
> Some time back you have solved my problem of creating symlink as database
> was fixed. But now When I am putting special characters in symlinks like "."
> it is not readable as database. If I am creating database with special
> characters from mysql command line I can create it but an symlink with
> special character is not readable.
> Is it possible that I can read a symplink with special characters as
> Thanks in advance.
> Manasi Save
> Quoting Johan De Meersman <vegivamp@stripped>:
>> Given that you're talking about "quite a few" folders, I think it'd be
>> to check up on the theoretical and practical limits for your filesystem of
>> choice, though - ext2 for example starts getting noticeably slower when
>> have a lot more than 10.000 entries in the same directory. One way of
>> getting around that would be segmenting your database names in blocks of
>> three or so (so "database" would be stored under dat/aba/se/<datafiles>).
>> Takes a bit of management, but then you already have something in place to
>> create the symlinks anyway.
>> Also, as a matter of manageability, I'd not put your real database dirs
>> somwhere where there is other stuff - make a separate directory and keep
>> them all there.
>> Another point of note, but I suppose you already know that, is that this
>> will not work with InnoDB unless you have the file-per-table option
>> -- Bier met grenadyn
>> Is als mosterd by den wyn
>> Sy die't drinkt, is eene kwezel
>> Hy die't drinkt, is ras een ezel
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel