Why does my delete not work :(
Hi all! I've got this piece of SELECT statement for MySql. SELECT * FROM messages LEFT OUTER JOIN main ON messages.topicid=main.topicid WHERE main.topicid is null; so the select statement works fine. But what I'd like to do is actually delete those rows instead. but substituting SELECT with DELETE doesn't work :( Please help! i'm pulling out my hair - 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: Why does my delete not work :(
So you're saying there's no actual DELETE statement for this? There is no way in hell I can write any SQL to do that?? Thats sucks... :( Thanks for the example, but how do I run it? I've only used PHP for taking information out of a database and other simple MySQL queries so while your Perl example kinda makes sense, I don't understand how to work it. Do I just put that in a file and run open the file in a browser? Thanks! sunny At 08:12 29/03/02 -0700, Rodney Broom wrote: Good morning Sunny, From: sunny [EMAIL PROTECTED] ...substituting SELECT with DELETE doesn't work :( That's right, that's how MySQL works. And it doesn't support sub-queries for this case, either. So you can't say: delete from table where field in (select field from other_table) I'd suggest doing this from another language, like Perl. For instance: $list_list = $dbh-selectall_arrayref(qq{ SELECT messages.topicid FROM messages LEFT OUTER JOIN main ON messages.topicid=main.topicid WHERE main.topicid is null }); for my $row ( @{$list_list} ) { $dbh-do(qq{DELETE FROM messages WHERE topicid = $row-[0]}); } Note, my example is rough, and not tuned for performance. But you get the idea. Hollar if you still need a hand with this. --- Rodney Broom Programmer: Desert.Net - 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: Please help - About doing a delete.
well i can do the select that way, but i was wondering how the following delete command would only pick up the rows in the select. isn't there a way of imbedding delete in the select statement? can anyone else help as well please? thanks sunny At 19:46 14/03/02 -0500, Jim Philips wrote: To select the rows you are looking for, you can use: select * from messages left join topics on topics.topic_id=messages.topic_id where topics.topic_id is null; This works fine for selecting. But for some reason the corresponding SQL for a delete fails: mysql delete from messages - left join topics on topics.topic_id=messages.topic_id - where topics.topic_id is null; ERROR 1064: You have an error in your SQL syntax near 'left join topics on topics.topic_id=messages.topic_id Anybody know how to make the delete statement work? On Thu, 2002-03-14 at 15:57, sunny wrote: How do i do a select first and then delete those rows? sorry.. im just confused. i tried that mysql, but it didn't work... gave me an error :( Any ideas? thanks! /sunny At 20:54 13/03/02 -0500, you wrote: What you need is a delete with a left join. Something like this: delete from messages left join messages on topics.topic_id=messages.topic_id where topics.topic_id is null; Try it first using a select instead of a delete to be sure it captures the right rows. But this ought to work. On Wed, 2002-03-13 at 17:53, sunny wrote: Hi everyone, I've got a really annoying problem with mysql, and I was hoping someone could help. I've got 2 tables in Mysql: Table 1 - Topics | topic_id | name | subject | comment | - | 1 | john | weather| the weather today blah blah| Table 2 - Messages |message_id | topic_id | name | subject | comment | - | 12| 1 | billy | yes it ...| i totally agree| Basically, in the messages table, each row has its own unique id, but also a topic_id column which relates to the topic_id in the Topics table. What I want to do is delete all messages in the message table for which the relating topic_id has been already deleted in the Topics table. For example, if the row with topic_id 5 was deleted in Topics table, I want to make sure there are no messages in the Messages table which have a topic_id of 5. Please please, any help would be greatly appreciated. I'm running MySQL 3.23.46 on UNIX. TIA! sunny - 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
Please help! - About doing a delete.
Hi everyone, I've got a really annoying problem with mysql, and I was hoping someone could help. I've got 2 tables in Mysql: Table 1 - Topics | topic_id | name | subject | comment | - | 1 | john | weather| the weather today blah blah| Table 2 - Messages |message_id | topic_id | name | subject | comment | - | 12| 1 | billy | yes it ...| i totally agree| Basically, in the messages table, each row has its own unique id, but also a topic_id column which relates to the topic_id in the Topics table. What I want to do is delete all messages in the message table for which the relating topic_id has been already deleted in the Topics table. For example, if the row with topic_id 5 was deleted in Topics table, I want to make sure there are no messages in the Messages table which have a topic_id of 5. Please please, any help would be greatly appreciated. I'm running MySQL 3.23.46 on UNIX. TIA! sunny - 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
Mysql -server conflicts error
Hi All, I tried to upgrade mysql database from mysql-server-3.23.36-1 to mysql-3.23.43-1. However, when I downloaded and used rpm -i MySQL-3.23.43-1.i386.rpm I received the following error: error: failed dependencies: MySQL conflicts with mysql-3.23.36-1 MySQL -server conflicts with mysql-server-3.23.36-1 Please help! Thanks! Sunny Ouyang - 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: emergency help
Thank you very much for your help. I got it fixed with the command 'safe_mysqld--old-protocol ' Thank YOU!!! -Original Message- From: Nico D [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 10:44 AM To: Simon Green Cc: Ouyang, Sunny; '[EMAIL PROTECTED]' Subject: RE: emergency help thats because your server isn't running. mysql is the client (AFAIK). But if your running redhat, you can /etc/rc.d/init.d/mysql start and it should work -nico -Original Message- From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 15:10 To: 'Simon Green'; '[EMAIL PROTECTED]' Subject: RE: emergency help no. Not at all. I logged into Linux server, type mysql. the server gave the message says : error 2002: can't connect to local MYSQL server through socket '/tmp/mysql.sock. Anyone has idea what's wrong with it? -Original Message- From: Simon Green [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 9:52 AM To: Ouyang, Sunny; '[EMAIL PROTECTED]' Subject: RE: emergency help Is mysqld runing? Simon -Original Message- From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 14:56 To: '[EMAIL PROTECTED]' Subject: emergency help Hi, I am seeking emergency help to start up mysql database server. I tried to use myodbc to connect mysql database from windows. I added a user on mysql database user table and db table. Last Saturday when I rebooted Red Hat Linux, mysql database server didn't come back any more. I don't know whether what I did causes this problem. Now I can not connect to mysql when I use mysql command. Please help me! All of our users rely on this database. I would appreciate it if someone could give me help. Thank you!!! Sunny Ouyang Orion System, Inc 525 Avis Dr. Ann Arbor, MI 48108 (734)214-2967 [EMAIL PROTECTED] - 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 -- Nico Darrow RHCE CEO DeckerNET LLC Network Engineer/Programmer email:[EMAIL PROTECTED] ph:706.254.2128 The software said it worked with windows 95 or better, so I installed linux. - NA I'm not saying Bill Gates is the devil, its just that if he ever went to hell, he wouldn't need a translator. -LJ I'll do that just now. -nico Never trust a engineer that tatoo's his IP address on his arm, especially if its DHCP. - /. - 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
emergency help
Hi, I am seeking emergency help to start up mysql database server. I tried to use myodbc to connect mysql database from windows. I added a user on mysql database user table and db table. Last Saturday when I rebooted Red Hat Linux, mysql database server didn't come back any more. I don't know whether what I did causes this problem. Now I can not connect to mysql when I use mysql command. Please help me! All of our users rely on this database. I would appreciate it if someone could give me help. Thank you!!! Sunny Ouyang Orion System, Inc 525 Avis Dr. Ann Arbor, MI 48108 (734)214-2967 [EMAIL PROTECTED] - 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: emergency help
no. Not at all. I logged into Linux server, type mysql. the server gave the message says : error 2002: can't connect to local MYSQL server through socket '/tmp/mysql.sock. Anyone has idea what's wrong with it? -Original Message- From: Simon Green [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 9:52 AM To: Ouyang, Sunny; '[EMAIL PROTECTED]' Subject: RE: emergency help Is mysqld runing? Simon -Original Message- From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 14:56 To: '[EMAIL PROTECTED]' Subject: emergency help Hi, I am seeking emergency help to start up mysql database server. I tried to use myodbc to connect mysql database from windows. I added a user on mysql database user table and db table. Last Saturday when I rebooted Red Hat Linux, mysql database server didn't come back any more. I don't know whether what I did causes this problem. Now I can not connect to mysql when I use mysql command. Please help me! All of our users rely on this database. I would appreciate it if someone could give me help. Thank you!!! Sunny Ouyang Orion System, Inc 525 Avis Dr. Ann Arbor, MI 48108 (734)214-2967 [EMAIL PROTECTED] - 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: emergency help
Yes. All of our mysql databases are there. -Original Message- From: Luca Accomazzi [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 10:28 AM To: Ouyang, Sunny; '[EMAIL PROTECTED]' Subject: Re: emergency help I got the message: [root@mothra /tmp]# safe_mysqld [1] 3922 [root@mothra /tmp]# Starting mysqld daemon with databases from /usr/local/var mysqld daemon ended Are your databases in there? If you do a ll /usr/local/var Do you see a directory for each database of yours, with the same names? L.A. - 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: emergency help
I got the message: [root@mothra /tmp]# safe_mysqld [1] 3922 [root@mothra /tmp]# Starting mysqld daemon with databases from /usr/local/var mysqld daemon ended This is what I got when I rebooted the Linux server. -Original Message- From: Luca Accomazzi [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 10:14 AM To: Ouyang, Sunny; '[EMAIL PROTECTED]' Subject: Re: emergency help Last Saturday when I rebooted Red Hat Linux, mysql database server didn't come back any more. Try typing this on the command line: safe_mysqld Then tell us what happens. :-) L.A. - 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: emergency help
Hi Brian, I checked boot.log and found the following message. I don't know whether this causes the problem. Do you know what is DSO module? Do I really need to recompile it? If so, how I can recompile it? Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO modul es/mod_include.so uses plain Apache 1.3 API, this module might crash under EAPI! (please recompile it with -DEAPI) Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO modul es/mod_autoindex.so uses plain Apache 1.3 API, this module might crash under EAP I! (please recompile it with -DEAPI) Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO modul es/mod_dir.so uses plain Apache 1.3 API, this module might crash under EAPI! (pl ease recompile it with -DEAPI) Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO modul es/mod_cgi.so uses plain Apache 1.3 API, this module might crash under EAPI! (pl ease recompile it with -DEAPI) Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO modul es/mod_asis.so uses plain Apache 1.3 API, this module might crash under EAPI! (p lease recompile it with -DEAPI) Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO modul es/mod_imap.so uses plain Apache 1.3 API, this module might crash under EAPI! (p lease recompile it with -DEAPI) Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO modul es/mod_actions.so uses plain Apache 1.3 API, this module might crash under EAPI! (please recompile it with -DEAPI) -Original Message- From: Brian Warn [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 10:24 AM To: Ouyang, Sunny Subject: Re: using myodbc for mysql database on RedHat6.2 Sunny, What errors do you get? tail -20 (or so) on your mysql error file (mine is located under mysql/data) to see what it is telling you. Also look (as root) at your boot.log and messages files under /var/log to see what they have to say about this. If I had to hazard a guess as to where the problem lies, I'm guessing -- assuming that safe_mysqld is running -- that permissions is what needs to be fixed. If safe_mysqld isn't running, go to your mysql directory and then, as root, run nohup bin/safe_mysqld . If you get errors telling you that problems exist in writing to /tmp/mysql.sock, chmod your /tmp dir to 777 and try starting safe_mysqld again. If this doesn't work, I can only recommend asking the mysql list about it to see what other recommendations people have. -Brian - Original Message - From: Ouyang, Sunny [EMAIL PROTECTED] To: 'Brian Warn' [EMAIL PROTECTED] Sent: Monday, June 04, 2001 6:43 AM Subject: RE: using myodbc for mysql database on RedHat6.2 Hi Brian, Emergency. Please help. I rebooted Linux server last Saturday. Right after that mysql database doesn't start at all. Do you know how I can start it? Does my change on user table and db table affect all this? Please advice the sooner the better. Thanks! -Original Message- From: Brian Warn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 12:32 AM To: Ouyang, Sunny Subject: Re: using myodbc for mysql database on RedHat6.2 Sunny, If it were me in your position, I'd still rely on the myobc or mysql lists. I continue to recommend providing those lists the steps that we tried and see if anyone misses anything I have so far missed. -Brian - Original Message - From: Ouyang, Sunny [EMAIL PROTECTED] To: 'Warn, Brian' [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 8:41 AM Subject: RE: using myodbc for mysql database on RedHat6.2 Hi Brian, Thank you very much for your explanation. That makes sense. Otherwise, the database becomes too complex. Do you know where I can find better documentation setup myodbc? I feel frustrated. It still doesn't work. I really appreciate your sincere help. No word I can use to express my appreciation. Thanks!! Please let me know if you have some solution. Thanks! -Original Message- From: Warn, Brian [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 11:32 AM To: Ouyang, Sunny Subject: Re: using myodbc for mysql database on RedHat6.2 Hi Sunny, No, you don't need to create these tables in your irl db. The mysql database is a global (probably a better term for it, but this is how I think of it), database used by all other databases on your server. mysql reads the mysql db before going to any other db. By doing this, mysql reads permissions, users, etc. so that it can grant the appropriate level of access and so forth to users of the other databases. -Brian - Original Message - From: Ouyang, Sunny [EMAIL PROTECTED] To: 'Brian Warn' [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 8:22 AM Subject: RE: using myodbc for mysql database on RedHat6.2 Hi Brian, I have last question about it. I checked on our mysql datase server. I found there aren't user and db tables on irl database. I am wondering
RE: emergency help
I found my '/tmp/mysql.sock' is also empty. Is this supposed to be empty? my '/tmp/myscript' is empty, too. Are they correct? -Original Message- From: karel pitra [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 10:33 AM To: Ouyang, Sunny Subject: Re: emergency help check whether /tmp/mysql.sock exists and whether you as a user are allowed to modify it On Mon 4. June 2001 16:09, you wrote: no. Not at all. I logged into Linux server, type mysql. the server gave the message says : error 2002: can't connect to local MYSQL server through socket '/tmp/mysql.sock. Anyone has idea what's wrong with it? -Original Message- From: Simon Green [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 9:52 AM To: Ouyang, Sunny; '[EMAIL PROTECTED]' Subject: RE: emergency help Is mysqld runing? Simon -Original Message- From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 14:56 To: '[EMAIL PROTECTED]' Subject: emergency help Hi, I am seeking emergency help to start up mysql database server. I tried to use myodbc to connect mysql database from windows. I added a user on mysql database user table and db table. Last Saturday when I rebooted Red Hat Linux, mysql database server didn't come back any more. I don't know whether what I did causes this problem. Now I can not connect to mysql when I use mysql command. Please help me! All of our users rely on this database. I would appreciate it if someone could give me help. Thank you!!! Sunny Ouyang Orion System, Inc 525 Avis Dr. Ann Arbor, MI 48108 (734)214-2967 [EMAIL PROTECTED] - 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 - 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: emergency help
Yes. Here it is: mysqld started on Sat May 5 14:02:18 EDT 2001 /usr/local/libexec/mysqld: ready for connections mysqld started on Wed May 9 19:19:34 EDT 2001 /usr/local/libexec/mysqld: ready for connections 010524 10:41:04 Found invalid password for user: '[EMAIL PROTECTED]'; Igno ring user 010524 10:44:30 Found invalid password for user: '[EMAIL PROTECTED]'; Igno ring user 010524 11:00:51 Found invalid password for user: 'ouyang@2000ouyang'; Ignoring user 010524 13:24:04 Found invalid password for user: 'amir@2000ouyang'; Ignoring us er 010524 13:30:38 Found invalid password for user: 'amir@2000ouyang'; Ignoring us er 010524 13:30:54 Found invalid password for user: 'amir@2000ouyang'; Ignoring us er 010524 15:24:45 Found invalid password for user: 'amir@%'; Ignoring user 010524 15:31:28 Found invalid password for user: 'amir@%'; Ignoring user mysqld started on Sat Jun 2 22:18:02 EDT 2001 010602 22:18:05 Found old style password for user 'helpdesk'. Restart using --o ld-protocol mysqld ended on Sat Jun 2 22:18:05 EDT 2001 mysqld started on Mon Jun 4 09:09:20 EDT 2001 010604 9:09:22 Found old style password for user 'helpdesk'. Restart using --o ld-protocol mysqld ended on Mon Jun 4 09:09:22 EDT 2001 mysqld started on Mon Jun 4 09:44:39 EDT 2001 010604 9:44:41 Found old style password for user 'helpdesk'. Restart using --o ld-protocol 010604 9:44:41 /usr/local/libexec/mysqld: Normal shutdown 010604 9:44:41 /usr/local/libexec/mysqld: Shutdown Complete mysqld ended on Mon Jun 4 09:44:41 EDT 2001 mysqld started on Mon Jun 4 10:27:28 EDT 2001 010604 10:27:28 Found old style password for user 'helpdesk'. Restart using --o ld-protocol mysqld ended on Mon Jun 4 10:27:29 EDT 2001 [root@mothra var]# -Original Message- From: Rafal Jank [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 11:18 AM To: Ouyang, Sunny Cc: '[EMAIL PROTECTED]' Subject: Re: emergency help "Ouyang, Sunny" wrote: Yes. All of our mysql databases are there. Do you have error log file? It should be in /usr/local/var -Original Message- From: Luca Accomazzi [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 10:28 AM To: Ouyang, Sunny; '[EMAIL PROTECTED]' Subject: Re: emergency help I got the message: [root@mothra /tmp]# safe_mysqld [1] 3922 [root@mothra /tmp]# Starting mysqld daemon with databases from /usr/local/var mysqld daemon ended Are your databases in there? If you do a ll /usr/local/var Do you see a directory for each database of yours, with the same names? L.A. - 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 -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - 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