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
----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 8:55 AM Subject: 2 different Mysql DB on the same server Hi to all, I need to have on the same PC (that is the Server) 2 different mysql DBs; I need it because I need some data on the standard mysql dir (for example ...\mysql\data\) and some data on a different dir. I installed mysql simply installing phpdev423; therefore I found out automatically the DB data on a precise dir (...\phpdev423\mysql\data); when I created a new database automatically the data were put inside the dir ...\phpdev423\mysql\data\"name_new_database"\. Now I have to create a new DB on a totally different dir (and different HD on the same PC): how can I do it? is there a .ini or .cnf file were I can specify the path? And moreover, can I specified 2 different paths because I need 2 different DBs on 2 different dir? Thak You in Advance for any suggestion Fausto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]