From: Reindl Harald Date: May 20 2011 2:05pm Subject: Re: Changing the default database location List-Archive: http://lists.mysql.com/mysql/225064 Message-Id: <4DD67544.2050405@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig36A4045D2D7307A56B8755D0" --------------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=FC=DFen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofm=FChlgasse 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+BSpovTkvHMSsuWtph HpwAn309iDgfgTIXemySWxQOxdNxR0gf =oEOq -----END PGP SIGNATURE----- --------------enig36A4045D2D7307A56B8755D0--