Bug #25281 Cannot use multiple Innodb files
Submitted: 26 Dec 2006 11:44 Modified: 26 Dec 2006 12:13
Reporter: Francisco Rodera Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S2 (Serious)
Version:5.0.27 OS:Linux (Suse 9.3)
Assigned to: CPU Architecture:Any
Tags: data files, innodb

[26 Dec 2006 11:44] Francisco Rodera 
Description:
When adding a second data file to my.cnf mysql shows the following error:

061227 02:44:45  mysqld started
061227  2:44:45 [ERROR] InnoDB: syntax error in innodb_data_file_path
061227  2:44:45 [Note] /usr/sbin/mysqld: ready for connections.

if only one data file is used no problem is reported.

How to repeat:
Add multiple data files (separated with ';'):

innodb_data_home_dir =
innodb_data_file_path = /var/lib/mysql/ibdata1:10M:autoextend:max:2001M;/var/lib/mysql/ibdata2:10M
innodb_log_group_home_dir = /var/lib/mysql/

Suggested fix:
Solve the parsing error (if applies).
[26 Dec 2006 12:13] Valeriy Kravchuk 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ (namely, http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html) and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php