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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]