On 08/19/14 23:15, Brad Smith wrote: > Here is a diff to make attempt #2 at switching to MariaDB. > what about the upgrade path ? a default install of mysql-server will not upgrade easily (see log file), atm I have 2 options: 1) change the default values of iblog and ibdata file size to match the ones of mysql-5.0.x 2) add an entry in current.html to proceed this way: # mysqladmin flush logs # /etc/rc.d/mysql stop # pkg_add -ui mysql # rm -f /var/mysql/ib_logfile[0-9] uncomment the line "innodb_data_file_path = ibdata1:10M:autoextend" in /etc/my.cnf # /etc/rc.d/mysqld start
I think that 1) should be the way to go, if you changed my.cnf it will not be overwritten and mariadb will not start but you should know how to fix it. Cheers Giovanni
140821 11:14:59 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages! 140821 11:14:59 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data! 140821 11:14:59 [ERROR] Plugin 'InnoDB' init function returned error. 140821 11:14:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140821 11:14:59 [ERROR] Unknown/unsupported storage engine: InnoDB 140821 11:14:59 [ERROR] Aborting
