after upgrade to 4.1 - error in multi delete

WHERE r.ID = rp.recommendations_id AND r.user_recommending = '$user_id' "; Error: 1109 Unknown table 'the_table_name' in MULTI DELETE Has there something changed in the syntax? Thank you for any help, Merlin -- MySQL General Mailing List For list ar

Mysql takes server down

for it. Since I have disabled the webapp, but as soon as I start mysql the system starts going down. has anybody an idea what is going wrong? Thank you for any help, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Performance - one integrated LAMP vs. seperate web, DB Server

would also be 100 Euro cheaper per month. Server load is currently between 1.5 and sometimes 5. Thank you for any help on this triky question. Best regards, merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Default root password not blank?

d for user 'root'@'localhost' (using password: NO)' Is there a special command for "blank"? As I noted using password NO for hitting return. Thank you for any hint, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Enabling loging on mysql 3.x

with some hints how to enable both of the log files? thank you for any help, merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query to slow after inserting another table

Hi, thank you for this hint. That worked excellent! Now the overall query time is about 0.1 s on average. Best regards, Merlin On Sat, 27 May 2006 02:14:34 -0700, "Merlin" <[EMAIL PROTECTED]> said: > Well this is exactly the problem. The OR statement. Do you think there

Re: Query to slow after inserting another table

Well this is exactly the problem. The OR statement. Do you think there is another way around the tmp table. I did not make the best experiances with tmp tables. regards, merlin On Sat, 27 May 2006 00:26:09 -0500, "mos" <[EMAIL PROTECTED]> said: > Merlin, > Lose the

Query to slow after inserting another table

_id album_id 3 cl.ID 1 ar eq_ref PRIMARY PRIMARY 2 cl.area_id 1 ta ref ad_id ad_id 3 cl.ID 2 Using where I am completly lost here. I assume that there is a much better way to include the tags table into the search. Any ideas? Thank you for any help on that. Merlin -- Merlin [EMAIL PROTECTED]

Re: updates during database dump

anks. > Kind regards. > > -- > Luke Vanderfluit. > Analyst/Programmer. > Internode Systems Pty. Ltd. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Merlin,

Adding stop words table in german language

help, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: DBDesigner4 under Linux

t; Changed startdbd script to force dirs path and nothing. > > Need help on this? Or perhaps if someone point me out in the direction > off ODBC connect to MySQL? I've never did this so don't know where to > start... > > Thanks, > Bruno -- Merlin,

deleting rows in 2 tables

WHERE ID = '$data[table1_id]' LIMIT 1 # delete main entry DELETE FROM $DB.$T4 WHERE ID = '$data[id]' LIMIT 1 Is there a better solution as this? Thanx for any hint, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/

fulltext search on words inside words

xclude popular words like "and" "for" and similar from the search? Is there a MySQL setting for this. Like "words_to_exclude =" Thanx, Merlin Oh.. I am running MySQL 4.0.14 on Suse Linux 9. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: deleting unwanted rows

[EMAIL PROTECTED] wrote: Merlin <[EMAIL PROTECTED]> wrote on 10/04/2005 10:58:21 AM: > [EMAIL PROTECTED] wrote: > > > > > > > Merlin <[EMAIL PROTECTED]> wrote on 10/04/2005 10:21:00 AM: > > > > > Hi there, > > > > > > I ju

deleting unwanted rows

reds of thousends of results. I also tryed to group by t1.ID, but it did not help Does anybody have a good idea how to get rid of those rows? Thanx, Merlin PS: Thanx for the answer for the question with full text search! That worked excellent! -- MySQL General Mailing List For list archives: ht

Full text search

by space and only 3 letter, I could not find a solution. Can anybody point me to the right way? Thank you for any help, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ROW_SIZE or something alike

ht try using the Data_length and Index_length values from > SHOW TABLE STATUS, divided by the number of rows. > > http://dev.mysql.com/doc/mysql/en/show-table-status.html > > -- > Keith Ivey <[EMAIL PROTECTED]> > Smokefree DC > http://www.smokefreedc.org > Washington

Re: COUNT Problem

, Tasks T > WHERE P.Project_ID = T.Project_ID > AND Project_ID > 2; > > So if Project A has 3 tasks and Project B has 4 tasks I need the query to > return 4. > > Hope this makes sense! > > Thanks for your help -- Merlin, the Mage www.code.online.pt www.cultodavida.online.

Mysql eats all the cpu power

again everything is fine for weeks. Does anybody have an idea how to fix that, I am completly lost here :-( Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql eats all the CPU power

troutles down, so I have reboot and then again everything is fine for weeks. Does anybody have an idea how to fix that, I am completly lost here :-( Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

stressing mysql - configuration advice

e they get with the current settings. Is it possible to increase the number of users? I think this might be the main problem in my case. Any advice is apreciated. I am just starting to understand how to configure mysql server. Thank you in advance, Merlin -- MySQL General Mailing Lis

stressing mysql - configuration advice

e they get with the current settings. Is it possible to increase the number of users? I think this might be the main problem in my case. Any advice is apreciated. I am just starting to understand how to configure mysql server. Thank you in advance, Merlin -- MySQL General Mailing Lis

Re: Connect Error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Jonh, You're probably forget the -p param for mysqladmin ask you your root password. merlin Escreveu John Wilkerson em Thursday 02 January 2003 04:11 am: > Hi, > > I'm a newbie with MySQL and get the following error:

Re: Decrypt MYSQL Password

rgot your password page and want to have the user enter their > e-mail and have the password sent to them. > > Please help! > - -- Merlin, the Mage themage.camelot.co.pt -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see

Re: Crash importing old data to new server

e > data and frm but not the index, then rebuild on the new host. -- Merlin, the Mage themage.camelot.co.pt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: cant store checkbox vale ..... ?????

box fields are not sent. Or, the simplest way, just change your HTML to this sign me up fo weekly news letter and updates And this way, the value you get if the field is checked is allways 1. MPNeves -- Merlin, the Mage themage.camelot.co.pt