Hi,

I want to have my application running on server A and have my MySQL DB
installed on a another server B.

Because I need to call MySQL programs on A I have installed the MySQL
package on A and want simply to locate the DB on B.

OK I can also install everything on B and start the deamons on both
machines and connect with -hostname -user from A to B but it doesn't 
seem very nice to me.

I have tried the parameter --datadir=\\B\MySQL\data on a shareable
directory but the new inserted rows are only shown after restarting the
daemon on A. Perhaps I should use such parameters as --flush or any others
to avoid this problem ? But I think a such a solution can bring to
poor performance which is not the goal.

I have tried the parameters --bind-address with --port but I get the
following error messages:

can't start server: Bind on TCP/IP port: No error
010130 16:11:39  Do you already have another mysqld server running on port:
3306 ?
010130 16:11:39  Aborting 

whether or not a daemon is running on B

Does someone have got a clue because I don't see any docus on this
theme ?

Thank you in advance

Eric 




-- 
Sent through GMX FreeMail - http://www.gmx.net


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to