Compiling for 64 Bit on OS X 10.4

Hi! Can anyone help me with a 64 Bit OS X 10.4 binary? I've tried to compile it myself but get errors in the "make" process that I have no idea what to do with. Apple ships a MySQL 4.1.10a binary with Tiger, but it's not 64 bit. MySQL doesn't have a 64 Bit OS X 10.4 binary yet. Maybe my question

Re: mysql.host: 3.23 to 4.0.2

Tim Johnson wrote: I am current working with mysql 3.23 on Red Hat 9.0 in the process of moving to slackware 10.0 on same machine, different partition. The version on the Slackwae partition is 4.0.2*. Question: Will I be able to simply mysqldump my mysql database on the RH 9.0 partion and then loa

mysql.host: 3.23 to 4.0.2

I am current working with mysql 3.23 on Red Hat 9.0 in the process of moving to slackware 10.0 on same machine, different partition. The version on the Slackwae partition is 4.0.2*. Question: Will I be able to simply mysqldump my mysql database on the RH 9.0 partion and then load the mysql DB on t

Re: Trouble's a'brewing ... database weas not shut down normally

At 11:48 +1000 5/3/05, Daniel Kasak wrote: Number of processes running now: 0 050502 20:31:26 mysqld restarted 050502 20:31:27 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 30

Trouble's a'brewing ... database weas not shut down normally

Number of processes running now: 0 050502 20:31:26 mysqld restarted 050502 20:31:27 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 301734057 InnoDB: Doing recovery: scanned up

MySQL Functions

Hello, Sorry for the slightly OT question :) Hoping we have some expert MySQL Function to perl function people on the list. Is there an equivelant function in perl for converting IP's, the same as MySQL functions: INET_ATON('IP_ADDRESS_STR') and INET_NTOA('STR') TIA, -- Mike(mickalo)Blezien =-=-=

Re: newbie: delete row xy

> I want to delete e.g row 1433 There is NO row "1433"! "1433" would depend upon which column(s) specified in ORDER BY clause. A table is a collection and a collection has NO inherent order. On 5/2/05, Christoph Lehmann <[EMAIL PROTECTED]> wrote: > Hi > I now how to use delete together with a

Re: Collation latin1_general_cs

At 17:01 -0400 5/2/05, Andre Matos wrote: Ok Paul. Do you have any idea why phpMyAdmin removed the "latin1_general_cs" from the collation pop-up list? No. I have the same problem like this one (except that I am using Mac OS X): http://forums.mysql.com/read.php?11,21462,21462 I looked at the release

Re: newbie: delete row xy

- Original Message - From: "Christoph Lehmann" <[EMAIL PROTECTED]> To: Sent: Monday, May 02, 2005 5:41 PM Subject: newbie: delete row xy > Hi > I now how to use delete together with a WHERE statement. But e.g. after > some warnings revealed me certain rows being inconsisent, and I want

Re: table that keeps info on tables in a DB

- Original Message - From: "V. Agarwal" <[EMAIL PROTECTED]> To: Sent: Monday, May 02, 2005 2:26 PM Subject: table that keeps info on tables in a DB > which sytem table is checked when 'show tables' > command is executed in MYSQL ? > If you want to get information about your tables and

Re: Collation latin1_general_cs

Ok Paul. Do you have any idea why phpMyAdmin removed the "latin1_general_cs" from the collation pop-up list? I have the same problem like this one (except that I am using Mac OS X): http://forums.mysql.com/read.php?11,21462,21462 I looked at the release notes for the version 2.6.2 (it was worki

Re: Collation latin1_general_cs

At 16:15 -0400 5/2/05, Andre Matos wrote: Hi Paul, It does appear in the list, but there is no "Yes" in the column "Compiled" and that's why my concern. I am using the Collation "latin1_general_cs" since I moved from version 3.x to 4.1.10. Is it really working without compiled? Yes. Some character

newbie: delete row xy

Hi I now how to use delete together with a WHERE statement. But e.g. after some warnings revealed me certain rows being inconsisent, and I want to delete them- how can I do this? I just know that I want to delete e.g row 1433 (I have no special id) thanks for a hint cheers christoph -- MySQL Ge

