infobright系列二：数据迁移

安装之后把之前infobright的数据迁移到新安装的infobright上。

1：挺掉相关的服务

2：scp 把旧数据拷到新安装的infobright上

3：修改/etc/my-ib.cnf的数据目录

4：修改/etc/init.d/mysqld-ib 的相应数据目录

5：启动服务：

Option: KNLevel, value: 99.
Option: LicenseFile, value: <unknown>.
Option: LoaderMainHeapSize, value: 320.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 600.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
150514 16:06:02 [ERROR] /usr/local/infobright/libexec/mysqld: Can't create/write to file '/opt/infobright_data_scp/SH-BA-01-Infobright.pid' (Errcode: 13)
150514 16:06:02 [ERROR] Can't start server: can't create PID file: Permission denied

　　

6：查看错误代码13的含义

[root@root Infobright bin]# ls
ibhttppost         mysql              mysql_config                mysql_fix_extensions        mysqlshow            perror
msql2mysql         mysqlaccess        mysql_convert_table_format  mysql_fix_privilege_tables  mysqlslap            replace
myisamchk          mysqladmin         mysqld_multi                mysqlhotcopy                mysqltest            resolveip
myisam_ftdump      mysqlbinlog        mysqld_safe                 mysqlimport                 mysql_tzinfo_to_sql  resolve_stack_dump
myisamlog          mysqlbug           mysqldump                   mysql_install_db            mysql_upgrade
myisampack         mysqlcheck         mysqldumpslow               mysql_secure_installation   mysql_waitpid
my_print_defaults  mysql_client_test  mysql_find_rows             mysql_setpermission         mysql_zap
[root@root Infobright bin]# ./perror 13
OS error code  13:  Permission denied

　　

权限问题。

修改数据目录的权限

chwod -R mysql.mysql infobright_data

 

重新启动服务即可