Re: Dual Hardisk

[Juan Eduardo Moreno]

Hi,

Your storage engine is Innodb?. If your answer is yes, please see below :

innodb_data_file_path=/u01/ibdata1:50M;/u01/ibdata2:50M*;/u03/ibdata3:100M *
You can create a new ibdata ( tablespace) in a new device :

1) Stop mysql
2) Change conf ( add new one tablespace)
3) start mysql

Regards,
Juan


On 1/11/07, sangprabv@stripped <sangprabv@stripped> wrote:
>
> Hi,
> I have a database named X on a hardisk, and  the hardisk can not store new
> record because it has no space anymore. Can I just add a new hardisk and
> ask
> MySQL to store new record for database X to the new hardisk? Please share
> me
> the knowledge to do it, many thanks for your helps.
>
> Regards
>
>
> Willy
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>