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

Filed under:
|
|
|

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

How to retrieve all MySQL settings?

Posted by Max Kielland on Server Fault See other posts from Server Fault or by Max Kielland
Published on 2011-11-17T16:59:07Z Indexed on 2011/11/17 17:55 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.

© Server Fault or respective owner

Related posts about configuration

Related posts about mysql