Hi,
I have mysql server 5.1 and I have 5 databases in it. For now, all the data in these databases are stored in one file ‘ibdata1’. I want to store the data in separate files in the name of the respective database. for example, I want to store the data from DB1 in a file named ‘db1’ and for DB2 in a file named ‘db2’. Please tell me how to change the ‘my.ini’ file according to this.
Thanks,
Sumitha