How to retrieve all MySQL settings?
Posted
by
Max Kielland
on Super User
See other posts from Super User
or by Max Kielland
Published on 2011-11-17T17:06:12Z
Indexed on
2011/11/17
17:56 UTC
Read the original article
Hit count: 315
I have a configured MySQL server (MySQL 5.1.47-community) that works perfect. I installed a second server (MySQL 5.5.15-community) to see if the new version of MySQL would work with my application before upgrading.
When I run the application against the new server it behaves different. When I run it against the old server (MySQL 5.1.47-community) everything works perfect.
I remember that I set some parameters through the MySQL prompt to accept larger result set and some other stuff, now I can't remember what I did.
So my question is: Is there a way to transfer all the MySQL settings from one server to another?
Thanks.
© Super User or respective owner