mysql's mysql db in one place, other db's in another???

[Les Schaffer]

Using Innodb under Windows XP, MySQL server installed to default location:

is it possible to let the mysql database be in C:\Program
Files\MySQL\MySQL server 5.0\data while we have our innodb specific data
files in C:\DataCollector\Resources\ ?


IOW (from my.ini):

    #Path to installation directory. All paths are usually resolved
    relative to this.
    basedir="C:/Program Files/MySQL/MySQL Server 5.0/"

    #Path to the database root
    datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
    #datadir="C:/DataCollector/Resources/"

    ...

    innodb_data_home_dir="C:/DataCollector/Resources/"

if this is not possible, is it possible to move the mysql db like so:


    #Path to installation directory. All paths are usually resolved
    relative to this.
    basedir="C:/Program Files/MySQL/MySQL Server 5.0/"

    #Path to the database root
    #datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
    datadir="C:/DataCollector/Resources/"

    ...

    innodb_data_home_dir="C:/DataCollector/Resources/"

so far, i cannot get the server started in either mode. so i wonder,
even with all three of these options, whether all the data dirs have to
be in one place?????

thnx

les schaffer

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]