mariadb升级有个问题。

ldlbf

安装的 php5.6.9 和 mariadb10.0.17 安装完了之后，是完全正常的。在此之前安装的php5.5.25和mariadb5.5.42也是可以正常使用，后来因为 mariadb5.5.42升级43升不了，就换了5.6.9和10.0.17，现在升级 mariadb 10.0.17 到 10.0.19 最后出错。


升级日志我暂时还无法上传上来，我截的最后报错的最后一部分，安装前面全部都是正常的。安装完成了 mysql启动提示要新设置密码，可是在升级之前就已经设置过一次密码了呀。这里还是按照原来的密码再输入一次，然后就提示找不到mariadb目录，进到 /usr/local/ 目录下面发现两个mariadb的目录：一个 oldmariadb20150601152638 和一个 mariadb20150601 这两个目录.

刚刚查了 upgrade_mariadb.sh 的161行，mv /usr/local/mariadb /usr/local/mariadb$(date +"%Y%m%d")  这一行将mariadb改了名字，下面的164行语句执行当然找不到 mariadb的目录啦，麻烦军哥改改。

groupadd: group 'mariadb' already exists
useradd: user 'mariadb' already exists
Installing MariaDB/MySQL system tables in '/usr/local/mariadb/var' ...
150601 15:59:52 [Note] /usr/local/mariadb/bin/mysqld (mysqld 10.0.19-MariaDB-log) starting as process 14206 ...
OK
Filling help tables...
150601 15:59:55 [Note] /usr/local/mariadb/bin/mysqld (mysqld 10.0.19-MariaDB-log) starting as process 14235 ...
OK


To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system


PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:


'/usr/local/mariadb/bin/mysqladmin' -u root password 'new-password'
'/usr/local/mariadb/bin/mysqladmin' -u root -h host password 'new-password'


Alternatively you can run:
'/usr/local/mariadb/bin/mysql_secure_installation'


which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.


See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.


You can start the MariaDB daemon with:
cd '/usr/local/mariadb' ; /usr/local/mariadb/bin/mysqld_safe --datadir='/usr/local/mariadb/var'


You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/local/mariadb/mysql-test' ; perl mysql-test-run.pl


Please report any problems at http://mariadb.org/jira


The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from MariaDB
Corporation Ab. You can contact us about this at sales@mariadb.com.
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/


Starting MySQL.                                            [确定]
New password:
Confirm new password:
Enter password:
import backup databases...
include/upgrade_mariadb.sh: line 164: /usr/local/mariadb/bin/mysql: 没有那个文件或目录
MariaDB databases import failed,Please import databases manually!
Repair databases...
include/upgrade_mariadb.sh: line 168: /usr/local/mariadb/bin/mysql_upgrade: 没有那个文件或目录
Stopping MariaDB...
/etc/init.d/mariadb: line 213: my_print_defaults: command not found
MySQL server PID file could not be found!                  [失败]
+-------------------------------------------+
|    Manager for LNMP, Written by Licess    |
+-------------------------------------------+
|              http://lnmp.org              |
+-------------------------------------------+
Starting LNMP...
Starting nginx...  done
/etc/init.d/mariadb: line 213: my_print_defaults: command not found
/etc/init.d/mariadb: line 304: cd: /usr/local/mariadb: 没有那个文件或目录
Starting MySQLCouldn't find MySQL server (/usr/local/mariad[失败]mysqld_safe)
Starting php-fpm  done
======== upgrade MariaDB failed ======
upgrade MariaDB log: /root/upgrade_mariadb.log
You upload upgrade_mariadb.log to LNMP Forum for help.
[1]+  Done                    mysqld_safe --user=mysql --skip-grant-tables --skip-networking  (wd: /etc)
(wd now: ~/lnmp1.2-full)

[ 本帖最后由 ldlbf 于 2015-6-1 17:22 编辑 ]

ldlbf

军哥，日志传上来了。昨天晚上又测试了一下，直接安装php 5.6.9 + mariadb 10.0.19 的这个组合完全没问题，可以运行，跑起来也正常。现在把昨天下午升级 mariadb10.0.17 升 10.0.19 的日志上传上来了。系统是 centos 6.5 64位的。日志最下面好像没有体现出要输2次新密码的地方，但实际操作的时候有这个。

licess

昨天晚上已经修复了