Saving MySQL Settings

How can I keep MySQL settings persistent?
I got MySQL from WAMP, and there is no my.cnf file, there is my.ini file!
how can i set some global variable

+5
source share
4 answers

Drive:\wamp\bin\mysql\mysql5.5.8\my.ini

This is the place to save the settings.

+7
source

WAMP uses the my.ini file.

To get to the my.ini file, simply click on the WAMP tray icon and hover over the MySQL menu and click on my.ini.

  • Edit the my.ini file and in the [mysqld] section add the following:

    setting-name=setting-value, example: event-scheduler = on

  • restart all services

.

+3

SQL ( /) ().

+2

, WAMP my.ini my.conf.

SQL :

mysql> SET global max_heap_table_size=524288000;
mysql> SET global tmp_table_size=524288000;

:

select @@global.tmp_table_size, @@global.max_heap_table_size

.

my.ini, :

max_heap_table_size=524288000
tmp_table_size=524288000

.

+1

All Articles