Keep or Replace? /etc/mysql/my.cnf [Solved]

[andrewyoungisgreat]

I'm updating 7.10 to 8.04 and the update has popped up the following.

Replace the customized configuration file '/etc/mysql/my.cnf'? You will lose any changes you have made to this configuration file if you choose to replace it with a newer version.

Below is the text.

Should I keep or replace?

--- /etc/mysql/my.cnf 2008-01-05 17:11:31.000000000 +0000
+++ /etc/mysql/my.cnf.dpkg-new 2008-03-28 04:16:35.000000000 +0000
@@ -20,9 +20,6 @@
port = 3306
socket = /var/run/mysqld/mysqld.sock

-default-character-set = utf8
-#added for compatability with Amarok
-
# Here is entries for some specific programs
# The following values assume you have at least 32M ram

@@ -35,6 +32,13 @@
#
# * Basic Settings
#
+
+#
+# * IMPORTANT
+# If you make changes to these settings and your system uses apparmor, you may
+# also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
+#
+
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
@@ -44,14 +48,10 @@
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
-
-default-character-set = utf8
-#added for compatability with Amarok
-
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
-#bind-address = 127.0.0.1
+bind-address = 127.0.0.1
#
# * Fine Tuning
#
@@ -85,8 +85,7 @@
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
#server-id = 1
-log_bin = /var/log/mysql/mysql-bin.log
-# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
+#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
@@ -142,6 +141,7 @@

#
# * IMPORTANT: Additional settings that can override those from this file!
+# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

[Guest]

Re: Keep or Replace? /etc/mysql/my.cnf

It really doesn't look like it matters, as all that is getting removed except for the lines "default-character-set = utf8" are being just reinserted somewhere else in the file. And the stuff that is getting added besides that are all comments which don't do anything other than provide documentation. IMO, just take the new one. You could always add the utf8 support back in later, since it is only one or two lines.

[andrewyoungisgreat]

Re: Keep or Replace? /etc/mysql/my.cnf

Many thanks for the explanation.