Mysql reload config file

We are not interested in information about MySQL options, we want only information about configuration errors. You can check it by running mysql-config-test. The exit status would be zero if there are no errors. If there are errors, those will be output to stderr and the exit status would be appropriately not zero.

Failed to reload mysqld. That is, apply the new configuration without worrying that it will result in a dead MySQL instance. NDB uses stateful configuration. Rather than reading the global configuration file every time the management server is restarted, the management server caches the configuration the first time it is started, and thereafter, the global configuration file is read only when one of the following conditions is true:.

The management server is started using the --initial option. When --initial is used, the global configuration file is re-read, any existing cache files are deleted, and the management server creates a new configuration cache. The management server is started using the --reload option. The --reload option causes the management server to compare its cache with the global configuration file.

If they differ, the management server creates a new configuration cache; any existing configuration cache is preserved, but not used. If the management server's cache and the global configuration file contain the same configuration data, then the existing cache is used, and no new cache is created. This disables --config-cache enabled by default , and can be used to force the management server to bypass configuration caching altogether.

In this case, the management server ignores any configuration files that may be present, always reading its configuration data from the config. No configuration cache is found. In this case, the management server reads the global configuration file and creates a cache containing the same configuration data as found in the file. Configuration cache files. Asked 12 years, 7 months ago. Active 2 years, 8 months ago. Viewed k times.

Apache has such a feature, what about MySQL? Does one exist? Jon Server Fault has a better answer to the same question: serverfault. Add a comment. Active Oldest Votes. You were so close!

The kill -HUP method wasn't working for me either. You were calling: select global. Add a comment. Active Oldest Votes. So the manual for mysqladmin under reload says: reload Reload the grant tables. Improve this answer. Kyle Brandt Kyle Brandt Hey, very good explanation.

It seems that there is no way of doing it without restart though. If nobody answers a solution or a workaround I will accept your question. Thank you. Other Kyle: Looks like it, but I think binary logging would already have to be enabled for that to do anything and maybe be set.

That variable was introduced later than my current 5. I had to search for the SET command syntax - here's a link in case anyone else needs it: dev. It's also worth mentioning which variables are dynamic changes as you chance MySQL versions. For instance in 5. Sign up or log in Sign up using Google.