Page 1 of 1

How to change your mysql configuration

PostPosted: Fri Jun 27, 2014 2:42 pm
by MaBoRaK
loading........

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.

Re: How to change your mysql configuration

PostPosted: Wed May 27, 2015 7:07 am
by mmm
What is the best way to configure MySQL, InnoDB and MariaDB for Interspire Email Marketer to work as fast/error free as possible?