Changing the default database location
Changing the default database location
am 20.05.2011 15:05:26 von 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 using workbench and then change the
datadir under Options File in workbench. Then I am trying to restart the
server, it won't.
Can anyone assist me with the installation?
Thanks
Firdosh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Re: Changing the default database location
am 20.05.2011 15:13:39 von Reindl Harald
--------------enigE7506EE14711E985C7F81A1A
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
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.
>=20
> 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 Options File in workbench. Then I am trying to restart th=
e
> server, it won't.
>=20
> Can anyone assist me with the installation?
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 "mysql" with permissions, users... and will
say this in the error-log
--------------enigE7506EE14711E985C7F81A1A
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
iEYEARECAAYFAk3WaQQACgkQhmBjz394AnmMqACghznv1h7exDwBDLYyb6ej nRmm
VhMAn03/eSogSzUEjynpQn3mmayNVy9J
=EXEs
-----END PGP SIGNATURE-----
--------------enigE7506EE14711E985C7F81A1A--
Re: Changing the default database location
am 20.05.2011 15:45:39 von Johan De Meersman
----- 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 "mysql" with permissions, users... and will
> say this in the error-log
That's pretty much the most likely explanation, yes.
On another note, be aware that putting the data files on a network drive is generally considered a bad idea, as because a) performance is going to suffer, and b) if the network borks the daemon is going to get a bit confused (read: you will lose data).
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Re: Changing the default database location
am 20.05.2011 15:58:43 von Firdosh Dhooka
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 wro=
te:
>
>
> ----- 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 "mysql" with permissions, users... and will
>> say this in the error-log
>
> That's pretty much the most likely explanation, yes.
>
> On another note, be aware that putting the data files on a network drive =
is generally considered a bad idea, as because a) performance is going to s=
uffer, and b) if the network borks the daemon is going to get a bit confuse=
d (read: you will lose data).
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dfdhooka@circu=
lumvite.com
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
Re: Changing the default database location
am 20.05.2011 16:05:56 von Reindl Harald
--------------enig36A4045D2D7307A56B8755D0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
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.
>=20
> The reason to move database onto the network is that multiple user can
> access it. Do you think there is a better alternative?
>=20
> Firdosh
>=20
> On Fri, May 20, 2011 at 9:45 AM, Johan De Meersman =
wrote:
>>
>>
>> ----- 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 "mysql" with permissions, users... and will
>>> say this in the error-log
>>
>> That's pretty much the most likely explanation, yes.
>>
>> On another note, be aware that putting the data files on a network dri=
ve is generally considered a bad idea, as because a) performance is going=
to suffer, and b) if the network borks the daemon is going to get a bit =
confused (read: you will lose data).
>>
>>
>> --
>> Bier met grenadyn
>> Is als mosterd by den wyn
>> Sy die't drinkt, is eene kwezel
>> Hy die't drinkt, is ras een ezel
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dfdhooka@circul=
umvite.com
>>
>>
>=20
--=20
Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/
http://www.thelounge.net/signature.asc.what.htm
--------------enig36A4045D2D7307A56B8755D0
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
iEYEARECAAYFAk3WdUQACgkQhmBjz394AnmUcACfV9dNkK+BSpovTkvHMSsu Wtph
HpwAn309iDgfgTIXemySWxQOxdNxR0gf
=oEOq
-----END PGP SIGNATURE-----
--------------enig36A4045D2D7307A56B8755D0--
Re: Changing the default database location
am 20.05.2011 22:06:57 von Johan De Meersman
----- 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 datafiles. If that's the case, Firdosh, don't - MySQL is not made for concurrent access to the same datafiles. If multiple people/applications need access to the same data, let them connect to the same server. If that's not an option, you're going to have to look at replication.
I repeat, there is no setup possible where it is safe to have multiple instances of mysqld access the same datafiles.
If you do, the first thing you'll notice is that one instance doesn't see the other instance's update. The second thing you'll notice, is that your data files will be FUBAR. Fucked Up Beyond Any Recognition. Not kidding, here.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Re: Changing the default database location
am 26.05.2011 23:49:53 von prabhat kumar
--bcaec5014ba9277ddd04a434cd6e
Content-Type: text/plain; charset=ISO-8859-1
>
> 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 create N no of users and let them access..
On Fri, May 20, 2011 at 1:06 PM, Johan De Meersman 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
>
> Hmm. The way I interpret what he's saying, is that he wants multiple
> instances accessing the same datafiles. If that's the case, Firdosh, don't -
> MySQL is not made for concurrent access to the same datafiles. If multiple
> people/applications need access to the same data, let them connect to the
> same server. If that's not an option, you're going to have to look at
> replication.
>
> I repeat, there is no setup possible where it is safe to have multiple
> instances of mysqld access the same datafiles.
>
> If you do, the first thing you'll notice is that one instance doesn't see
> the other instance's update. The second thing you'll notice, is that your
> data files will be FUBAR. Fucked Up Beyond Any Recognition. Not kidding,
> here.
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prabhat@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
--bcaec5014ba9277ddd04a434cd6e--
Re: Changing the default database location
am 26.05.2011 23:52:55 von Reindl Harald
--------------enigEFD29F6FB54A64FA001C199A
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
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?
>>
>=20
> 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 instal=
l you
> can create N no of users and let them access..
>=20
> On Fri, May 20, 2011 at 1:06 PM, Johan De Meersman =
wrote:
>=20
>> ----- 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 datafiles. If that's the case, Firdosh, d=
on't -
>> MySQL is not made for concurrent access to the same datafiles. If mult=
iple
>> people/applications need access to the same data, let them connect to =
the
>> same server. If that's not an option, you're going to have to look at
>> replication.
>>
>> I repeat, there is no setup possible where it is safe to have multiple=
>> instances of mysqld access the same datafiles.
>>
>> If you do, the first thing you'll notice is that one instance doesn't =
see
>> the other instance's update. The second thing you'll notice, is that y=
our
>> data files will be FUBAR. Fucked Up Beyond Any Recognition. Not kiddin=
g,
>> here.
>>
>> --
>> Bier met grenadyn
>> Is als mosterd by den wyn
>> Sy die't drinkt, is eene kwezel
>> Hy die't drinkt, is ras een ezel
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=3Daim.prabhat@gmail.com
>>
>>
>=20
>=20
--=20
Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/
http://www.thelounge.net/signature.asc.what.htm
--------------enigEFD29F6FB54A64FA001C199A
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
iEYEARECAAYFAk3ey7cACgkQhmBjz394Ank+kwCfepg7Drp0n/pQFHCnYBTK aLUT
zgsAn0ELVxiAYdl1D2utwwvH+/vHuHl4
=ouTx
-----END PGP SIGNATURE-----
--------------enigEFD29F6FB54A64FA001C199A--