event_scheduler

[emir]

hi i am trying to stop server from Cleanup of unused items but when i try to run cod for it i get event_scheduler is not on i and i cant find no where to turn it on

[axeman]

Is it the modular building cleanup or are you trying to cleanup items in the database ?

 

Mysql Event Scheduler, you can switch it on at the mysql command line with 

SET GLOBAL event_scheduler = ON;

http://www.sitepoint.com/how-to-create-mysql-events/

[emir]

i am trying to get Mysql Event Scheduler to work so it dos not cleanup items in the database  i atempted to add SET GLOBAL event_scheduler = ON; i get an error the event_scheduler is off event can processed only when server is started with event_scheduler on.  t

[axeman]

Is it disabled ? look in my.ini for event_scheduler=DISABLED.

 

http://dev.mysql.com/doc/refman/5.1/en/events-configuration.html

[Axe Cop]

If you're using the official MySQL server and MySQL Workbench you can connect to your server and click on "Options File" and then turn the event-scheduler on at the first line. :)

Maybe you can't turn the event-scheduler on when you only use a game server with no access to the MySQL config file my.ini

[emir]

stupid question where is this file located i am running a dedicated box with heidisql as i cant find it

[Axe Cop]

Well with the default MySQL server installer at "C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" but I don't know about heidisql.

I guess there is still the option of using google or heidisql doku or use your search function in windows?? xD

[emir]

the file i can find in there is my-default.ini   this is whot it look like the cod of it

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
 

[emir]

with MySQL Workbench i conected to the server and it is saying that the file does not exist and asking me to make on when i attempt to save i get a error if it is ok can some one give me there my.ini  as this is driving me insane

[ThatGamer_Bullet]

I'm kinda feeling my way through this same process at the moment. Hopefully you've found a solution by now, but if anyone else like my is passing through....

The "Options File" is under the "Server" drop-down menu. And then the "Event Scheduler" will be an obvious option in there.

At which point, you may likely have made your first change worth saving, and therefor may have just CREATED THE MY.INI file through that command.

 

That was the case for me anyway.

EDIT: the file was created in the MySQL Server 5.6\ directory as I believe was already mentioned as its typical location