[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Converting from myisam to InnoDB
I'm trying to switch from myisam to InnoDB. I've edited my.cnf (see below).
When I try to start mysql-max:
[root@db1 mysql]# safe_mysqld --skip-bdb
Starting mysqld-max daemon with databases from /home/dbclnbs/mysql/
011203 15:00:00 mysqld ended
Error log:
011203 14:59:54 mysqld started
InnoDB: Warning: operating system error number 13 in a file operation.
InnoDB: Cannot continue operation.
011203 15:00:00 mysqld ended
[root@db1 mysql]# ls -l /home/dbclnbs/mysql/
total 428
drwxrwxr-x 2 mysql mysql 4096 Dec 2 15:37 innodb
Here's part of my.cnf:
innodb_data_file_path = cb1:3000M
innodb_data_home_dir = /home/dbclnbs/mysql/innodb
innodb_log_group_home_dir = /home/dbclnbs/mysql/innodb
innodb_log_arch_dir = /home/dbclnbs/mysql/innodb
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=512M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_file_io_threads=4
Why the permission error ?
(RH 7.2, mysql 3.23.46)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thread92897@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
This mailing list archive is a service of Copilot Consulting.