Install MySQL Without Using The Install Script Included in Retain

Modifying the installation

This would be the best time to put in your own settings for MySQL and the my.cnf file in /etc/

• For 5.5 Copy it from /usr/share/doc/packages/MySQL-server/
• For 5.6 Copy from /usr/

The installer bundled with Retain uses the my-large.cnf file and modifies the path locations. Use whatever file you feel best fits the server environment.

If you want to do a data directory other than the default /var/lib/mysql/ Add the line:

datadir=/path/to/where/you/want/the/MySQL/data

Couple of notes about adding this path:

• Do not put a trailing / on it, you don't need it. I.E. what not to do: datadir=/path/destination/
• The installer places this under the line "[mysqld]" for continuity sake please keep it there if you're modifying this line.

Here's an example File:My.cnf.doc This example file is a 5.5 .cnf file and is adapted for use on a 4-6 GB of RAM server also running Retain. probably safer with 5-6 GB of RAM.

Before MySQL has been started now would also be the time to add the line (if it's not already there)

• innodb_file_per_table

There are various other tweaks that can be applied that would probably be easiest done at this time also.

• Memory tuning