Re: mysql_upgrade script problems on MySQL 5.0.24

error: Found option without preceding group in config file: /u07/mysql/data/upgrade_defaults at line: 2 Fatal error in defaults handling. Program aborted This is your problem. What's in that file (/u07/mysql/data/upgrade_defaults) ? -- MySQL General Mailing List For list archives:

Re: Insane execution time for JOIN query

On 8/31/06, Harrison Fisk [EMAIL PROTECTED] wrote: Hello, On Aug 31, 2006, at 5:12 AM, Kim Christensen wrote: Hey list; I posted this message under an earlier thread which touched the same subject - but I realized my case could be slightly different, thus posting a new thread here. Sorry

LAMP Experts Needed

I am looking for some serious coders that want to make a name for themselves and/or a lot of money. I need to talk to any one who is considered an Expert with any of these: Linux Apache MySQL or PostgreSQL PHP, Perl, Python HTML CSS XML XSL I am going to convince my employer to replace a very

Comparing to a part of a string

Hi All, Is there a faster way of doing this query SELECT t1.to_uri as to_uri, t1.from_uri as from_uri, t1.sip_from as sip_from, t1.username as username, DATE(t1.time) as startdate, t1.time as start, t2.time as stop, TIMEDIFF(t2.time,t1.time) as timediff FROM acc AS t1 INNER JOIN acc AS t2 ON

Understanding Query-Cache math...

Hello I don't understand why query_cache_size / query_cache_min_res_unit != Qcache_total_blocks and Qcache_free_memory / query_cache_min_res_unit != Qcache_free_blocks Can anybody enlight me so that I know if I have to increase the Query-Cache or not? mysql SHOW status LIKE Qcache_%;

Re: mysql_upgrade script problems on MySQL 5.0.24

Hi, could it be this bug : http://bugs.mysql.com/bug.php?id=21011 2006/8/31, Whisler, David [EMAIL PROTECTED]: I've upgraded from 5.0.22 to 5.0.24 MySQL Server on Solaris 9 using the Solaris package utility (which means I de-installed 5.0.22 then installed 5.0.24 in the same location,

How to make this work ?

Hi All, How to make this work CREATE TABLE DB2.tblname LIKE DB1.tblname; Can we have simultaneous connections with 2 DBs? Regards, Ravi K The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the

Drop Index if Exists

Folks, Does this work in MYSQL 5? I tried DROP INDEX [NAME] IF EXISTS; and got an error check your syntax. Thanks - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Drop Index if Exists

