Hi all.
I've installed mysql-max 3.23.41 in a Windows NT machine with Service Pack
6.
I didn't installed mysql y the default directory (C:\mysql) and also changed
the data directory to
another directory y another drive (I moved the mysql and test directory of
the data directory too).
The server failed at the moment of start the service.
The content of the my.ini file is:
#This File was made using the WinMySQLAdmin 1.3 Tool
#22/8/01 10.38.40
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=C:/Archivos de programa/Bases Datos/MySQL
datadir=D:/Bases Datos/MySQL/Data
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
#bind-address=10.1.4.12
#language=C:/Archivos de programa/Bases Datos/MySQL/share/your language
directory
#slow query log#=
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/Archivos de programa/Bases Datos/MySQL/bin/mysqld-max-nt.exe
user=iago
password=iago
[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
Also if I want to configure Innodb in the my.ini file the next would be
correct?
# InnoDB in the mysqld section
innodb_data_home_dir = D:\Bases Datos\MySQL\ibdata
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = D:\Bases Datos\MySQL\iblogs
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=30M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = D:\Bases Datos\MySQL\iblogs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
Thanks in advance.
Iago.
______________________________________________________________________________
mensaje enviado desde http://www.iespana.es
emails (pop)-paginas web (espacio illimitado)-agenda-favoris (bookmarks)-foros
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
