Re: Unable to start mysql after power Failure
Just to be sure, is that first sentence supposed to be reading "node-2" and not "node-1"? The datafiles should not be in use anywhere, on any node, or disaster will be your share. Additionally, what is your shared filesystem? Is it possible that there is still a lock on the datafiles at that level after the crash on node-1? - Original Message - > From: "Jatin Davey" > To: "MySql" > Sent: Saturday, 4 July, 2015 11:04:29 > Subject: Re: Unable to start mysql after power Failure > Yes , But i dont have any mysqld process running on the node-2 as i have > mentioned above and attempting to start mysqld on node-2 is when i face > this issue for which the logs are showing the above error message. > > Thanks > Jatin > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Unable to start mysql after power Failure
On 7/4/2015 2:26 PM, Reindl Harald wrote: Am 04.07.2015 um 06:24 schrieb Jatin Davey: We are trying to High Availability solution for our database. We have our application running on a node-1 and the DB running on the shared storage which is shared across node-1 & node-2. Whenever there is a power Failure on node-1 , we start our application on node-2 but our problem is that now after a failover onto node-2 the DB deamon on node-2 will fail to start. did you see that lines of your log? 2015-07-03 16:04:03 17753 [Note] InnoDB: Retrying to lock the first data file 2015-07-03 16:04:04 17753 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2015-07-03 16:04:04 17753 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. Yes , But i dont have any mysqld process running on the node-2 as i have mentioned above and attempting to start mysqld on node-2 is when i face this issue for which the logs are showing the above error message. Thanks Jatin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Unable to start mysql after power Failure
Am 04.07.2015 um 06:24 schrieb Jatin Davey: We are trying to High Availability solution for our database. We have our application running on a node-1 and the DB running on the shared storage which is shared across node-1 & node-2. Whenever there is a power Failure on node-1 , we start our application on node-2 but our problem is that now after a failover onto node-2 the DB deamon on node-2 will fail to start. did you see that lines of your log? 2015-07-03 16:04:03 17753 [Note] InnoDB: Retrying to lock the first data file 2015-07-03 16:04:04 17753 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2015-07-03 16:04:04 17753 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. signature.asc Description: OpenPGP digital signature
Unable to start mysql after power Failure
Hi All We are trying to High Availability solution for our database. We have our application running on a node-1 and the DB running on the shared storage which is shared across node-1 & node-2. Whenever there is a power Failure on node-1 , we start our application on node-2 but our problem is that now after a failover onto node-2 the DB deamon on node-2 will fail to start. Mysql version information: ** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 58 Server version: 5.6.10-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> *** On the node-2 when the DB deamon tries to start we are seeing the following error messages in the log file: Error Message * 150703 16:01:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/data 2015-07-03 16:01:11 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-07-03 16:01:11 16278 [Note] Plugin 'FEDERATED' is disabled. 2015-07-03 16:01:12 16278 [Note] InnoDB: The InnoDB memory heap is disabled 2015-07-03 16:01:12 16278 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-07-03 16:01:12 16278 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-07-03 16:01:12 16278 [Note] InnoDB: CPU does not support crc32 instructions 2015-07-03 16:01:12 16278 [Note] InnoDB: Using Linux native AIO 2015-07-03 16:01:12 16278 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2015-07-03 16:01:12 16278 [Note] InnoDB: Completed initialization of buffer pool 2015-07-03 16:01:12 16278 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2015-07-03 16:01:12 16278 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2015-07-03 16:01:12 16278 [Note] InnoDB: Retrying to lock the first data file 2015-07-03 16:01:13 16278 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2015-07-03 16:01:13 16278 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2015-07-03 16:01:14 16278 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2015-07-03 16:01:14 16278 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2015-07-03 16:01:15 16278 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2015-07-03 16:02:52 16278 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2015-07-03 16:02:52 16278 [Note] InnoDB: Unable to open the first data file 2015-07-03 16:02:52 7f9b9194e720 InnoDB: Operating system error number 11 in a file operation. InnoDB: Error number 11 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html 2015-07-03 16:02:52 16278 [ERROR] InnoDB: Can't open './ibdata1' 2015-07-03 16:02:52 16278 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data! 2015-07-03 16:02:52 16278 [ERROR] Plugin 'InnoDB' init function returned error. 2015-07-03 16:02:52 16278 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2015-07-03 16:02:52 16278 [ERROR] Unknown/unsupported storage engine: InnoDB 2015-07-03 16:02:52 16278 [ERROR] Aborting 2015-07-03 16:02:52 16278 [Note] Binlog end 2015-07-03 16:02:52 16278 [Note] Shutting down plugin 'partition' 2015-07-03 16:02:52 16278 [Note] Shutting down plugin 'ARCHIVE' 2015-07-03 16:02:52 16278 [Note] Shutting down plugin 'BLACKHOLE' 2015-07-03 16:02:52 16278 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2015-07-03 16:02:52 16278 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2015-07-03 16:02:52 16278 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2015-07-03 16:02:52 16278 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2015-07-03 16:02:52 16278 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2015-07-03 16:02:52 16278 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2015-07-03 16:02:52 16278 [
unable to start mysql
dear sir good wishes. in my previous mail i explained mine mysql regarding problem. here is my mysqlbug file. i hope i will help you to solve my mysql regarding problem. help me to run mysql. thanks. ayion -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Unable to start MySQL
2 things -- 1) Permissions on your /mysql/data/ directory. User mysql needs to have ownership, group mysql needs to have ownership as well. shell> groupadd mysql shell> useradd -g mysql mysql shell> chown -R root /path/to/mysql/. shell> chown -R mysql /path/to/mysql/data/. shell> chgrp -r mysql /path/to/mysql/. 2) Check the .err file. It will tell you why you are getting those errors. More than likely the permissions. J.R. -Original Message- From: Jason Williard [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 15, 2005 12:33 PM To: mysql@lists.mysql.com Subject: Unable to start MySQL Hello, I have been trying to install and run MySQL on a Redhat Enterprise machine. The installation appears to go just fine, but when I go to run it, MySQL doesn't startup. Here is what I have done so far: INSTALLATION: ./configure --with-openssl=/usr/local/ssl --with-openssl-includes=/usr/local/ssl/include --with-openssl-libs=/usr/local/ssl/lib --with-isam --with-archive-storage-engine --with-csv-storage-engine make && make install /usr/bin/mysql_install_db --user=mysql After doing the above, I tried running MySQL with the following commands: /usr/bin/safe_mysqld & /usr/bin/safe_mysqld --user=mysql & Each of these resulted in this sort of response: --- [EMAIL PROTECTED] usr]# /usr/bin/safe_mysqld --user=mysql & [1] 14204 [EMAIL PROTECTED] usr]# Starting mysqld daemon with databases from /var/lib/mysql 050215 11:31:25 mysqld ended [1]+ Done/usr/bin/safe_mysqld --user=mysql [EMAIL PROTECTED] usr]# --- Any assistance with this would be greatly appreciated. --- Thank You, Jason Williard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Unable to start MySQL
Hello, I have been trying to install and run MySQL on a Redhat Enterprise machine. The installation appears to go just fine, but when I go to run it, MySQL doesn't startup. Here is what I have done so far: INSTALLATION: ./configure --with-openssl=/usr/local/ssl --with-openssl-includes=/usr/local/ssl/include --with-openssl-libs=/usr/local/ssl/lib --with-isam --with-archive-storage-engine --with-csv-storage-engine make && make install /usr/bin/mysql_install_db --user=mysql After doing the above, I tried running MySQL with the following commands: /usr/bin/safe_mysqld & /usr/bin/safe_mysqld --user=mysql & Each of these resulted in this sort of response: --- [EMAIL PROTECTED] usr]# /usr/bin/safe_mysqld --user=mysql & [1] 14204 [EMAIL PROTECTED] usr]# Starting mysqld daemon with databases from /var/lib/mysql 050215 11:31:25 mysqld ended [1]+ Done/usr/bin/safe_mysqld --user=mysql [EMAIL PROTECTED] usr]# --- Any assistance with this would be greatly appreciated. --- Thank You, Jason Williard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unable to Start MySQL on FreeBSD4.10 box
"Lynette Tillner" <[EMAIL PROTECTED]> wrote: > I'm setting up a development box with FreeBSD 4.10 and installed MySQL = > 4.0.12 on it. Everything in the install appeared to work smoothly.=20 > > However, when I go to start MySQL I get an error that says:=20 > > database list could not be retrieved > > So, how do I fix this? I've been unable to find any documentation that = > sheds any light on what I need to change.=20 Doesn't look like a MySQL error message. Please read http://dev.mysql.com/doc/mysql/en/Unix_post-installation.html and http://dev.mysql.com/doc/mysql/en/FreeBSD.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unable to Start MySQL on FreeBSD4.10 box
Lynette Tillner wrote: I'm setting up a development box with FreeBSD 4.10 and installed MySQL 4.0.12 on it. Everything in the install appeared to work smoothly. However, when I go to start MySQL I get an error that says: database list could not be retrieved So, how do I fix this? I've been unable to find any documentation that sheds any light on what I need to change. Are you using webmin? Try installing and starting MySQL by following the manual. Regards, Mikael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Unable to Start MySQL on FreeBSD4.10 box
Hi! I'm setting up a development box with FreeBSD 4.10 and installed MySQL 4.0.12 on it. Everything in the install appeared to work smoothly. However, when I go to start MySQL I get an error that says: database list could not be retrieved So, how do I fix this? I've been unable to find any documentation that sheds any light on what I need to change. Thanks for any help. Lynette
unable to start mysql new install
I am new so forgive me if i'm asking a stupid question. I did a reinstall (rpm) of my mysql 3.23 running on SuSE8.0 when I tried to run msql after running msql_install_db I get the error below. Just to give some bacground info. After getting connection errors regarding permissions (see previous e-mail) I deleted the mysql folder under /var/lib/mysql per the documentation. any help ? 040120 10:44:39 mysqld started 040120 10:44:39 Can't start server : Bind on unix socket: Permission denied 040120 10:44:39 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 040120 10:44:39 Aborting 040120 10:44:39 /usr/sbin/mysqld-max: Shutdown Complete 040120 10:44:39 mysqld ended -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unable to start MYSQL
"Suresh Babu A. [IT Engineer]" <[EMAIL PROTECTED]> wrote: > > I couldn't start the mysql in the red hat 8, due the bad > configuration in my.cnf and non availability of data file for > the database. I want to reinstall the mysql, kindly let me know how to. You can just edit my.cnf file. > > I have also tried "rmp -e .rpm' and removed the files from > /var/lib/mysql. Reinstalled everything, still i couldn't make it. > > Pacakage availabe now : - > > [EMAIL PROTECTED] mysql]# rpm -qa | grep -i mysql > MySQL-bench-4.0.13-0 > MySQL-server-4.0.13-0 > MySQL-shared-4.0.13-0 > MySQL-shared-compat-4.0.13-0 > MySQL-devel-4.0.13-0 > MySQL-client-4.0.13-0 > MySQL-embedded-4.0.13-0 > Mysql-DBI-perl-bin-1.1825-1 > > > Error at startup : - > > 030829 17:09:57 mysqld started > 030829 17:09:57 InnoDB: Started > 030829 17:09:57 Fatal error: Can't open privilege tables: Table 'mysql.host' do > esn't exist > 030829 17:09:57 Aborting > > 030829 17:09:57 InnoDB: Starting shutdown... > 030829 17:09:59 InnoDB: Shutdown completed > 030829 17:09:59 /usr/sbin/mysqld: Shutdown Complete > > 030829 17:09:59 mysqld ended Check if privilege tables exist. If so check permissions on the files. If you don't have privilege tables, run mysql_install_db script. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Unable to start MYSQL
Hi Team, I couldn't start the mysql in the red hat 8, due the bad configuration in my.cnf and non availability of data file for the database. I want to reinstall the mysql, kindly let me know how to. I have also tried "rmp -e .rpm' and removed the files from /var/lib/mysql. Reinstalled everything, still i couldn't make it. Pacakage availabe now : - [EMAIL PROTECTED] mysql]# rpm -qa | grep -i mysql MySQL-bench-4.0.13-0 MySQL-server-4.0.13-0 MySQL-shared-4.0.13-0 MySQL-shared-compat-4.0.13-0 MySQL-devel-4.0.13-0 MySQL-client-4.0.13-0 MySQL-embedded-4.0.13-0 Mysql-DBI-perl-bin-1.1825-1 Error at startup : - 030829 17:09:57 mysqld started 030829 17:09:57 InnoDB: Started 030829 17:09:57 Fatal error: Can't open privilege tables: Table 'mysql.host' do esn't exist 030829 17:09:57 Aborting 030829 17:09:57 InnoDB: Starting shutdown... 030829 17:09:59 InnoDB: Shutdown completed 030829 17:09:59 /usr/sbin/mysqld: Shutdown Complete 030829 17:09:59 mysqld ended 030829 17:10:09 mysqld started 030829 17:10:10 InnoDB: Started 030829 17:10:10 Fatal error: Can't open privilege tables: Table 'mysql.host' do esn't exist 030829 17:10:10 Aborting 030829 17:10:10 InnoDB: Starting shutdown... 030829 17:10:12 InnoDB: Shutdown completed 030829 17:10:12 /usr/sbin/mysqld: Shutdown Complete 030829 17:10:12 mysqld ended -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Unable to start MYSQL
Hi Team, I am unable to start the mysql service at my red hat 8, below is the error. What it is all about ? /usr/sbin/mysqld: ERROR: unknown option '--log-bin # required for re plication' 030829 01:01:37 mysqld ended Thanks in advance Suresh A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unable to start mysql
Pushpinder Singh Garcha <[EMAIL PROTECTED]> wrote: > > I am using phpMyAdmin to administer my MySQl DB. I am running Mac OS > Jaguar. > when I try to strt up phpMyAdmin I get an error > > > Welcome to phpMyAdmin 2.4.0 > > Error > > MySQL said: > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > > > So I try to start up the MySQL Server manually by typing the following > on my command prompt: > and here are the results: > > [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe & > [1] 558 > [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases > from /usr/local/mysql/data > 030616 10:16:32 mysqld ended In the MySQL data dir you can find error log file: .err. It helps you to find causes of failed start. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unable to start mysql
Check permissions (mysql) of data files. Do You have host and mysql data files in your filesystem? If not launch ./scripts/mysql_installdb and relaunch te server. There is a file named (your machine).err where You found more info about errors Santino Hello All, I am using phpMyAdmin to administer my MySQl DB. I am running Mac OS Jaguar. when I try to strt up phpMyAdmin I get an error Welcome to phpMyAdmin 2.4.0 Error MySQL said: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) So I try to start up the MySQL Server manually by typing the following on my command prompt: and here are the results: [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe & [1] 558 [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases from /usr/local/mysql/data 030616 10:16:32 mysqld ended Please help. Thanks in advance. --Pushpinder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
unable to start mysql
Hello All, I am using phpMyAdmin to administer my MySQl DB. I am running Mac OS Jaguar. when I try to strt up phpMyAdmin I get an error Welcome to phpMyAdmin 2.4.0 Error MySQL said: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) So I try to start up the MySQL Server manually by typing the following on my command prompt: and here are the results: [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe & [1] 558 [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases from /usr/local/mysql/data 030616 10:16:32 mysqld ended Please help. Thanks in advance. --Pushpinder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: unable to start mysql
Don't re-install.. Fix the problem Try issuing shell>cd /usr/local/mysqlversion shell>./configure ~K Black -Original Message- From: mod_perl [mailto:shine_perl@;spectrum.net.in] Sent: Monday, November 11, 2002 10:23 PM To: [EMAIL PROTECTED] Subject: unable to start mysql hi all, when i try to start mysql using safe_mysqld & i get following message [mysql@inemrtest2 mysql]$ safe_mysqld & [1] 3644 [mysql@inemrtest2 mysql]$ Starting mysqld daemon with databases from /opt/mysql/data 021112 11:59:15 mysqld ended if mysqld is crashed how can i reinstall thanks in advance shine - 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 - 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: unable to start mysql
Pada Tue, 12 Nov 2002 11:52:32 +0530 "mod_perl" <[EMAIL PROTECTED]> menulis: > hi all, > when i try to start mysql using safe_mysqld & i get following message > [mysql@inemrtest2 mysql]$ safe_mysqld & > [1] 3644 > [mysql@inemrtest2 mysql]$ Starting mysqld daemon with databases from > /opt/mysql/data > 021112 11:59:15 mysqld ended what system r u using now ? better to use start-stop init script, can be found inside support-files directory with name : mysql.server also see error messages in .err file for detail description. -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.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
unable to start mysql
hi all, when i try to start mysql using safe_mysqld & i get following message [mysql@inemrtest2 mysql]$ safe_mysqld & [1] 3644 [mysql@inemrtest2 mysql]$ Starting mysqld daemon with databases from /opt/mysql/data 021112 11:59:15 mysqld ended if mysqld is crashed how can i reinstall thanks in advance shine - 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: unable to start mysql daemon
Hi, (please reply to the mailing list, no to me directly.) On Thu, 2002-03-21 at 19:17, Leecher wrote: > Thanks, > Yes, I logged in as Administrator. > > Just a question, why would running it as a service do any good, if I can't > even manually start the daemon? The daemon insists that all ports are in use > (even when they are not). If I can't manually start the daemon, then running > it as a service will not help, or? Maybe, but not definitely. But, did you follow the instructions in the manual *exactly* ? If I read http://www.mysql.com/doc/W/i/Windows_server_first_start.html it says "Testing from a DOS command prompt is the best thing to do because the server displays status messages that appear in the DOS window. If something is wrong with your configuration, these messages will make it easier for you to identify and fix any problems. Make sure you are in the directory where the server is located, then enter this command: C:\mysql\bin> mysqld-max --standalone " I didn't see the --standalone parameter in your earlier posting. Follow the manual exactly Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ 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
Re: unable to start mysql daemon
Hi, On Thu, 2002-03-21 at 01:03, Leecher wrote: > I installed mysql-3.23.49-win on Windows 2000 to drive D: (the installer > lets one choose the location). After reading the docs, I can see that I need > to start the daemon like this: > mysqld --basedir d:\mysql > However, when I do it I get this: > D:\mysql\bin>mysqld --basedir d:\mysql > Can't start server: Bind on TCP/IP port: No error > 020318 14:54:30 Do you already have another mysqld server running on port: > 3306 ? > Netstat -a reveals that nothing is using port 3306. The port is free. There > is no local firewall on the computer blocking the port either. Did you log on as Administrator? And... On Windows 2000, you should install mysqld as a service (see manual). Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ 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
unable to start mysql daemon - bug?
Hello, I hope someone here can help me out with this. I can't find anything in the documentation that does help. Everything points to the port being in use, however it isn't. I know it for a fact (netstat/telnet), no the mysqld also is not running, I know that for a fact (process list). I installed mysql-3.23.49-win on Windows 2000 to drive D: (the installer lets one choose the location). After reading the docs, I can see that I need to start the daemon like this: mysqld --basedir d:\mysql However, when I do it I get this: D:\mysql\bin>mysqld --basedir d:\mysql Can't start server: Bind on TCP/IP port: No error 020318 14:54:30 Do you already have another mysqld server running on port: 3306 ? 020318 14:54:31 Aborting 020318 14:54:31 mysqld: Shutdown Complete Netstat -a reveals that nothing is using port 3306. The port is free. There is no local firewall on the computer blocking the port either. I have also tried the --port option to point to another port. Nope. Interesting how mysql says all ports are in use, even when they are not. Running mysqld without any arguments results in a 30 sec delay, then the command prompt reapears and the deamon is not running. I added a my.cnf to the C:\ and this also has no effect. I then removed this and tried the winmysqladmin.exe and this also does not help. However, it also does not report any errors, with the exception of trying to generate an error report with it, which returns the wonderfull error message that it can't generate a report because it can't connect to the server, hmm, why offer to generate an error report if it can only do it when it can connect? Not much help when you can get the server started. Can someone please explain to me how in the world to get the mysql server running on Windows 2000? I have administrator rights to the computer and have restarted after the installation. Thanks - Synopsis: Impossible to start or use mysql (or the daemon) based on the documentation. Organization: None MySQL support: None Severity: Fatal Priority: medium Category: mysqld Class: sw-bug Release: mysql-3.23.49 Exectutable: mysqld Environment: PIII800, 256MB RAM, 14GB free hdd space System:Win200 Compiler: NA Architecture: i - 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
Unable to start mysql
Hello, I've been using MySQL for over two years running out of my own directory with my userid. My current version is 3.23.40. Recently in upgrading my system, I installed mysql-3.23.36-1.i386.rpm built by RedHat as user root because it was needed to install rpm2html. Though installed, this version of mysql was never run. After installing the rpm, I was unable to start my private version of MySQL using safe_mysqld because it always attempted to access the databases in the rpm defined directory (/usr/share/mysql/var I think, sorry, I didn't write it down). This failed because under my userid I do not have write permission for this directory. In any case, it is not where I have my private databases. Since it was not obvious how to force the safe_mysqld script to use my private directory, I removed the rpm and the problem went away. It would be preferable if a private installation (complete build and install) would be totally self-sufficient by default and not confused/usurped by a subsequent rpm installation. Best regards, Kern PS: Thanks for the nice package, keep up the good work. - 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