Re: Collation latin1_general_cs

Hi Paul, It does appear in the list, but there is no "Yes" in the column "Compiled" and that's why my concern. I am using the Collation "latin1_general_cs" since I moved from version 3.x to 4.1.10. Is it really working without compiled? Andre On 5/2/05 4:04 PM, "Paul DuBois" <[EMAIL PROTECTED]>

Re: Collation latin1_general_cs

At 15:28 -0400 5/2/05, Andre Matos wrote: Hi List, I was checking the list of collations for a character set "latin" that I have in my MySQL version 4.1.10-standard running on Mac OS X 10.4. Below is the that I have and does not include "latin1_general_cs". What will happen if I force to use it whe

Collation latin1_general_cs

Hi List, I was checking the list of collations for a character set "latin" that I have in my MySQL version 4.1.10-standard running on Mac OS X 10.4. Below is the that I have and does not include "latin1_general_cs". What will happen if I force to use it when I create a database, tables and fields

RE: Is anyone aware of

Thank you everyone for help. We have figure out differences in our scripts. They were NOT related to JOINs. Regards, Mikhail Berman -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Monday, May 02, 2005 2:12 PM To: Berman, Mikhail; mysql@lists.mysql.com Subject: R

Re: table that keeps info on tables in a DB

>which sytem table is checked when 'show tables' >command is executed in MYSQL ? Before 5.03 it's just an internal MySQL command. Since 5.03 it's a View defined in the information_schema virtual database. In neither case is it a physical table. PB - V. Agarwal wrote: which sytem table is che

Re: table that keeps info on tables in a DB

"V. Agarwal" <[EMAIL PROTECTED]> wrote on 05/02/2005 02:26:28 PM: > which sytem table is checked when 'show tables' > command is executed in MYSQL ? > > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http

Re: MyISAM error 127

[EMAIL PROTECTED] wrote: Hi, We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux for our data warehouse. I have a group of tables (9/2004 through 2/2005) that average about 95 million rows (215 byte rows). Using PERL and piping to mysql LOAD DATA is the way we've been loading.

table that keeps info on tables in a DB

which sytem table is checked when 'show tables' command is executed in MYSQL ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.

RE: Is anyone aware of

[snip] We are having some problems with movement of data from v3.23 to v.4.1. What was working in lower version does not working in higher. [/snip] Can you give an example of the query that you are running? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

MyISAM error 127

Hi, We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux for our data warehouse. I have a group of tables (9/2004 through 2/2005) that average about 95 million rows (215 byte rows). Using PERL and piping to mysql LOAD DATA is the way we've been loading. That all worked as ad

Re: Sum of a Count

- Original Message - From: "Eric Jensen" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Sent: Monday, May 02, 2005 11:19 AM Subject: Re: Sum of a Count > Rhino wrote: > > >I'm not entirely sure I know what you're asking when you say that you want > >to "group a field together with

RE: Is anyone aware of

We are having some problems with movement of data from v3.23 to v.4.1. What was working in lower version does not working in higher. Mikhail -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Monday, May 02, 2005 2:06 PM To: Berman, Mikhail; mysql@lists.mysql.com Subj

RE: Is anyone aware of

[snip] Is anyone aware of any differences on how joins work for: Ver 14.7 Distrib 4.1.10a, for sun-solaris2.9 (sparc) vs. Ver 11.13 Distrib 3.23.36, for sun-solaris2.7 (sparc) [/snip] Have you found an issue? JOINs should pretty much be the same. -- MySQL General Mailing List For list archives:

Is anyone aware of

Hi everyone, Is anyone aware of any differences on how joins work for: Ver 14.7 Distrib 4.1.10a, for sun-solaris2.9 (sparc) vs. Ver 11.13 Distrib 3.23.36, for sun-solaris2.7 (sparc) Regards, Mikhail Berman

Re: Determining if a table exists

The column name is Tables_in_mysql. show syntax doesn't support order by. Information_schema tables in 5.0 do because they use the normal select syntax. -Eric Jim McAtee wrote: Hey, thanks. show tables like 'jst%_foo' looks like it would work just fine. Two questions: What is the column name re

