Otdfbt

Does an ice chest packed full of frozen food need ice?

Does a 3rd-level Wolf Totem barbarian get advantage against enemies when an ally is within 5 feet of the enemy?

Was Jesus good at singing?

Can an Aarakocra use a shield while flying?

Comparing and find out which feature has highest shape area in QGIS?

Why would future John risk sending back a T-800 to save his younger self?

What's the name of this light airplane?

At what point in time did Dumbledore ask Snape for this favor?

Passing multiple files through stdin (over ssh)

How would a aircraft visually signal in distress?

How to project 3d image in the planes xy, xz, yz?

Is the term 'open source' a trademark?

Different pedals/effects for low strings/notes than high

My coworkers think I had a long honeymoon. Actually I was diagnosed with cancer. How do I talk about it?

How water is heavier than petrol eventhough its molecular weight less than petrol?

Is using haveibeenpwned to validate password strength rational?

Hottest Possible Hydrogen-Fusing Stars

Is it possible to 'live off the sea'

Genetic limitations to learn certain instruments

Confusion about off peak timings of London trains

Russian equivalents of "no love lost"

Compiling c files on ubuntu and using the executable on Windows

PhD - Well known professor or well known school?

What makes Ada the language of choice for the ISS's safety-critical systems?

MySQL !includedir not working

MySQL - How do I make my max_allowed_packet setting stick?MySQL CURTIME() is always 00:00:00MySQL binlog not loggingRe install MySQL while ignoring all previous stuffMysql not workingmysql command line not workingMySQL ERROR 1045 (28000)MySQL replication not working - no errorsphpmyadmin not working after mysql updateMySQL: Too many open files (24) BUT open_files has not reached open_files_limit?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

1

This is for documentation of a problem I ran into and solved.

I tried to use MySQL’s !includedir directive to include files in the conf.d directory, but it wasn’t working. I tried messing with permissions and everything. This was my config tree:

/etc/mysql
├── conf.d
│   ├── mysql.cnf
│   └── mysqldump.cnf
├── my.cnf
├── my.cnf.local
└── my.cnf.fallback

And my my.cnf:

[client]
port = 3306

[mysqld]
local-infile = 0 
port = 3306
server-id = 1 
# more stuff.....

[mysqldump]
quick
max_allowed_packet = 16M 

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M 
sort_buffer_size = 20M 
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

!include /etc/mysql/my.cnf.local

However, the specified /etc/mysql/my.cnf.local file wasn't being loaded. See below for the solution.....

mysql

share|improve this question

edited May 31 at 0:00

kael

asked Jun 27 '18 at 17:02

kaelkael

1215

add a comment | 

0

1

This is for documentation of a problem I ran into and solved.

I tried to use MySQL’s !includedir directive to include files in the conf.d directory, but it wasn’t working. I tried messing with permissions and everything. This was my config tree:

/etc/mysql
├── conf.d
│   ├── mysql.cnf
│   └── mysqldump.cnf
├── my.cnf
├── my.cnf.local
└── my.cnf.fallback

And my my.cnf:

[client]
port = 3306

[mysqld]
local-infile = 0 
port = 3306
server-id = 1 
# more stuff.....

[mysqldump]
quick
max_allowed_packet = 16M 

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M 
sort_buffer_size = 20M 
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

!include /etc/mysql/my.cnf.local

However, the specified /etc/mysql/my.cnf.local file wasn't being loaded. See below for the solution.....

mysql

share|improve this question

edited May 31 at 0:00

kael

asked Jun 27 '18 at 17:02

kaelkael

1215

add a comment | 

This is for documentation of a problem I ran into and solved.

I tried to use MySQL’s !includedir directive to include files in the conf.d directory, but it wasn’t working. I tried messing with permissions and everything. This was my config tree:

/etc/mysql
├── conf.d
│   ├── mysql.cnf
│   └── mysqldump.cnf
├── my.cnf
├── my.cnf.local
└── my.cnf.fallback

And my my.cnf:

[client]
port = 3306

[mysqld]
local-infile = 0 
port = 3306
server-id = 1 
# more stuff.....

[mysqldump]
quick
max_allowed_packet = 16M 

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M 
sort_buffer_size = 20M 
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

!include /etc/mysql/my.cnf.local

However, the specified /etc/mysql/my.cnf.local file wasn't being loaded. See below for the solution.....

mysql

share|improve this question

edited May 31 at 0:00

kael

asked Jun 27 '18 at 17:02

kaelkael

1215

/etc/mysql
├── conf.d
│   ├── mysql.cnf
│   └── mysqldump.cnf
├── my.cnf
├── my.cnf.local
└── my.cnf.fallback

[client]
port = 3306

[mysqld]
local-infile = 0 
port = 3306
server-id = 1 
# more stuff.....

[mysqldump]
quick
max_allowed_packet = 16M 

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M 
sort_buffer_size = 20M 
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

!include /etc/mysql/my.cnf.local

share|improve this question

edited May 31 at 0:00

kael

asked Jun 27 '18 at 17:02

kaelkael

1215

share|improve this question

edited May 31 at 0:00

kael

asked Jun 27 '18 at 17:02

kaelkael

1215

asked Jun 27 '18 at 17:02

kaelkael

1215

asked Jun 27 '18 at 17:02

kaelkael

1215

1 Answer
1

active

oldest

votes

2

It turns out that on top of requiring a .cnf ending for files in !include (and !includedir), you also can't have extra dots. The solution was to change the filename from my.cnf.local to my-local.cnf.

share|improve this answer

edited 9 hours ago

answered Jun 27 '18 at 17:02

kaelkael

1215

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Good spot and nice to see you got the problem resolved.
  
  – Martin Barker
  May 21 at 23:25
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f918530%2fmysql-includedir-not-working%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

It turns out that on top of requiring a .cnf ending for files in !include (and !includedir), you also can't have extra dots. The solution was to change the filename from my.cnf.local to my-local.cnf.

share|improve this answer

edited 9 hours ago

answered Jun 27 '18 at 17:02

kaelkael

1215

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Good spot and nice to see you got the problem resolved.
  
  – Martin Barker
  May 21 at 23:25
  

  
  
  
  

add a comment | 

2

It turns out that on top of requiring a .cnf ending for files in !include (and !includedir), you also can't have extra dots. The solution was to change the filename from my.cnf.local to my-local.cnf.

share|improve this answer

edited 9 hours ago

answered Jun 27 '18 at 17:02

kaelkael

1215

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Good spot and nice to see you got the problem resolved.
  
  – Martin Barker
  May 21 at 23:25
  

  
  
  
  

add a comment | 

It turns out that on top of requiring a .cnf ending for files in !include (and !includedir), you also can't have extra dots. The solution was to change the filename from my.cnf.local to my-local.cnf.

share|improve this answer

edited 9 hours ago

answered Jun 27 '18 at 17:02

kaelkael

1215

share|improve this answer

edited 9 hours ago

answered Jun 27 '18 at 17:02

kaelkael

1215

answered Jun 27 '18 at 17:02

kaelkael

1215

answered Jun 27 '18 at 17:02

kaelkael

1215