Hi Murthy, murthy gandikota wrote:
Can someone please tell me how to manage multiple disk partitions in mysql? BTW, the mysql is version 4 or something like that.
When using InnoDB you can just add another tablespace on /var [1]. With MyISAM it gets a bit more difficult, at least in pre 5.1 series. You can use symbolic links to move some databases or even tables to another location. Other solution might be to move *all* databases to /var and change the datadir setting in my.cnf accordingly.
Regards Nils [1] http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
