Сейчас:
datadir=d:/mysql/data
set-variable=innodb_data_file_path=ibdata1:300M:autoextend
Хочется оставить эту базюку без autoextend и создать с autoextend на другом диске.
Почитал мануалы. Получается что надо что-то типа этого:
set-variable=innodb_data_file_path=ibdata1:300M;/c:/mysql/data/ibdata2:300M:autoextend
Но не выходит каменный цветок..:
081215 17:52:58 InnoDB: Operating system error number 123 in a file operation.
InnoDB: See
InnoDB: for installation help.
InnoDB: Some operating system error numbers are described at
InnoDB:
InnoDB: File name .\ibdata1;c:\mysql\data\ibdata2
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
123 ошибка - (ERROR_INVALID_NAME)
The filename, directory name, or volume label syntax is incorrect.
А если так:
set-variable=innodb_data_file_path=ibdata1:300M;/c:/mysql/data:300M:autoextend
то:
081215 18:08:33 MySql: Shutdown Complete
InnoDB: Error: data file .\ibdata1 is of a different size
InnoDB: 10276096 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 19200 pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
081215 18:08:57 Can't init databases
081215 18:08:57 Aborting