mysql mysql 28 2010-08-30 13:28 blbl.MYI ->
/var/lib/mysql/test/blbl.MYI
-rw-rw 1 mysql mysql 65 2010-08-30 13:24 db.opt
I really need those symlinks, is there a way to make them working like
before ? ( old MySQL-server is fine )
You cannot share one set of files (one table) betwee
r-5.0 5.0.51a-24+lenny4 MySQL
database server binaries
On 02/09/2010 16:18, Daevid Vincent wrote:
-Original Message-
From: Julien Lory [mailto:julien.l...@gmail.com]
Sent: Thursday, September 02, 2010 12:31 PM
To: mysql@lists.mysql.com
Subject: Symlink
> -Original Message-
> From: Julien Lory [mailto:julien.l...@gmail.com]
> Sent: Thursday, September 02, 2010 12:31 PM
> To: mysql@lists.mysql.com
> Subject: Symlinks not working when pointing to another table.
>
> Hello,
>
> I've done lot of researc
->
/var/lib/mysql/test/blbl.MYI
-rw-rw 1 mysql mysql 65 2010-08-30 13:24 db.opt
I really need those symlinks, is there a way to make them working like
before ? ( old MySQL-server is fine )
Thanks,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
Hi,
On Mon, Feb 22, 2010 at 10:40 AM, Johan De Meersman wrote:
> I don't think using a dot is a good idea - that's the table.field separator.
Right. Even if mysqld didn't complain about the directory name, just
try using a '.' character in an identifier. It's a syntax error, no
matter how it's
t; 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
efman/5.0/en/innodb-restrictions.html
> -Original Message-
> From: Manasi Save [mailto:manasi.s...@artificialmachines.com]
> Sent: Friday, February 19, 2010 4:20 AM
> To: mysql@lists.mysql.com
> Subject: Re: Using symlinks for database creation in mysql
>
> Hi All,
sql50#User.Name
Can anyone help me on how to resolve this error.
Please Help.
Thanks in advance.
--
Regards,
Manasi Save
Quoting 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
symli
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
irectory. 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/).
Takes a bit of management, but then you already have something in place to
create the symlinks anyway.
Also, as a matter of manage
thousands) of symlinks
frequently and performs very little actual access work (small files), then
there will be a potential significant overhead.
On Fri, Jan 29, 2010 at 12:20 PM, prabhat kumar wrote:
> I don't agree, Don't have any specific documents but seems to make a bit
>
ry.
>
> Thanks
> Suresh Kuna
> MySQL DBA
>
> On Fri, Jan 29, 2010 at 11:56 AM, Manasi Save <
> manasi.s...@artificialmachines.com> wrote:
>
> > Hi All,
> >
> >
> > I am creating symlinks as database.
> >
> > I have mysql data director
Not a problem as you are doing it from a whole data directory.
Thanks
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 11:56 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi All,
>
>
> I am creating symlinks as database.
>
> I have mysql data directory c
Hi All,I am creating symlinks as database. I
have mysql data directory created on /var/lib/mysql/databasename.on the same path I am creating /var/lib/mydatabaseand creating
symlink from /var/lib/mydatabase to
/var/lib/mysql/databasenamewill there any performance
issues as there will be quite a
Hi all
i am working on mysql 4.0 on netware OS.
in the my.cnf file i removed the skip-symlink option under mysqld
program.
then i used the following query:
mysql>create table temp ( id int auto increment primary key,
name varchar(20) not null)
data directory = 'sys:/etc';
the table is created b
Hi all
i am working on mysql 4.0 on netware OS.
in the my.cnf file i removed the skip-symlink option under mysqld
program.
then i used the following query:
mysql>create table temp ( id int auto increment primary key,
name varchar(20) not null)
data directory = 'sys:/etc';
the table is created b
Christian,
Friday, June 21, 2002, 5:42:58 PM, you wrote:
CH> Is a restart/reload or a "flush tables" necessary when creating or removing
CH> databases?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita
Hello
Is a restart/reload or a "flush tables" necessary when creating or removing
databases?
bye,
-christian-
cookie-for-the-robot: sql,query
--
Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0
[EMAIL PROTECTED] Internet & Security for ProfessionalsFax 024
ECTED]
Betreff: Symlinks
Setup mysql a few months back as a backend to radius.
Welp, one thing that caught my attention last week was disk space.
I have mysql going to /usr/local/var (default for mysql I believe)
At any rate when this machine was setup it was given a 15GB /var
partition
and
Setup mysql a few months back as a backend to radius.
Welp, one thing that caught my attention last week was disk space.
I have mysql going to /usr/local/var (default for mysql I believe)
At any rate when this machine was setup it was given a 15GB /var partition
and just over 1GB for /
20 matches
Mail list logo
