Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
Mysql Configuration (auto_increment_offset)
Posted by: Emmanuel (---.chirn2.vic.optusnet.com.au)
Date: March 03, 2011 01:29AM

Hi guys,

I've been trying to configure mysql in WAMP and set auto_increment_offset value.

But I'm just not sure which file I should edit?? I tried adding this to the my.ini file, and restarted services, but to no avail?

Is the my.ini file the right one to edit? Does it matter where abouts in the my.ini file I put the auto_increment_offset value? Or is there another file I should be editing?

Thanks so much for any help

Options: Reply•Quote
Re: Mysql Configuration (auto_increment_offset)
Posted by: toivo (---.facz1.ken.bigpond.net.au)
Date: March 05, 2011 08:04AM

You are editing the correct file. If you have installed several versions of MySQL, make sure that you edit the right my.ini. You can edit the my.ini file from the Wamp icon in the System Tray: MySQL - my.ini.

Add the variable to the section [wampmysqld] and restart the MySQL service.

You can check the value from the MySQL console by using this command:

SHOW SESSION VARIABLES LIKE 'auto%'

Options: Reply•Quote
Re: Mysql Configuration (auto_increment_offset)
Posted by: Emmanuel (---.chirn2.vic.optusnet.com.au)
Date: March 05, 2011 10:08AM

Excellent! Thanks so much!

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login