sloth Posted June 17, 2006 Report Share Posted June 17, 2006 Could not open required defaults file: my-small.cnf Fatal error in defaults handling. Program aborted Press any key to continue . . . This is what i get when i try to launch mysqlstart.bat I have modified the my-small.cnf so as to have InnoDB support. And here's what it looks like: # The Uniform Servers MySql Config File. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable = key_buffer=16K set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K server-id = 1 # Uncomment the following if you want to log updates #log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir = "/usr/local/mysql/" datadir = "/usr/local/mysql/data/" tmpdir = "/tmp" character-sets-dir=/usr/local/mysql/share/charsets/ default-character-set=greek; # Uncomment the following if you are NOT using BDB tables #skip-bdb # Uncomment the following if you are NOT using innodb tables #skip-innodb # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:18M innodb_data_home_dir = /usr/local/mysql/data/ innodb_log_group_home_dir = /usr/local/mysql/data/ innodb_log_arch_dir = /usr/local/mysql/data/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=2 set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=1M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=8M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M [myisamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M [mysqlhotcopy] interactive-timeout If I reboot my pc, it loads fine. After a few mysql restarts i get the above msg. P.S. Great work on this project. Grats! Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted June 18, 2006 Report Share Posted June 18, 2006 Probably the InnoDB addition is causing this. Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.