Lue ; mysql
> Sent: Wed, November 25, 2009 8:12:25 PM
> Subject: Re: question regarding mysql database location
>
> Dear Johan,
>
> Need your help again in understanding How mysql reads symlink.
>
> As you said below, I have created symlinks in default mysql directory.
&
Hi Johan,
It worked perfectly. Thank you so much for this explanation.
I am really greatful.
--
Best Regards,
Manasi Save
Artificial Machines Pvt Ltd.
> On Wed, Nov 25, 2009 at 3:42 PM, Manasi Save <
> manasi.s...@artificialmachines.com> wrote:
>
>> Dear Johan,
>>
>> Need your help again in un
Is mysql the owner of the directories?
- Original Message
From: Manasi Save
To: Johan De Meersman
Cc: Waynn Lue ; mysql
Sent: Wed, November 25, 2009 8:12:25 PM
Subject: Re: question regarding mysql database location
Dear Johan,
Need your help again in understanding How mysql reads
On Wed, Nov 25, 2009 at 3:42 PM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Dear Johan,
>
> Need your help again in understanding How mysql reads symlink.
>
> As you said below, I have created symlinks in default mysql directory.
> and try to read that symlink file as a database. B
Dear Johan,
Need your help again in understanding How mysql reads symlink.
As you said below, I have created symlinks in default mysql directory.
and try to read that symlink file as a database. But mysql is not reading
that file as Database. Is there any settings which I need to change.
Thanks
Thanks Johan,
It was really a great help. I'll try to implement it. I dont want to opt
for multiple mysql instances option as thats not feasible.
I'll get back to you all if it works fine.
Thanks again.
--
Best Regards,
Manasi Save
Artificial Machines Pvt Ltd.
> On Wed, Nov 25, 2009 at 11:55
On Wed, Nov 25, 2009 at 12:05 PM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> At a time mysql can point to one data directory. For your task you can have
> n number of mysql installation with different data directory. After that
> you
> can use federated storage engine to perform y
On Wed, Nov 25, 2009 at 11:55 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi Johan,
>
> I am Sorry. If I have complicated the senerio But, this still not fix my
> purpose.
>
> What I want is - From your example :-
>
> /data/disk1/mysql/db1 (directory)
> /db2 (dir
Hi Manasi,
At a time mysql can point to one data directory. For your task you can have
n number of mysql installation with different data directory. After that you
can use federated storage engine to perform your task.
Thanks,
Krishna Ch. Prajapati
On Wed, Nov 25, 2009 at 12:19 PM, Manasi Save <
Hi Johan,
I am Sorry. If I have complicated the senerio But, this still not fix my
purpose.
What I want is - From your example :-
/data/disk1/mysql/db1 (directory)
/db2 (directory)
/db3 (directory)
/db4 (symlink to /data/disk2/mysql/db4)
You don't need to move any databases. Look at this structure:
/data/disk1/mysql/db1 (directory)
/db2 (directory)
/db3 (directory)
/db4 (symlink to /data/disk2/mysql/db4)
/db5 (symlink to /data/disk2/mysql/db5)
/db
Well Waynn,
In this case I need to move all the existing databases to new location
right. Which I don't want to do. Is it possible that I create sym link
between two and use both.
--
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.
> On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save <
>
On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Thanks Waynn,
>
> I could not get your point of using symlinks. Because as per my knowledge
> symlink will store same data which is there in original directory.
> and What do you mean by "The limit for fil
Thanks Waynn,
I could not get your point of using symlinks. Because as per my knowledge
symlink will store same data which is there in original directory.
and What do you mean by "The limit for files is significantly higher than
> directories."
Can you elaborate it more.
Thanks in advance.
Rega
I fixed this by using symlinks for the directories for the underlying
databases. The limit for files is significantly higher than
directories.
Waynn
On 11/24/09, Manasi Save wrote:
> Hi All,
>
> I have asked this question before But, I think I am not able to describe
> it better.
>
> Sorry for a
Also I forgot to mention that I have gone through the innodb option of
innodb_data_file_path but I can just specify it as :
innodb_data_file_path=ibdata1:2048M:autoextend:max:1024M;ibdata1:2048M:autoextend:max:1024M;
But not as :
innodb_data_file_path=/var/lib/mysql/data/ibdata1:2048M:autoextend
Hi All,
I have asked this question before But, I think I am not able to describe
it better.
Sorry for asking it again.
I have multiple databases but there is a limit on the folders getting
created in one folder.
I have mysql default directory set as /var/lib/mysql/data.
Now, After 32000 folder c
Your mysql server is either not running, or is not creating the sock file at the
location "/var/lib/mysql/mysql.sock" that calendar.php expects.
What do you get when you do this?
linux$ ls -la /var/lib/mysql/mysql.sock
look in the my.cnf file to find where the MySQL sock is written to, and modify
Dear all,
Right Now I am having different kind of problem in mysql
server . mysqld service automatically goes off . when we open a website and
enter something to search from mysql database it gives the following error -
*Warning: Can't connect to local MySQL server through socket
'
e Law [mailto:[EMAIL PROTECTED]
Sent: Sun 1/8/2006 8:42 PM
To: Andrew Burrows; MYSQL General List
Subject: Re: General Questions regarding mysql and php
Andrew,
I used to be a big redhat fan - but if you are looking to totally bring
everything up to date, I would suggested opensuse.
having used r
ata.
--
George Law
- Original Message -
From: "Andrew Burrows" <[EMAIL PROTECTED]>
To: "MYSQL General List"
Sent: Sunday, January 08, 2006 8:01 PM
Subject: General Questions regarding mysql and php
Hi MYSQL users,
Just started playing with mysql apache php and oth
Andrew Burrows wrote:
Hi MYSQL users,
Just started playing with mysql apache php and other tricky stuff and have a
few question to get me going after many years.
Was wondering what the best GUI based administration tool is used today, I
lasted used phpMyAdmin, is this still used or are there b
Hi MYSQL users,
Just started playing with mysql apache php and other tricky stuff and have a
few question to get me going after many years.
Was wondering what the best GUI based administration tool is used today, I
lasted used phpMyAdmin, is this still used or are there better applicatio
Hello.
This is an output of diff user.c user.cpp. Which successfully compiles on
my FC3 system using the following command:
g++ user.cpp -I/usr/include/mysql -lmysqlclient
I've changed the extension to 'cpp', so g++ could work with this file.
Also #include was commented, and main now r
The same source that you compiled under VC++ may not work at all under
linux. Especially since the header files will be different. Make sure
you have the proper header files for linux installed. Also I did not
see any linking flags during compilation.
On 7/3/05, Ashok Kumar <[EMAIL PROTECTED]> wro
Dear Friends,
I'm Ashok here. first i'll tell my sys configuration.
1.Redhat-Linux 9
2.Intel Pentium chipset
3.MySQL 4.1 with Development Libraries
For this i've downloaded the MySQL4.1 under the
specification "Linux x86 RPM downloads" from the site.
In my system, the MySQL Server is working w
Ashok Kumar wrote:
Dear Friends,
I'm Ashok here. first i'll tell my sys configuration.
1.Redhat-Linux 9
2.Intel Pentium chipset
3.MySQL 4.1 with Development Libraries
For this i've downloaded the MySQL4.1 under the
specification "Linux x86 RPM downloads" from the site.
In my system, the MySQ
preciate.
> Thanks
> prashanth
>
> -Original Message-
> From: Ashok Kumar [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 30, 2005 3:34 PM
> To: mysql mysql
> Subject: Help needed regarding MySQL-C Libraries on
> Linux
>
> Dear Friends,
> I'm A
Dear Friends,
I'm Ashok here. first i'll tell my sys configuration.
1.Redhat-Linux 9
2.Intel Pentium chipset
3.MySQL 4.1 with Development Libraries
For this i've downloaded the MySQL4.1 under the
specification "Linux x86 RPM downloads" from the site.
In my system, the MySQL Server is working w
At 10:21 AM -0400 9/13/03, [EMAIL PROTECTED] wrote:
In a message dated 9/13/03 8:40:08 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
1) can I create groups, add users and assign privileges to the group?
Yup.
???
How do you create a group in MySQL?
--
Paul DuBois, Senior Technical Writer
Ma
In a message dated 9/13/03 8:40:08 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> 1) can I create groups, add users and assign privileges to the group?
Yup.
> 2) since this system is going over a VPN the data should be encrypt using
> 3DES. If a authorized user needs access to the data
9:53 AM
Subject: a few questions regarding MySQL rights
Our programmer is designing a large scale database and I have some
questions.
1) can I create groups, add users and assign privileges to the group?
2) since this system is going over a VPN the data should be encrypt using
3DES. If a authorized us
Our programmer is designing a large scale database and I have some questions.
1) can I create groups, add users and assign privileges to the group?
2) since this system is going over a VPN the data should be encrypt using 3DES. If a
authorized user needs access to the data who is not in the VPN t
2003年 8月 2日 土曜日 15:11、あなたは書きました:
> Hi frnd.
>
> I am also using mysql and facing problems regarding access to
> the
> db using odbc from visual basic.
>
> i have made a table under mysql default db and
>
> used ms ado to connect to the db.
>
> what will be the server name in such a case(that will b
You are welcome ;-)
Best regards
Nils Valentin
Tokyo/Japan
;-)
> 2003年 7月 3日 木曜日 14:43、Sibananda Sahoo さんは書きました:
> > Thank you sir
> >
> > Rgds,
> > Sibananda
> >
> > --- Nils Valentin <[EMAIL PROTECTED]> wrote:
> > > Dear Sibanada,
> > >
> > > You keep sending e-mails offlist directly t
Dear Sibanada,
You keep sending e-mails offlist directly to me. Are you aware that it might
be much more beneficial for you to send a support request to the mysql
mailing list ?
I might not be available to answer always, but in such a case another person
might answer you perhaps quicker and b
2003年 7月 2日 水曜日 22:57、Sibananda Sahoo さんは書きました:
> Dear Sir
>
> Hope you to be fine. I know MS SQL supports the
> following query to reseed the seed value:
>
> DBCC CHECKIDENT ('tablename',RESEED,new-seed-value);
>
> Is there any support like the above in MySQL 4.0.13 to
> set new seed value ?
>
> A
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dj W wrote:
Hello,
I've been looking through the source code for
version 4.0.10-gamma trying to discern how exactly
this thing runs by tracing back through the various
inits() but because of how poorly it has been
documented its slightly overwhel
Hello,
I've been looking through the source code for
version 4.0.10-gamma trying to discern how exactly
this thing runs by tracing back through the various
inits() but because of how poorly it has been
documented its slightly overwhelming to figure out
what structures belongs to what modules o
-Original Message-
From: Chetan Lavti
Sent: Monday, April 15, 2002 10:01 AM
To: [EMAIL PROTECTED]
Subject: regarding mysql sever startup...
hi,
I am starting my Mysql Serevr like this..
> cd /bin/sbin
> mysqld-max --user=root
Is there any another method which doesn
hi,
I am starting my Mysql Serevr like this..
> cd /bin/sbin
> mysqld-max --user=root
Is there any another method which doesn't require starting the server by
Root..(root privileges)
please, help me out in this direction.
Thanks and regards,
Chetan Lavti
-
As i am using MySQL in my project and i need and
command which is equivakent to (TABLOCKX HOLDLOCKX) in
SQLServer to lock a table while opening itself in
MySQL using Visual C++.
Please respond me soon as it is very urgent for me
Regards
Phani Kiran.A
=
Bye bye
Phani Kiran.A
___
Chuck,
Maybe it's just me, but I'm not sure what you're asking here.
You wrote:
> Hi again i didn't get any feed back regarding MqSql boolean
> field/datatype i note that it is evident in version 4.1 my version is
> 3.23 ok.
http://www.mysql.com/doc/C/o/Column_types.html
BIT
BOOL
Hi again i didn't get any feed back regarding MqSql boolean
field/datatype i note that it is evident in version 4.1 my version is
3.23 ok.
Plz advice, as there is nothing in the pdf.manual about bool (boolean
true/false values) Only something is regards to MySql keywords bool.
Thus i have use
John Hughes wrote:
> Please allow me to broaden this thread to include backup for mySQL
> users who have accounts with ISPs.
> In my case I have mySQL access on a Web server where I have NO access
> to the server-level options. What is my best option of making a
> backup of the database and tabl
Please allow me to broaden this thread to include backup for mySQL
users who have accounts with ISPs.
In my case I have mySQL access on a Web server where I have NO access
to the server-level options. What is my best option of making a
backup of the database and tables that I use?
Also, what i
urred
during this procedure.
Thanks and regards,
Chetan Lavti
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 10:19 AM
To: Chetan Lavti
Cc: [EMAIL PROTECTED]
Subject: Re: Again regarding MySQL Backup and Recovery
On Mon, Mar 04, 2002 at 10:05:
On Mon, Mar 04, 2002 at 10:05:50AM +0530, Chetan Lavti wrote:
>
> I am using MySQL 3.23.47 and InnoDB table type on Linux7.1 platform.
> Now,for this database backup and recovery procedures are given as :
>
> 1.Taking 'binary' backup of the database.
> 2.Using the mysqldump utility
>
> I
hi,
I am using MySQL 3.23.47 and InnoDB table type on Linux7.1 platform.
Now,for this database backup and recovery procedures are given as :
1. Taking 'binary' backup of the database.
2. Using the mysqldump utility
In the first method we do the following things :
· Shut down you
I need to create a database in MySQL that I need to bundle with my
program
for distribution. The user will have its own copy of MySQL running. User
using my program will not bother about database issues and the bundled
database will provide him, through my application program GUI, to
enter/retr
Hai,
Where? Here!
> is there any support of sys_date in mysql which is strong feature in oracle
> 8.x . i am using MYSQL 3.23 server version .
Short answer: RTFM 6.3.4 Date and Time Functions
Don't have an Oracle book with me, please refresh my memory of the exact output from
sys_date/you
Hi,
Now(), sysdate().
Anvar.
At 03:02 PM 07/02/2002 +0530, you wrote:
>Hai ,
>
>is there any support of sys_date in mysql which is strong feature in oracle
>8.x . i am using MYSQL 3.23 server version .
>
>
>With Warm Regards
>
>[EMAIL PROTECTED]
>JIN INformation Systems(P) Ltd
>Voice : 527530
bruary 07, 2002 PM 04:29
Subject: Re: regarding mysql DATE support
> Hi,
> Now(), sysdate().
> Anvar.
>
> At 03:02 PM 07/02/2002 +0530, you wrote:
> >Hai ,
> >
> >is there any support of sys_date in mysql which is strong feature in
oracle
> >8.x . i
Hai ,
is there any support of sys_date in mysql which is strong feature in oracle
8.x . i am using MYSQL 3.23 server version .
With Warm Regards
[EMAIL PROTECTED]
JIN INformation Systems(P) Ltd
Voice : 5275300/5097603/5097604/5281822 ext 218
www.jinis.com
With Warm Regards
[EMAIL PROTECTED]
bruary 07, 2002 PM 04:29
Subject: Re: regarding mysql DATE support
> Hi,
> Now(), sysdate().
> Anvar.
>
> At 03:02 PM 07/02/2002 +0530, you wrote:
> >Hai ,
> >
> >is there any support of sys_date in mysql which is strong feature in
oracle
> >8.x . i
Hai,
Where? Here!
> is there any support of sys_date in mysql which is strong feature in oracle
> 8.x . i am using MYSQL 3.23 server version .
Short answer: RTFM 6.3.4 Date and Time Functions
Don't have an Oracle book with me, please refresh my memory of the exact output from
sys_date/you r
Hi,
Now(), sysdate().
Anvar.
At 03:02 PM 07/02/2002 +0530, you wrote:
>Hai ,
>
>is there any support of sys_date in mysql which is strong feature in oracle
>8.x . i am using MYSQL 3.23 server version .
>
>
>With Warm Regards
>
>[EMAIL PROTECTED]
>JIN INformation Systems(P) Ltd
>Voice : 527530
Hai ,
is there any support of sys_date in mysql which is strong feature in oracle
8.x . i am using MYSQL 3.23 server version .
With Warm Regards
[EMAIL PROTECTED]
JIN INformation Systems(P) Ltd
Voice : 5275300/5097603/5097604/5281822 ext 218
www.jinis.com
With Warm Regards
[EMAIL PROTECTED]
MAIL PROTECTED]>
Sent: Monday, July 23, 2001 3:20 PM
Subject: Regarding MySQL Passwords
> Hello,
> I have just installed the MySQL RPMs , downloaded from
> ur web site. I have installed it on my machine. But I am facing few
> problems.
>
> 1. As u have specif
13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: "Nitesh Garg" <[EMAIL PROTECTED]>
To: "Simon Green" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 23, 2001 3:56 PM
Subject: Re: Regarding MySQL Passwor
-up, e.g. move the data directory to another drive.
Simon
-Original Message-
From: Nitesh Garg [mailto:[EMAIL PROTECTED]]
Sent: 23 July 2001 14:56
To: Simon Green; [EMAIL PROTECTED]
Subject: Re: Regarding MySQL Passwords
Simon Green wrote:
> When you set up the sever to start with
ou use -p and there is no password set it will look for a password and
> so fail (at the moment).
>
> Simon
>
> -Original Message-
> From: Nitesh Garg [mailto:[EMAIL PROTECTED]]
> Sent: 23 July 2001 14:21
> To: [EMAIL PROTECTED]
> Subject: Regarding MySQL Passwords
&g
look for a password and
so fail (at the moment).
Simon
-Original Message-
From: Nitesh Garg [mailto:[EMAIL PROTECTED]]
Sent: 23 July 2001 14:21
To: [EMAIL PROTECTED]
Subject: Regarding MySQL Passwords
Importance: High
Hello,
I have just installed the MySQL RPMs , downloaded f
Hello,
I have just installed the MySQL RPMs , downloaded from
ur web site. I have installed it on my machine. But I am facing few
problems.
1. As u have specified in documentation that, if I am able to connect
to server without giving password that can be troublesome. While i am
any useful note on this particular problem quickly...)
Guus
> -Original Message-
> From: chetan merai [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 20, 2001 6:20 AM
> To: [EMAIL PROTECTED]
> Subject: regarding mysql software
>
>
>
>
>
database ,sql,query,table
Dear sir,
I , chetan merai ,want to know about the
installation problem that i am having with mysql.
After downloading from net , and then using other
commands when i use the command ./configure , I get
the following error:
mysql client is not running.
and there is a problem in database connectivity too.
it says acess denied using Password="YES".This was the error when mysql was
running.It's on Apache Web Server.
Please suggest me what changes are to be made in the configuration and
reflect on the point about passwor
mysql client is not running.
and there is a problem in database connectivity too.
it says acess denied using Password="YES".This was the error when mysql was
running.It's on Apache Web Server.
Please suggest me what changes are to be made in the configuration and
reflect on the point about passw
68 matches
Mail list logo
