PLEASE do not reply to the list and some peopole on the list
mailing-list is really enough
Am 26.05.2011 23:49, schrieb Prabhat Kumar:
>>
>> The reason to move database onto the network is that multiple user can
>> access it. Do you think there is a better alternative?
>>
>
> shared storage devic
>
> The reason to move database onto the network is that multiple user can
> access it. Do you think there is a better alternative?
>
shared storage device with MySQL does not work. Perheps it will corrupt
datafile.
Not sure what do mean by 'multiple user can access' ; Once mysql install you
can c
- Original Message -
> From: "Reindl Harald"
>
> so put the wgole mysqld and its data on a server in the network
> for this mysql was built and not for borking the dadadir somewhere
> else
Hmm. The way I interpret what he's saying, is that he wants multiple instances
accessing the same
so put the wgole mysqld and its data on a server in the network
for this mysql was built and not for borking the dadadir somewhere else
Am 20.05.2011 15:58, schrieb Firdosh Dhooka:
> Thanks Johan.
>
> The reason to move database onto the network is that multiple user can
> access it. Do you think
Thanks Johan.
The reason to move database onto the network is that multiple user can
access it. Do you think there is a better alternative?
Firdosh
On Fri, May 20, 2011 at 9:45 AM, Johan De Meersman wrote:
>
>
> - Original Message -
>> From: "Reindl Harald"
>>
>> first: please post log
- Original Message -
> From: "Reindl Harald"
>
> first: please post log-outputs instead of "don't work"
>
> i guess: you changed only the path in my.cnf
> have you oved th existing datadir to the new location?
> if not the server will not start because it is missing
> the database "mys
Am 20.05.2011 15:05, schrieb Firdosh Dhooka:
> I wanted to install mysql community server and workbench on my machine.
> So I downloaded and installed it and everything seems working fine.
>
> But now I wanted to change the location of datadir from local to my
> network. So I stop the server fir
I wanted to install mysql community server and workbench on my machine.
So I downloaded and installed it and everything seems working fine.
But now I wanted to change the location of datadir from local to my
network. So I stop the server first using workbench and then change the
datadir under Opti
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
create 10 databases but 5 in
> /var/lib/mysql/data/d1 to d5
> and othe 5 in /var/lib/mysql/data/d6 to d10.
>
> but I want to access all the databases that is d1-d10.
>
> as I ca change the database location after 5 databases but not able to
> access old five which I have created
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
te 10 databases but 5 in
>> /var/lib/mysql/data/d1 to d5
>> and othe 5 in /var/lib/mysql/data/d6 to d10.
>>
>> but I want to access all the databases that is d1-d10.
>>
>> as I ca change the database location after 5 databases but not able to
>> ac
. Well Its not like I want to create 32000 database's in it (Which I
> wanted to earlier :-P).
>
> for example - I want to create 10 databases but 5 in
> /var/lib/mysql/data/d1 to d5
> and othe 5 in /var/lib/mysql/data/d6 to d10.
>
> but I want to access all the databases th
ant to create 32000 database's in it (Which I
> wanted to earlier :-P).
>
> for example - I want to create 10 databases but 5 in
> /var/lib/mysql/data/d1 to d5
> and othe 5 in /var/lib/mysql/data/d6 to d10.
>
> but I want to access all the databases that is d1-d10.
>
> as
ccess all the databases that is d1-d10.
as I ca change the database location after 5 databases but not able to
access old five which I have created in old location.
Please let me know if anymore information is needed on this. I am really
looking for the solution. Please Help me.
--
Thanks and Re
On Fri, Sep 18, 2009 at 12:54 PM, Claudio Nanni wrote:
> 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 the symlink.
> And/
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" ha
scritto:
You can do that at runtime no problem, you just need to do OS calls for it.
r...@soulcake-duck:/var/lib/mysql# *mysql
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
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# *m
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
> Hi All,
>
> Is it possible to change
Hi All,
Is it possible to change or create any database on a specific location.
I want to specify a db path at runtime.
Thanks in advance.
--
Regards,
Manasi Save
Artificial Machines Pvt Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
shutdown mysql, move all the files in your current data directory to
the new location
in your my.cnf file (ie. unix: /etc/my.cnf)
[mysqld]
datadir=/my
---
all data files are in /my
- hcir
On Friday, January 3, 2003, at 07:56 AM, aman raheja wrote:
Hi All
Right now I have all my MySQL dat
Hi All
Right now I have all my MySQL database files getting stored in
/var/lib/mysql/
If I want to change that to another location, say, /home/mysql or something
else, how do I do it?
Thanks
Aman
-
Before posting, please check:
This is one thing I really can't stand about mysql. We should have the option when
creating
databases and tables of specifying where the database is located and the datafile and
indexfile.
Dave
On Fri, Aug 31, 2001 at 07:03:40PM +0200, Simon J Mudd wrote:
> On Fri, 31 Aug 2001, Peter Moscatt wr
On Fri, 31 Aug 2001, Peter Moscatt wrote:
> Can you change the location of a MySQL database ? The default is
> '/var/lib/mysql'.
The easy way I've always used is to change the name of the /var/lib/mysql
directory and make a symbolic link to another directory. You need to
reset up the mysql dat
Can you change the location of a MySQL database ? The default is
'/var/lib/mysql'.
Pete
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
hy,
i want to set up a apache web server with mysql database connection
for different users which should have their databases in their
homedirectories.
for ex: user x use .jsp to write data from forms in a mysql database -
for ex: homedir: /home/x/htdocs
but the mysqldatab
With MySQL is there a way that you can create a database from the default
location, which at the moment on my Linux install is:
'/var/lib/mysql/my_database' ?
Pete
-
Before posting, please check:
http://www.mysql.com/manual
I have been evaluating mySQL (Windows Version 3.23) as a backend for our
Intranet/Management Information Database - so far so good. However, I have
one question... how do I point the software to a database location that's
not on the same drive as the mySQL software? For example, myS
39 matches
Mail list logo
