Re: Win 2000 Not starting-SOLVED
Hi I had pored for ages over the Manual prior to posting my problem. I've solved it - all the methods given in the Manual dont apply to 2000. Manual states the various start methods etc apply to both NT and 2000. They don't, at least not for Professional. Forget the --standalone, the skip- etc etc. The only method, after exhaustive tries, that works is: 1. Go to the dir where mysql is stored (I'd unzipped to d:) (dont forget to first edit my.cnf for d:) 2. At d:\mysqlbin\mysql-nt --install 3. d:\mysqlNET START mysql etc.then start the monitor. You must install it as a service, no other options (as for NT) seem to work with Pro 2000. Also, it's best to restart pc more frequently too. Cheers, Lucy - 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
Re: Win 2000 Not starting-SOLVED
At 13:29 03/03/2001 +, Lucy wrote: Hi, Hi I had pored for ages over the Manual prior to posting my problem. I've solved it - all the methods given in the Manual dont apply to 2000. Manual The above it isn't correct, I use Win2kPro and Win2k Server on my work machine and all applies to NT you can apply to Win2k OS. When you run mysqld-nt --standalone the server runs and the DOS screen remains open. You find on \mysql directory a file called Readme with instructions about this and mentioning the use of WinMySQLAdmin that can help you to run the server as service or as standalone (when the service is removed, there is this option). Regards, Miguel states the various start methods etc apply to both NT and 2000. They don't, at least not for Professional. Forget the --standalone, the skip- etc etc. The only method, after exhaustive tries, that works is: 1. Go to the dir where mysql is stored (I'd unzipped to d:) (dont forget to first edit my.cnf for d:) 2. At d:\mysqlbin\mysql-nt --install 3. d:\mysqlNET START mysql etc.then start the monitor. You must install it as a service, no other options (as for NT) seem to work with Pro 2000. Also, it's best to restart pc more frequently too. Cheers, Lucy - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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
Win 2000 Not starting
Hi 1. I'm working in Windows 2000, intending to run MySQL to localhost on same laptop. 2. I've edited "my.cnf" to change to d: wherever it said c:, placed it 3 places, c:\, d:\ and d:\mysql\data\ as per Manual's Option Files. As I unzipped binary directly to d: 3. None of these have worked: d:\mysql\bin\mysqld --debug d:\mysql\bin\mysqld --standalone --debug d:\mysql\bin\mysqld --standalone d:\mysql\bin\mysqld --basedir d:\mysql d:\mysql\bin\mysqld --skip-grant-tables --debug d:\mysql\bin\mysqld --skip-grant-tables d:\mysql\bin\mysqld-nt --standalone --debug d:\mysql\bin\mysqld-nt --standalone I was shutting down via Task Manager but have repeated by shutting down the laptop aswell. All cases, everything just hangs, nothing happens. 4. As per Manual, this command: d:\mysql\bin\mysqld produced a mysql.err file which states "REady for connections" and it came back to the prompt d: I thought this might have started the server up, so I then tried d:mysql but it didn't recognise this. I tried d:\mysql\bin\mysqlshow but it came back with error message, "Can't connect to MySQL server on 'localhost'. Check that it's running. 5. I particularly didn't want to use the mysqld-nt install option because I don't want the bother of installing as a service with users/passwords, this is just development work, Windows defaults of being available for all users is fine. Also the Manual states the option file my.cnf is supported by program "mysqld", implicitly it therefore does not support programs "mysql-nt", "mysql-opt". As I've changed default location, I need the option file I believe. Anyone any ideas? Cheers, Lucy - 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
Re: Win 2000 Not starting
I'd love to here an answer to this one too. Exact same scenario.. exact same problem. --- "Lucy" [EMAIL PROTECTED] wrote: Hi 1. I'm working in Windows 2000, intending to run MySQL to localhost on same laptop. 2. I've edited "my.cnf" to change to d: wherever it said c:, placed it 3 places, c:\, d:\ and d:\mysql\data\ as per Manual's Option Files. As I unzipped binary directly to d: 3. None of these have worked: d:\mysql\bin\mysqld --debug d:\mysql\bin\mysqld --standalone --debug d:\mysql\bin\mysqld --standalone d:\mysql\bin\mysqld --basedir d:\mysql d:\mysql\bin\mysqld --skip-grant-tables --debug d:\mysql\bin\mysqld --skip-grant-tables d:\mysql\bin\mysqld-nt --standalone --debug d:\mysql\bin\mysqld-nt --standalone I was shutting down via Task Manager but have repeated by shutting down the laptop aswell. All cases, everything just hangs, nothing happens. 4. As per Manual, this command: d:\mysql\bin\mysqld produced a mysql.err file which states "REady for connections" and it came back to the prompt d: I thought this might have started the server up, so I then tried d:mysql but it didn't recognise this. I tried d:\mysql\bin\mysqlshow but it came back with error message, "Can't connect to MySQL server on 'localhost'. Check that it's running. 5. I particularly didn't want to use the mysqld-nt install option because I don't want the bother of installing as a service with users/passwords, this is just development work, Windows defaults of being available for all users is fine. Also the Manual states the option file my.cnf is supported by program "mysqld", implicitly it therefore does not support programs "mysql-nt", "mysql-opt". As I've changed default location, I need the option file I believe. Anyone any ideas? Cheers, Lucy - 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 == %-- 8-P ---% % "Yeah, I have a life.. sure umm.. % %somewhere.. where did I leave that% %thing??" % % % % Robert Wahl [EMAIL PROTECTED] % % n00b for life % %--% _ Visit Stomped.com for your daily dose of news for gamers - And get free e-mail too! - 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