Re: Determining if a table exists

Hey, thanks. show tables like 'jst%_foo' looks like it would work just fine. Two questions: What is the column name returned and can I do an ORDER BY? If so, then I can just check the first and last rows in the results to determine the numeric range. My bad - server version is 3.23.x. Dictate

Re: Determining if a table exists

I don't remember what commands are available in 3.21 but try these show tables like 'table_name'; then check mysql_num_rows on the result. describe table; check mysql_num_rows show tables; then pick out the table name; 3.21 is old as alabama (forrest gump) it's time for an upgrade :) Jim McAtee wro

Determining if a table exists

We're running an application that creates table names in a numeric sequence. For example: jst998_foo jst998_bar jst999_foo jst999_bar jst0001000_foo jst0001000_bar jst0001001_foo jst0001001_bar I need to write a maintenance app that first needs to determine the numeric range of

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Mark Sargent wrote: h, that is annoying, as I did a yum remove mysql b4 installing 4.1. Shouldn't the yum remove, remove it fully..? Sorry, can't help there, don't know anything about 'yum'. [EMAIL PROTECTED] ~]# mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \

can't start mysqld

hi,all. i can't start mysqld anymore , it's log reports below: 050503 00:09:58 mysqld started mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This er

Re: Pessimistic Record Locking

Thanks for your help, that's going to work great! sk On 5/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Scott Klarenbach <[EMAIL PROTECTED]> wrote on 04/29/2005 05:39:36 > PM: > > > Thanks Shawn, that helps a lot. I like your general idea of handling > > it at application level. I

Re: mysql<->mysqld connection

