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
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 <
manasi.s...@artificialmachines.com> wrote:
>
> Hi Johan,
>
> Some time back you have solved my problem of creating symlink as database
> was fixed. But now When I am putti
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,
Hi All,
When I am creating a symlink with a special character in database name
it appears in mysql as somthing like this
#mysql50#dbname.
For Ex:- I have created a symlink in mysql data directory named
"User.Name" which appeared to me in mysql command line client as
"#mysql50#User.Name
Can
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 sy
Given that you're talking about "quite a few" folders, I think it'd be good
to check up on the theoretical and practical limits for your filesystem of
choice, though - ext2 for example starts getting noticeably slower when you
have a lot more than 10.000 entries in the same directory. One way of
ge
And, IF the application uses the file a lot, but opens it infrequently, for
example an MySQL data file, then the incremental cost is truly neglectable.
IF the symlink is looked up and followed frequently then caches will make it
neglectable.
IF the application touches a wide range (hundreds of th
I don't agree, Don't have any specific documents but seems to make a bit of
sense to me.
Opening a file that is a symbolic link takes more time than one that isn't
as you need to do more operations. Search the directory for the symbolic
link, open it (probably, though an inode look up might be eno
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 created on /var/lib/mysql/dat
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 few
Hi Andrew,
You can do this with MySQL Administrator, but you have to look for
Catalogs in the left pane. After that right click in the bottom part of
the left pain and select 'Create Schema'. Provide a database name and
click on ok. That should do the trick.
Arjan
On Sun, 2008-09-21 at 21:26 -0
Hello
I now sucessfully connected to the MqSQL Administrator tool. I had in
fact a password for the root user. I now would like to create a new
database. II do not see how to do this in the adminstrator tool. Is
there a tool that I can use to create the database. I would prefer a
gui type app
-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 21, 2007 7:09 AM
To: Lopez, Denise; mysql@lists.mysql.com
Subject: Re: Database creation question
You might try issueing a FLUSH PRIVILEGES command instead of restarting.
This is supposed to be implicit when you use the GRANT
OTECTED]>
To:
Sent: Tuesday, March 20, 2007 7:55 PM
Subject: RE: Database creation question
That still didn't work. I think I just need to restart the mysql
service.
Denise Lopez
UCLA Center for Digital Humanities
Network Services
Systems Engineer
337 Charles E. Young Drive East
PPB
Subject: Re: Database creation question
Denise,
Hola!.
1) Connect to the system like root user
2) $ chown -R mysql:mysql /usr/local/mysql/
3) In oder to create user use :
mysql> GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@"%"
IDENTIFIED BY 'PASSWORD
uardo Moreno [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 20, 2007 4:03 PM
To: Lopez, Denise
Cc: mysql@lists.mysql.com
Subject: Re: Database creation question
Denise,
Hola!.
1) Connect to the system like root user
2) $ chown -R mysql:mysql /usr/local/mysql/
3) In oder to create use
Denise,
Hola!.
1) Connect to the system like root user
2) $ chown -R mysql:mysql /usr/local/mysql/
3) In oder to create user use :
mysql> GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@"%"
IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
Regards,
Juan Eduardo
On 3/20/07, Lopez
Hello everyone,
I had a really weird thing happen and I was wondering if anyone has seen
anything like this. From a shell command line I connected to a running
instance of mysql with the mysql -u root -p command. I successfully get
to a mysql prompt. I needed to create a new database and user for
User ''@'localhost' just hasn't enough privileges to create databases.
http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
Doug Pinkerton wrote:
I'm a total newbie working through the tutorial in DuBois's _MySQL_.
I've got MySQL running on my PowerBook. In Terminal, I can use the mysq
You need to set GRANTs to create on the host.
http://dev.mysql.com/doc/refman/5.0/en/grant.html
-Original Message-
From: Doug Pinkerton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 14, 2006 1:26 PM
To: mysql@lists.mysql.com
Subject: Permissions block database creation
I'm a
I'm a total newbie working through the tutorial in DuBois's _MySQL_.
I've got MySQL running on my PowerBook. In Terminal, I can use the
mysql client to get responses to things like SELECT NOW(). But the
command CREATE DATABASE sampdb; results in the following error.
ERROR 1044 (42000): Acce
> -Original Message-
> From: Tim Traver
> Sent: Tuesday, February 15, 2005 19:30
> To: mysql@lists.mysql.com
> Subject: Database creation privileges
>
> Hi all,
>
> ok, I thought I had it figured out.
>
> I am using 4.1.9 now, and it looks like it behav
Hi all,
ok, I thought I had it figured out.
I am using 4.1.9 now, and it looks like it behaves a little bit
differently (or maybe not) than the previous 4.0.20 did when it comes to
privileges.
I want to create a user that does not have the ability to create
databases. But, I do want them to be able
Hi all,
ok, I thought I had it figured out.
I am using 4.1.9 now, and it looks like it behaves a little bit
differently (or maybe not) than the previous 4.0.20 did when it comes to
privileges.
I want to create a user that does not have the ability to create
databases. But, I do want them to be
[snip]
How to create database in mysql 4.0 with out classic. What i
mean is
1. How to create database
2. How to create users and hhow to give privilages to them
3. How to create table space
4. How to create rollback segment
5. How to allocate tables to table space
[/snip]
RTFM at http:
Narashimha,
You have been asking too many, very basic questions that are covered in
excellent detail in the online manual. Please do not expect us to do your
research for you.
http://dev.mysql.com/doc/mysql/en/index.html
MySQL is a very well documented product. The online manual is not only
Hi,
How to create database in mysql 4.0 with out classic. What i mean is
1. How to create database
2. How to create users and hhow to give privilages to them
3. How to create table space
4. How to create rollback segment
5. How to allocate tables to table space
Please help me in do
IL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, February 23, 2002 12:06 AM
> Subject: Script for database creation
>
>
> >
> > hi,
> > I have written a script for database creation and table creation. Now I
> > want to run this script fr
hi,
I have written a script for database creation and table creation. Now I
want to run this script from the MySQL prompt. How can I do this..?
Please , anybody know about this , so that I can create my database by
simply running that script.
Thanks and regards,
Chetan Lavti
29 matches
Mail list logo
