Move IBDATA
I am trying to move the ibdata files to a new drive on my server (Red Hat), but am running into some issues. Here are the steps that I took:
1. Stop the MySQL Service
2. Edit the my.cnf file by adding the following lines:
innodb_log_group_home_dir=
innodb_data_file_path=ibda
innodb_log_files_in_group=
innodb_data_home_dir=/db/i
3. Copy the ibdata1 file and the two ib_logfiles from /var/lib/mysql to /db/ibdata
4. Start the MySQL service backup
When I query any of the tables, specifically innodb tables I get the following error:
ERROR 1033 (HY000) on InnoDB configuration error
1. Stop the MySQL Service
2. Edit the my.cnf file by adding the following lines:
innodb_log_group_home_dir=
innodb_data_file_path=ibda
innodb_log_files_in_group=
innodb_data_home_dir=/db/i
3. Copy the ibdata1 file and the two ib_logfiles from /var/lib/mysql to /db/ibdata
4. Start the MySQL service backup
When I query any of the tables, specifically innodb tables I get the following error:
ERROR 1033 (HY000) on InnoDB configuration error
tsmgeek
look at the .err log file in /var/lib/mysql/ as that will give a more detailed error
ASKER
The error message says the same thing. What is weird, is I changed the size of the inndob file the my.cnf file from 50M to the current size of the file on disk and it worked.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.