version: 4.0.22
This is probably documented somewhere, but I can't seem to find it. Can
someone point me in the right direction? I want a setup similar to the
following:
/var/lib/mysql/data/[databases]
/var/lib/mysql/logs/[logs] (binary, etc)
Currently, everything is in /var/lib/mysql (including innondb).
Current my.cnf settings:
log-bin
datadir = /var/lib/mysql/
innodb_data_home_dir =
innodb_log_arch_dir = ./
innodb_log_group_home_dir = ./
My plan is:
1. Shut down mysql
2. for each database cp -r /var/lib/mysql/{db} /var/lib/mysql/data/{db}
3. cp ibdata1 to /var/lib/mysql/data/
4. cp ib_logfile* and ib_arch_log* /var/lib/mysql/logs/
5. cp hostname-bin.* (binary logs and index) to /var/lib/mysql/logs/
6. edit my.cnf as follows
log-bin=/var/lib/mysql/logs/
datadir = /var/lib/mysql/data/
innodb_data_home_dir = /var/lib/mysql/data/
innodb_log_arch_dir = /var/lib/mysql/logs/
innodb_log_group_home_dir = /var/lib/mysql/logs/
7. Restart mysql
Is there anything else that I am missing? Are there any gotchas with this
setup?
Thanks
---------------------------------
Do you Yahoo!?
Send holiday email and support a worthy cause. Do good.