> Where could I find speciffication of how MySQL client and server > communicate? /... Look at the source code of libmysql? So, document regarding this protocol doesn't exist? I didn't say that. I don't know of such a document, but I have never heard of it. However, since the protocol can chang

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Hassan Schroeder wrote: Mark Sargent wrote: [EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client What is this..? Why is it asking me to upgrade the client.? Cheers

Re: mysql<->mysqld connection

Dana Sun, 1 May 2005 11:11:40 -0700, Jeremiah Gowdy rece: > > Where could I find speciffication of how MySQL client and server > > communicate? /... > > Look at the source code of libmysql? So, document regarding this protocol doesn't exist? Hm, and, where could I find the source code of libmysql

Re: joining six tables by mutual column

Schalk Neethling wrote: Mathias/Everyone on the list I am running the following query against the database: SELECT demographic.demographic_no, demographic.first_name, demographic.last_name, demographic.chart_no, demographic.sex, demographic.year_of_birth, demographic.month_of_birth, demographic.

Re: NEED HELP IN IF STATEMENT

Shawn, Madderla, >Don't you need to DECLARE the variable "mvalidate" before you can use it? It's declared as OUT mvalidate varchar(10). PB - [EMAIL PROTECTED] wrote: madderla sreedhar <[EMAIL PROTECTED]> wrote on 05/02/2005 03:10:07 AM: Can u please execute the following

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Mark Sargent wrote: [EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client What is this..? Why is it asking me to upgrade the client.? Cheers. master/client are the

Re: joining six tables by mutual column

Schalk, Your query looks ok except for an apparently missing '%' in LIKE 'TES', but all the WHEREs are hard to read, aren't they? I find queries easier to write, read & maintain with joins in the JOIN clause and specific row-selection criteria in the WHERE clause, eg SELECT demographic.demogra

Re: NEED HELP IN IF STATEMENT

Madderla, 1. Var assignments need SET, ie SET mvariable = ... 2. Missing semicolon after 'TRUE' PB - madderla sreedhar wrote: Can u please execute the following procedure in MySql and tell me where I had gone wrong because on my system the same code is giving error near line " := 'TRUE' " CR

Re: NEED HELP IN IF STATEMENT

madderla sreedhar <[EMAIL PROTECTED]> wrote on 05/02/2005 03:10:07 AM: > Can u please execute the following procedure in MySql > and tell me where I had gone wrong because on my > system the same code is giving error near line > " := 'TRUE' " > > CREATE PROCEDURE cart_items_validate > (IN mcus

Re: mysqldump appears to generate invalid code.

"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote on 05/01/2005 07:14:57 PM: > I created a mysqldump with --quote-names option, but I get this > error:C:\xampp\xampp\mysql\bin>mysql -uroot db2 < test5. > txtERROR 1005 at line 54: Can't create table '.\db2\shift.frm' > (errno: 150)C:\xampp\xampp\mys

Re: Pessimistic Record Locking

Scott Klarenbach <[EMAIL PROTECTED]> wrote on 04/29/2005 05:39:36 PM: > Thanks Shawn, that helps a lot. I like your general idea of handling > it at application level. I guess my main concern w/ web apps and > locking the record (even at app level) is orphaned locks, resulting > from browser cl

Re: Is it the time to upgrade my server?

You should never just upgrade your system. Always find where the bottleneck is first. If it's RAM, then you just need to add more. If it's I/O, you need to add/change your disks. Those numbers don't seem that high for the hardware you have. You should try changing some configuration variables on

mysql_install_db for linux basedir query

Hi All, if this script is in scripts by default, why does it have the following code, test -z "$ldata" && ldata=./data if test -z "$basedir" then basedir=. bindir=./bin execdir=./bin pkgdatadir=./support-files else bindir="$basedir/bin" if test -x "$basedir/libexec/mysqld" then execdir=

Re: joining six tables by mutual column

Mathias/Everyone on the list I am running the following query against the database: SELECT demographic.demographic_no, demographic.first_name, demographic.last_name, demographic.chart_no, demographic.sex, demographic.year_of_birth, demographic.month_of_birth, demographic.date_of_birth, demograph

Re: purge log fails

Hello, http://dev.mysql.com/doc/mysql/en/crashing.html I decided to create a bug report as this list is rather for resolving common problems than discussing about the mysql development. Regards Marten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Mark Sargent wrote: Mark Sargent wrote: Simon Garner wrote: On 2/05/2005 5:21 p.m., Mark Sargent wrote: Hi All, I did this below, mysql>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka'); and then tried logging on, [EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka E

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Mark Sargent wrote: Simon Garner wrote: On 2/05/2005 6:05 p.m., Mark Sargent wrote: Hi All, master/client are the same machine. I installed via tar.gz, ver 4.1 following this page http://dev.mysql.com/doc/mysql/en/installing-binary.html for installation on FC3. Why would it say that the client do

Re: Synchronizing InnoDB tables

Marcin, - Original Message - From: "Marcin Lewandowski" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, May 01, 2005 7:25 PM Subject: Synchronizing InnoDB tables Hi, I want to use InnoDB tables in my project, because I can use transactions with them. I would write a

Re: Disappearing .frm files ?

Geoffrey, Chris, - Original Message - From: "Chris" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, May 01, 2005 5:26 AM Subject: Re: Disappearing .frm files ? Geoffrey R. Thompson wrote: ... Things have been fine until recently, when the .frm files for these tables

Att. Shawn Green

Shawn could you please contact me by e-mail? Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Simon Garner wrote: On 2/05/2005 6:05 p.m., Mark Sargent wrote: Hi All, master/client are the same machine. I installed via tar.gz, ver 4.1 following this page http://dev.mysql.com/doc/mysql/en/installing-binary.html for installation on FC3. Why would it say that the client doesn't support it.?

NEED HELP IN IF STATEMENT

Can u please execute the following procedure in MySql and tell me where I had gone wrong because on my system the same code is giving error near line " := 'TRUE' " CREATE PROCEDURE cart_items_validate (IN mcustid INT ,IN mprodid varchar(10), OUT mvalidate varchar(10)) BEGIN DECLARE rowexists

mysqldump feature request

Hi: I am using mysql 4.1.10 for a while now, and i was wondering how painful it would be to tweak the mysqldump to support an additional option, --insert-ignore , which instructs it to create the dump files with INSERT IGNORE blah blah instead of just INSERT blah blah i have actually modified