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

1：挺掉相关的服务

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

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

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

5：启动服务：

1

2

3

4

5

6

7

8

9

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的含义

1

2

3

4

5

6

7

8

9

10

[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

重新启动服务即可

ITPub博客

infobright系列二：数据迁移

最新文章