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
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 device with
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
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 first
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
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
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 vegiv...@tuxera.be wrote:
- 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
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
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
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
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.
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
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
...@tuxera.be
Cc: Waynn Lue waynn...@gmail.com; mysql mysql@lists.mysql.com
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
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 that is d1-d10.
as I ca change the database
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 Regards,
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 files is
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
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)
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)
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 in old location.
Please let me know if anymore information is needed on this. I am really
looking
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 (directory)
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 your
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
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
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. But
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 Regards
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 I ca change the database location after 5 databases but not able to
access old five
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 manasi.s...@artificialmachines.com
Hi
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#
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
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 vegiv...@tuxera.be ha
scritto:
You can do that at runtime no problem, you just need to do OS calls for it.
On Fri, Sep 18, 2009 at 12:54 PM, Claudio Nanni claudio.na...@gmail.comwrote:
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
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:
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:
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
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
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
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
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:
37 matches
Mail list logo