On 08/21/14 17:40, Stuart Henderson wrote: > On 2014/08/21 17:06, Giovanni Bechis wrote: >> On 08/21/14 11:26, Giovanni Bechis wrote: >>> 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 >>> >> Now with patch, anyway we should add an entry in current.html as well. > > This patch adds some cvs conflict markers... in any event, there are a lot of > reasons why people might not be using a file based on my-medium.cnf, so an > entry > in current.html seems more sensible to me. > if you have changed /etc/my.cnf mariadb upgrade will not overwrite it in any case
> (Also innodb is probably a less-common configuration anyway, isn't it?) > innodb tablespace is created by MySQL 5.0.x even if not used by default for new databases. Cheers Giovanni
