At 17:39 17/10/2001 -0500, BD wrote: Hi! For to clarify:
the command prompt \mysql\bin\mysqld-max-nt --install should be executed only to install the service, without any order parameter. If you want to run the server, as service the configuration variables, should be made through a configuration file named my.ini at \winnt\my.ini In this file, you create a section called [mysqld] and the keys that you need, for example: [mysqld] basedir=c:/mysql datadir=F:/Apache Group/Apache/htdocs/data How you are running a Max server, if you don't want the InnoDB tables, you need to add the following keys: [mysqld] basedir=c:/mysql datadir=F:/Apache Group/Apache/htdocs/data skip-innodb Otherwise, if you want these tables, create 2 directories for hold the data and log files for InnoDB, e.g:: F:\ibdata and F:\iblogs. Now you should have the following variables as example: [mysqld] basedir=c:/mysql datadir=F:/Apache Group/Apache/htdocs/data innodb_data_file_path = ibdata1:200M innodb_data_home_dir = f:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = f:\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 = f:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable=lower_case_table_names =0 set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Notice that the first time that the server is run, will create the InnoDB files, according with the sizes specified. Now you can start the server, in 2 ways: Like service: mysqld-max-nt --install net start mysql Like standalone: mysqld-max-nt --standalone Of course if you don't want to create, the configuration file, you can run the server, how I did: E:\mysql\bin>mysqld-max-nt --standalone --datadir=e:\dbdata\data --basedir=e:\mysql --skip-innodb --console mysqld-max-nt: ready for connections Of course that the best way to run the server is as service. Regards, Miguel >I'm trying to move some of my MySQL data files to the directory of my >apache web server htdocs directory for testing which is on the same >machine as MySQL. This is on the same machine and all access is done >through http://localhost. So I'm just trying to test it locally. But I'm >getting ahead of myself here. > >I want to use the --DataDir option of mysqld-max-nt to look for the data >in the F:\Apache Group\Apache\htdocs\data\ directory. Simple, right? >Here's what happens: >(BTW, this is a Win2k machine) > >mysqld-max-nt --datadir="F:\Apache Group\Apache\htdocs\data\" --install >mysqld-max-nt: Can't change dir to 'F:\Apache Group\Apache\htdocs\data" >--install\' (Errcode: 22) >011017 17:24:53 Aborting > >Now if I remove the trailing slash from "...data\" and use "...data", it >comes back with: > >F:\mysql\bin>mysqld-max-nt --datadir="F:\Apache Group\Apache\htdocs\data" >--install >mysqld-max-nt: unrecognized option `--install' >mysqld-max-nt Ver 3.23.42-max-nt for NT on i32 > >Yet, if I take off the "--datadir" option, it recognizes the "--install" >option and runs the server. > >Does anyone know why this is happening? TIA > >Brent > >--------------------------------------------------------------------- >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 > -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil <___/ www.mysql.com --------------------------------------------------------------------- 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