here is the simple steps to change your mysql configuration
- Stop completelly your mysql instance:
- Code: Select all
service mysqld stop
- Create a temporary directory:
- Code: Select all
mkdir /var/lib/mysql/old/
- Move the next files to temporary directory:
- Code: Select all
mv /etc/my.cnf /var/lib/mysql/old/old.cnf
- Code: Select all
mv /var/lib/mysql/ib_logfile* /var/lib/mysql/old/
- Upload your new Configuration:
- Code: Select all
cp my.cnf /etc/my.cnf
- Start mysql:
- Code: Select all
service mysqld start
Thats all.
connection closed.