Hello Adam,This is the exact syntax to drop the index.DROP INDEX index_name ON tbl_nameThanksVisolve DB Team . - Original Message - From: Adam Lipscombe [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, September 01, 2006 3:28 PM Subject: Drop Index if Exists Folks, Does

Re: Drop Index if Exists

Thanks What I am getting at is: does the IF EXISTS qualifier work in this context? I have an index that is present in some DB's but not in others. I want to run a generic script to upgrade them all. I don't want the script to stop if the index is not present. Thanks - Adam Visolve DB TEAM

Re: How to make this work ?

On Fri, Sep 01, 2006 at 03:17:14PM +0530, [EMAIL PROTECTED] wrote: How to make this work CREATE TABLE DB2.tblname LIKE DB1.tblname; It does work perfectly with 5.0. Mabe cross-database queries didn't work with earlier versions? Which version do you use? Can we have simultaneous

How to dump stored procedures to a file?

It seems that mysqldump on mysql 5.0 does not export my stored procedures. How do I dump these out so that other people can load them into their copies of my database? Matt -- A better way of running series of SAS programs: http://overlook.homelinux.net/wilsonwiki/SasAndMakefiles -- MySQL

RE: How to make this work ?

Hi Ravi, If you are working with one of *NIX, you can try to use $mysqldump --no-data DB1 tblname | mysql DB2 --no-data switch will dump only data base structure Regards, Mikhail Berman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 01,

Re: Insane execution time for JOIN query

On 8/31/06, Harrison Fisk ** [EMAIL PROTECTED] *** wrote: Hello, On Aug 31, 2006, at 5:12 AM, Kim Christensen wrote: Hey list; I posted this message under an earlier thread which touched the same subject - but I realized my case could be slightly different, thus posting a new

RE: mysql_upgrade script problems on MySQL 5.0.24

Chris, That's a great question. Especially since this file does not exist anywhere on my system. I'd be glad to create it by hand, but I wouldn't know what should be in it. I tried copying the my.cnf file to this location and naming it upgrade_defaults.cnf, upgrade_defaults, and also a 3rd

solaris build mysql from source using gcc

Hi, Any chance i could get somebody's help on how to build MySQL from source using the gcc compiler on Solaris (10)? Thanks, Charles

Re: solaris build mysql from source using gcc

Well if you'd share your specific problem I'm sure someone can help, but more importantly why are you building from source anyway? There are binary builds for most Solaris platforms, including 2.10. --On September 1, 2006 2:10:17 PM + [EMAIL PROTECTED] wrote: Hi, Any chance i could get

partial word search with FULLTEXT

MySQL FULLTEXT searches support wildcard suffixes such as: mysql SELECT * FROM articles WHERE MATCH (title,body) - AGAINST ('apple*' IN BOOLEAN MODE); which returns all title/body lines that contain the prefix 'apple', such as appleby appleseed but not bigapple redapple This

Mysql privileges

Hello, ok, you can tell me i'm a crazy boy... I've made a lot of changes to privileges in a mysql server. Then, i saw 2 root account: the first may be able to access from localhost, the second from all hosts. Mysql server is inside our intranet so i decided to drop [EMAIL PROTECTED] Now we

Re: Mysql privileges

* now i can access with [EMAIL PROTECTED] but i can't create databases What does show grants display when you login as root? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: solaris build mysql from source using gcc

--On September 1, 2006 8:38:21 AM -0600 Michael Loftis [EMAIL PROTECTED] wrote: Well if you'd share your specific problem I'm sure someone can help, but more importantly why are you building from source anyway? There are binary builds for most Solaris platforms, including 2.10. Sorry I

Re: solaris build mysql from source using gcc

Well if you'd share your specific problem I'm sure someone can help, but more importantly why are you building from source anyway? There are binary builds for most Solaris platforms, including 2.10. Sorry I meant 10 theremy solaris experience comes from the 'old days' before they went and

mysql crashes on drop database?

Hi, Each night I replicate a server running a 4.1 version of mysql via mysqldump and then import to a box running a 5.0.18-standard. It has been working well for some four or five months. Suddenly, the job started failing during the import. After stepping through the job, I determined that

Re: How to make this work ?

Mikhail Berman wrote: Hi Ravi, If you are working with one of *NIX, you can try to use $mysqldump --no-data DB1 tblname | mysql DB2 --no-data switch will dump only data base structure Regards, Mikhail Berman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Re: Incorrect information in file...

I have pretty much figured out what is going on. I forgot one pretty major item from my initial message. I had started mysql up without any my.cnf configuration file at first and was using it without prior to my using the my-huge.cnf config file. Please correct me if I'm wrong. That

help with insert +php

I'm trying to insert some data to my our web database, but when Insert the data, it inserts all the data from my form and ads two rows with no data. Can someone tell me what I'm doing wrong? Here is the code: ?php include 'config.php'; include 'opendb.php'; $sql=INSERT

RE: help with insert +php

I don't see the form. Unless one of your included files sets the values of your variables, this code will insert a row of empty strings every time it executes. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

Re: help with insert +php

Jerry Schwartz escribió: I don't see the form. Unless one of your included files sets the values of your variables, this code will insert a row of empty strings every time it executes. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

Which AMD Dual Core Processor?

I'm thinking of upgrading my AMD3500 to a dual core AMD processor. Is there any noticeable difference between these? AMD Athlon 64X2 3800+ Dual Core S939 Manchester (2x512K cache) AMD Athlon 64X2 4200+ Dual Core S939 Manchester (2x512k cache) AMD Athlon 64X2 4400+ Dual Core S939 Toledo (2x1MB

Re: help with insert +php

Marcelo, The usual advice is to echo out the query string and examine it for syntax. Assuming it has form data in it for the variables, then try copying/pasting it into the mysql client and run it from there. Let us know how that goes. David -- MySQL General Mailing List For list archives:

Re: help with insert +php

[EMAIL PROTECTED] escribió: Marcelo, The usual advice is to echo out the query string and examine it for syntax. Assuming it has form data in it for the variables, then try copying/pasting it into the mysql client and run it from there. Let us know how that goes. David Already done

Re: Which AMD Dual Core Processor?

mos wrote: AMD Athlon 64X2 3800+ Dual Core S939 Manchester (2x512K cache) AMD Athlon 64X2 4200+ Dual Core S939 Manchester (2x512k cache) AMD Athlon 64X2 4400+ Dual Core S939 Toledo (2x1MB cache) AMD Athlon 64X2 4600+ Dual Core S939 Manchester (2x512k cache) I would think, as a blind guess,

Re: help with insert +php

[EMAIL PROTECTED] escribió: Marcelo, The usual advice is to echo out the query string and examine it for syntax. Assuming it has form data in it for the variables, then try copying/pasting it into the mysql client and run it from there. Let us know how that goes. David Already done that

Re: help with insert +php

John Meyer escribió: Try this $retval = mysql_query($sql) or die(mysql_error()) To at least get an idea of what MySQL thinks is the error. The is no error in the insert it adds the row, but in addition add's two more rows with no data, only the auto_increment ; Example: Adds 1 Marcelo

Restore Questions

We're using MySQL 5.0.22 on CentOS 3.7 (running on VMWare). We use InnoDB tables and also use views, stored procedures, and functions. I had to move our development databases to a new server this week by doing a backup with mysqldump and then restoring the databases on the new server. I ran

Re: help with insert +php

Marcelo Fabiani wrote: Here is the code: . . . $result = mysql_query($sq)or die (problema Leyendo Tabla);; . . . Why are there two ; at the end of that line? I'm really not sure what if anything that will do but I would remove it just in case. Also are there any triggers on this

Re: help with insert +php

Chris W escribió: Marcelo Fabiani wrote: Here is the code: . . . $result = mysql_query($sq)or die (problema Leyendo Tabla);; . . . Why are there two ; at the end of that line? I'm really not sure what if anything that will do but I would remove it just in case. Also are there any

help please, help please

I am not able to install Mysql on my 2003 server at home. error 1045!! I get an accesd denied for user [EMAIL PROTECTED] my firewall is off and I know it is not the port becuase when I configure it as 'anonymous it works like a charm. Please help me

Re: Which AMD Dual Core Processor?

At 02:59 PM 9/1/2006, you wrote: mos wrote: AMD Athlon 64X2 3800+ Dual Core S939 Manchester (2x512K cache) AMD Athlon 64X2 4200+ Dual Core S939 Manchester (2x512k cache) AMD Athlon 64X2 4400+ Dual Core S939 Toledo (2x1MB cache) AMD Athlon 64X2 4600+ Dual Core S939 Manchester (2x512k cache) I

Re: help please, help please

I am not able to install Mysql on my 2003 server at home. error 1045!! I get an accesd denied for user [EMAIL PROTECTED] I need the full error, but have some questions: 1. Are you sure that you set a root password? 2. Are you using the command line client or some other administrative tool?

Re: help with insert +php

my friend... just put the correct variables : ... VALUES

Re: Which AMD Dual Core Processor?

mos wrote: I'm thinking of upgrading my AMD3500 to a dual core AMD processor. Is there any noticeable difference between these? AMD Athlon 64X2 3800+ Dual Core S939 Manchester (2x512K cache) AMD Athlon 64X2 4200+ Dual Core S939 Manchester (2x512k cache) AMD Athlon 64X2 4400+ Dual Core S939