MySQL Admin - TechRepublic
Question
December 17, 2010 at 08:17 AM
sumitha mani

MySQL Admin

by sumitha mani . Updated 15 years, 6 months ago

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

This discussion is locked

All Comments