I can not find my.ini

Problems with the Windows version of XAMPP, questions, comments, and anything related.

I can not find my.ini

Postby k0kytak » 15. April 2009 20:34

I have a problem I can not find my.ini file to edit these lines there

Code: Select all
max_connections = 300
max_user_connections = 300
table_cache = 1200
k0kytak
 
Posts: 5
Joined: 15. April 2009 20:32

Re: I can not find my.ini

Postby Sharley » 15. April 2009 22:09

This is the wrong forum as it is the German language forum - the English XAMPP for Windows forum is here and this topic may get moved there by a mod:
viewforum.php?f=16


In xampp\mysql\bin folder you may find what seems to be a shortcut file named simply my - drag this shortcut into your open text editor (Notepad for example) and you should be able to edit and save the file as a normal text file - in the newer XAMPP 1.7.1 version this shortcut file has been renamed to the my.ini file and will hopefully end the confusion.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: I can not find my.ini

Postby k0kytak » 15. April 2009 23:39

Well I installed xampp 1.7.1 my.ini but not inside

Code: Select all
max_connections = 300
max_user_connections = 300
table_cache = 1200
k0kytak
 
Posts: 5
Joined: 15. April 2009 20:32

Re: I can not find my.ini

Postby Sharley » 15. April 2009 23:43

I have just installed XAMPP 1.7.1 and the my.ini file is definitely in the xampp\mysql\bin folder as large as life.

So you must have an issue with your installation and it would be advisable to check and reinstall if you still can't find it or check your Windows configuration so that all system files etc. are visible, for example untick Hide extensions for known file types and Show hidden files and folders etc.
Last edited by Sharley on 15. April 2009 23:46, edited 1 time in total.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: I can not find my.ini

Postby k0kytak » 15. April 2009 23:45

my.ini file but I myself find it located in C: \ xampp \ mysql \ bin \ my.ini but the problem is that I find the following lines

Code: Select all
max_connections = 300
max_user_connections = 300
table_cache = 1200


I want to increase these things because mysql is loaded and stops because I have 200 people online site constantly
k0kytak
 
Posts: 5
Joined: 15. April 2009 20:32

Re: I can not find my.ini

Postby Sharley » 15. April 2009 23:50

k0kytak wrote:my.ini file but I myself find it located in C: \ xampp \ mysql \ bin \ my.ini but the problem is that I find the following lines

Code: Select all
max_connections = 300
max_user_connections = 300
table_cache = 1200


I want to increase these things because mysql is loaded and stops because I have 200 people online site constantly

First you can't find the my.ini file but now you can.

Then you are saying perhaps that the above lines are not in the my.ini file, is that correct?
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: I can not find my.ini

Postby k0kytak » 15. April 2009 23:54

Well why are not these 3 lines to hell :x :x :evil:


Code: Select all
max_connections =
max_user_connections =
table_cache =
k0kytak
 
Posts: 5
Joined: 15. April 2009 20:32

Re: I can not find my.ini

Postby Sharley » 16. April 2009 00:00

k0kytak wrote:Well why are not these 3 lines to hell :x :x :evil:


Code: Select all
max_connections =
max_user_connections =
table_cache =
Please be patient as it is hard to understand your broken English.

You will have to add those line and increase the values as required.

You have this in the my.ini file and so just add those lines at the end like I have done here and save the file and restart the mysql server.
# The MySQL server
[mysqld]
port= 3306
socket= "C:/xampp3/mysql/mysql.sock"
basedir="C:/xampp3/mysql"
tmpdir="C:/xampp3/tmp"
datadir="C:/xampp3/mysql/data"
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error="mysql_error.log"
max_connections = 200
max_user_connections = 200
table_cache = 1200

The my.ini and the implementation of MySQL is for...
# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
...if you cared to read the comments in the my.ini file instead of blowing off steam.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 57 guests