At 07:15 6/6/2003 +0200, [EMAIL PROTECTED] wrote: Hi,
may be I can add some details to the mail attached below:
As I said I Installed mysql by "phpdev423". On my PC (Win2000) I found out
only the configurations file "my.cnf.OLD" on C:/ and on "C:\Programs\phpdev423\php\sapi\install";
no "my.ini" were found; therefore I suppose that in this moment no option
file is used from mysql.
When I created the new DB I simply did it by PhpMyAdmin Tool, and it was
created in "...\phpdev423\mysql\data";
Now, if I want to have 2 different tables (or DB) in 2 different HD what
can I do?
Do I have to use a conf file? In which dir do I have to put in? DO I have
to rename it? And moreover, what I have to write inside?
I will appreciate if you can help me... Thank You very much in Advance
Fausto
For to run 2 servers on the same machine as service you have the below option:
install the first server like the default one, e.g:
mysqld-nt --install or mysqld-nt --install-manual
the above commands creates a service called mysql
create the \winnt\my.ini file.
[mysqld] basedir=c:/mysql datadir=c:/mysql/data port=3306 ......
now install the second server e.g.:
mysqld-max-nt --install myoptserv or mysqld-max-nt --install-manual myoptserv
the above command create a service called myoptserv
in the same \winnt\my.ini file create a new section with the same name of the service:
[myoptserv] basedir=c:/mysql datadir=c:/optdata/data port=3307 ......
create a new directory called c:\opdata and copy the whole data directory into it. Notice you don't need 2 different installations if you want to have the same version servers. Otherwise when you are doing the setup install, select another directory install than the default for the second server.
now you have 2 services: mysql and myoptserv.
Important: Don't share the same data for both servers.
-- Regards,
For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel Angel Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ Săo Paulo - Brazil /_/ /_/\_, /___/\___\_\___/ <___/ www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
