Re: Specifics on using join & multiple tables

Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2003-06-04 09:17:01 -0400: I need all data in sales1 and sales2, but only for records from acc that are in either/both sales1, sales2. SELECT acc.name, acc.phone, acc.acctno, sales1.amt AS mo1sales, sales2.amt AS mo2sales,

Re: MySQL Secure connections

Gareth, Thanks It looks as though my build is not picking up the OpenSSL stuff so HAVE_OPENSSL is not getting defined :-( can't see why at the moment though as OpenSSL is installed in "--with-openssl=/usr/sfw" Paul Gareth Davis wrote: > > I've just done a similar thing. Are you sure that you

nested ORDER BY statements

Hello - I'm a relative newcomer to development with MySQL and am having a problem with ordering my query results... I first want to select the 50 most recently created records (with respect to my date field) and then order these with respect to another field (eg name). That way I'm always "orde

Re: Row Number

Anthony, Here's the full definition of select statement: SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] [HIGH_PRIORITY] [DISTINCT | DISTINCTROW | ALL] select_expression,... [INTO {OUTFILE |

out f memory error

I have a program that runs a loop,in every loop I execute a query. the query itself is very efficient, the result of the query is 4 rows at most but... after a while I get the following error: Out of memory! Bus error (core dumped) how can I increase the memory that is used for the query? Thanks

Re: Specifics on using join & multiple tables

# [EMAIL PROTECTED] / 2003-06-04 09:17:01 -0400: > acc.name, acc.phone, acc.acctno, sales1.amt as mo1sales, sales2.amt as > mo2sales, (sales1.amt - sales2.amt) as diff SORT by diff > > I need all data in sales1 and sales2, but only for records from acc that > are in either/both sales1, sales2. >

URGENT: Problems compiling mysql 3 and 4 on IRIX indy 6.5 IP22 mips

hi, I'm having a hard time getting mysql 4 and mysql 3 to compile on IRIX 6.5... Does anyone have a solution to this? Below is an example of compiling mysql 4.0.13 (looks practically identical for mysql 3.23.56): g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I

Specifics on using join & multiple tables

I am fairly new to MySQL and SQL in general. I have three tables, acc,sales1,sales2. All have acctno in common. acc is general customer table with lots of information. sales1 is a generated table of sales for specific customer from a given month/year. sales2 is the sale as sales1 except for

Re: mysql query output get wrapped

On 03-Jun-2003 Asif Iqbal wrote: > > something like this > > ++-+---++++--- > +---+-+ >| id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner >| Subject | InitialPriority | > ++--

Re: debuggine 1205 / LOCK wait timeout exceeded errors

# [EMAIL PROTECTED] / 2003-06-03 22:59:47 +0300: > you can use SHOW INNODB STATUS to look what active transactions you have and > how many lock structs they have. > > Also innodb_lock_monitor helps. Hi Heikki, thanks for the reply. I have dropped the database, recreated it, stopped t

Re: malloc'ing 2GB+ of memory in mysql

Owen, - Original Message - From: "Owen Scott Medd" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 3:13 PM Subject: Re: malloc'ing 2GB+ of memory in mysql > I know we are facing this same question right now (I have 8 way

Re: malloc'ing 2GB+ of memory in mysql

I know we are facing this same question right now (I have 8 way servers with 16GB of memory running MySQL, with 5 GB sitting unused while the poor innodb buffer pool sits starved for memory). Do we replace these servers with 4 way Opterons (are there 8 ways promised yet?) or is there another a

Re: malloc'ing 2GB+ of memory in mysql

Hello Heikki, "Heikki Tuuri" <[EMAIL PROTECTED]> writes: > I remember someone also reporting a problem that glibc or Linux does not > allow creation of new threads if one has allocated >= 2 GB user memory. I > think there are problems in where the OS places the excutable, thread > stacks, etc.

Re: Can't open privilege tables: Table 'mysql.host' doesn't exist

Nils, - Original Message - From: ""Nils Valentin"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, June 04, 2003 7:05 AM Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist > Sorry, I should have given more details.=20 > Its Mysql 4.1 alpha

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

Daniel Kasak wrote: Neil Zanella wrote: SQL92, AFAIK, specifies that if the primary key is not explicitly set to NOT NULL then the RDBMS should automatically and silently assume the user means NOT NULL. Sounds like the end of the world to me ;) I suppose you have to get excited about something..

Re: complex Subquery

surabhi sinha wrote: Ihave the following subquery which i intend to use for mysql4.0.12 can u tell me how it could be formed for use since no common column is there for it to be converted to Inner join What about Companyid? Select CompanyName,City from Company where CompanyName='Arihant Jain' an

Re: malloc'ing 2GB+ of memory in mysql

Per, I remember someone also reporting a problem that glibc or Linux does not allow creation of new threads if one has allocated >= 2 GB user memory. I think there are problems in where the OS places the excutable, thread stacks, etc. So it is uncharted territory. Oracle seems to have an option t

Re: Mysql

"Camillo Rospigliosi" <[EMAIL PROTECTED]> wrote: > I've intalled the mysql 3.23.56-nt > when I try to do the commands of the tutorial > "C:\mysql\Docs\manual.html#Tutorial": > mysql> load data local infile "pet.txt" into table pet; > ERROR 1148: The used command is not allowed with this MySQL versi

Re: Replication of table conversions?

"Bialac, Dave" <[EMAIL PROTECTED]> wrote: > I currently have two databases set up with a master/slave replication > environment. Right now, the tables are MyISAM, however I want to > migrate to InnoDB so I can gain transactioins. I've worked through the > processes and nearly everything seems str

Re: Mysqld problem

"Grzegorz Golofit" <[EMAIL PROTECTED]> wrote: > I have problem with running mysqld > I installed the following rpm packages incladed with RedHat 7.1 (Seawolf) edition > cd`s which I am running on my machine: > -mysql-3.23.36-1 > - mysql-server-3.23.36.1 > - mysql-devel-3.23.36-1 > First I tried to

Re: [Fwd: More than 255 chars in column in heap table]

Frank de Bot <[EMAIL PROTECTED]> wrote: > I want to make a HEAP table which must contain somewhat large text (at > least larger than 255 chars), but I need to store a little more data. Is > it somehow possible to have a column in a heap table which can contain > more than 255 bytes? (I'm thinkin

Re: max()

Jozef Kutej <[EMAIL PROTECTED]> wrote: > mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) > > Is this behavior OK? > > mysql> select Sort FROM Bookmark where (UID='2' AND Up='0'); > +--+ > | Sort | > +--+ > |1 | > |1 | > |2 | > |3 | > |4 | > |5 | > |6 | > |

RE: mysqld CPU usage is almost 100% !!!

check either your using ODBC - trace is on ? -Original Message- From: nino [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 11:05 AM To: milis mysql Subject: mysqld CPU usage is almost 100% !!! Hi folks, I'm experiencing some phenomenon that mysqld is consuming CPU at almost 100%

Mysql

I've intalled the mysql 3.23.56-nt when I try to do the commands of the tutorial "C:\mysql\Docs\manual.html#Tutorial": mysql> load data local infile "pet.txt" into table pet; ERROR 1148: The used command is not allowed with this MySQL version What can I do? what command is allowed with this MySQL

malloc'ing 2GB+ of memory in mysql

Hi The Mysql binary distribution for IA32-linux is statically linked with glibc. glibc malloc limits memory allocations to 2GB, which means that a buffer in mysql can't grow beyond 2GB. This is due to some paranoia in glibc malloc - they don't rely on the size to be an unsigned int - which limits

Re: Mysqld problem

Gregory, > mysql started > /usr/libexec/mysqld: Can`t find file ' ./mysql/host.frm' (errno: 13) > mysqld ended You forgot to run the mysql_install_db script that sets up the initial grant tables: http://www.mysql.com/doc/en/Post-installation.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]>

Re: NEWBIE QUESTION: Copying Databases from local to server

Tim, > I have several databases currently located on my local machine that I need > to copy to a remote server. You can dump the contents of your databases with mysqldump, and load those contents on your other server, using the mysql client program or another tool like phpMyAdmin. You can even co

Re(2): database copy

Fabio, I've just looked at MySQL CC properly for the first time and it doesn't seem to have any import/export options. I use MySQL-Front, which does. You can get the latest release from http://mysqlfront.venturemedia.de/ . Best wishes, Paul Najman [EMAIL PROTECTED] - Original Message -

Re: efficient query or not?

Hi, You mention this SELECT loc1.name, loc1.lat, loc1.lon, loc2.name, loc2.lat, loc2.lon, 3963 * acos(cos(radians(90-loc1.lat)) * cos(radians(90-loc2.lat)) + sin(radians(90-loc1.lat)) * sin(radians(90-loc2.lat)) * cos(radians(loc1.lon-loc2.lon))) AS Miles FROM locations AS loc1 INNER

Re: MySQL Mirroring.

On Wed, 2003-06-04 at 00:23, [EMAIL PROTECTED] wrote: > Hi, > > Please excuse me if this question has been discussed before. > > Is there a way to securely setup 2 MySQL Servers to be in sync with each > other? > > Let's say that I have server A at home and Server B at my work and I > want serve

mysqld CPU usage is almost 100% !!!

Hi folks, I'm experiencing some phenomenon that mysqld is consuming CPU at almost 100%. At this time, I only assemble a few database with record size is about 37000 rows. Is mysqld likely gonna crash or something ?? I also noticed that, if some other mysqld thread is active, the mysqld which co

RE: Mysqld problem

Try this in mysql/bin/perror Tells you what the error code means. <---snip---> > ./perror 13 Error code 13: Permission denied <---snip---> Simon -Original Message- From: Grzegorz Golofit [mailto:[EMAIL PROTECTED] Sent: 04 June 2003 08:36 To: [EMAIL PROTECTED] Subject: Mysqld problem

replication problem

Hi, i'm trying to replicate two mysql databases (master,slave) but my problem is that the slave don't recognized well my settings because in the err file he shows me: Could not find target log during relay log initialization Note: Failed to initialized master info The master.info exists in the s

Mysqld problem

I have problem with running mysqld I installed the following rpm packages incladed with RedHat 7.1 (Seawolf) edition cd`s which I am running on my machine: -mysql-3.23.36-1 - mysql-server-3.23.36.1 - mysql-devel-3.23.36-1 First I tried to initialize as a root tables with following command: mysql_i

RE: table copying/replication

On Tue, 2003-06-03 at 22:44, Ross Simpson wrote: > Thanks for the reply. > > I didn't explain properly :) > > A diagram should help: > >|| > |-| 1 || 2 | || > |stage| --> |prod| --> |-| || > |-| || |-|replicas| >

authentification intranet

excuse me i send my last e mail in french so i reexplain i have a mandrake 9.1 apache2 mysql 4.1 and phpmyadmin 4.0.1 my problem is : when i give my login and my password in intranet interface, i receive "password not exact" but password is good in database in mysql i use cheklogin.php and secure.

max()

mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) Is this behavior OK? mysql> select Sort FROM Bookmark where (UID='2' AND Up='0'); +--+ | Sort | +--+ |1 | |1 | |2 | |3 | |4 | |5 | |6 | |8 | |9 | | 10 | | 11 | | 12 | | 13 | +--+ 13 rows i

authentification intranet

bonjour a tous, je viens juste de m'inscrire a votre liste. meme si je ne suis que stagiaire et mon experience pas tres longue j'espere tout de meme pouvoir vous aider mon projet de stage est de mettre en place un intranet mon systeme est compose d'un serveru apache2 dun serveur mysql4.1 de phpmy

RE: Displaying numbers with results - any ideas?

On 02-Jun-2003 Jay Blanchard wrote: > [snip] > Its just a query. And theyre being displayed on a webpage. > > [/snip] > > This just caught my eye ... "And theyre being displayed on a webpage." > > SO, there is another language afoot here, right? You have to have > something to retrieve to the

Can't create a new thread (errno 11)

Hi, When we have too many connections opened at the same time (either because they were left opened or because there are to many active connections opened), I am getting this error message when I am trying to connect to mysql: "Can't create a new thread (errno 11). If you are not out of available

Re: C API

>>#include >>#include >>#include "winsock.h" >>#include >>#include >>#include >>#include >> >>int main(void) { >>MYSQL* toto; >> >>toto = mysql_init(toto); >>} >> >> >>/* this is the compler log */ >> >>Compiler: Default compiler >>Executing gcc.exe... >>gcc.exe "U:\mep\Dev\abr.c" -o

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

There are versions of the SQL3 document available at http://www.inf.fu-berlin.de/lehre/SS94/einfdb/SQL3/sqlindex.html and http://dbs.uni-leipzig.de/en/lokal/standards.pdf, free of charge. PB - - Original Message - From: Neil Zanella To: MySQL Mailing List Sent: Wednesday, June

Re: NEWBIE QUESTION: Copying Databases from local to server

Try to use FTP to upload them. -- >Hello, > >I have several databases currently located on my local machine that I need >to copy to a remote server. > >Con someone explain the process and details of how this is done? > >Thanks, > >Tim Winters >Manager, Creative Deve

Re: complex Subquery

surabhi sinha wrote: Dear sir, Ihave the following subquery which i intend to use for mysql4.0.12 can u tell me how it could be formed for use since no common column is there for it to be converted to Inner join Select CompanyName,City from Company where CompanyName='Arihant Jain' and City='Delh

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

Neil Zanella wrote: Hello, I believe that MySQL is in error in reporting the following message just because I did not specify that the PRIMARY KEY should not be NULL. These days there are standards and SQL92, AFAIK, specifies that if the primary key is not explicitly set to NOT NULL then the RDBM

NEWBIE QUESTION: Copying Databases from local to server

Hello, I have several databases currently located on my local machine that I need to copy to a remote server. Con someone explain the process and details of how this is done? Thanks, Tim Winters Manager, Creative Development Sampling Technologies Incorporated (STI) [EMAIL PROTECTED] [EMAIL PROT

complex Subquery

Dear sir, Ihave the following subquery which i intend to use for mysql4.0.12 can u tell me how it could be formed for use since no common column is there for it to be converted to Inner join Select CompanyName,City from Company where CompanyName='Arihant Jain' and City='Delhi' and companyid in

MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

Hello, I believe that MySQL is in error in reporting the following message just because I did not specify that the PRIMARY KEY should not be NULL. These days there are standards and SQL92, AFAIK, specifies that if the primary key is not explicitly set to NOT NULL then the RDBMS should automatical

Re: mysql query output get wrapped

> Did not work I wonder ... > prompt > echo "select * from Tickets limit 1;" | mysql mydb > res > prompt > cat res > > id EffectiveId Queue TypeIssueStatement Resolution > Owner Subject InitialPriority FinalPriority PriorityStatus > TimeWorked TimeLeftTol

Re: Can't open privilege tables: Table 'mysql.host' doesn't exist

Sorry, I should have given more details. Its Mysql 4.1 alpha on a Suse Linux system Version 8.1. ...and yes, the mysql.host table and the other 5 exist and are well alive ;-). If I replace my.cnf with a version skipping innodb then it perfectly starts up, so it must be related to innodb, perhap

Can't open privilege tables: Table 'mysql.host' doesn't exist

Hi Mysql list members, I added a Innodb database to the existing MyISAM databases and now MySQL doesnt start up. From the InnoDB logfile I saw this error message Can't open privilege tables: Table 'mysql.host' doesn't exist Does any body know what this error comes from ? innodb logfile extra

Redhat 8 thread problem...

From what I can tell the server seems to be working acceptably. But when comparing it to another installation I have on Redhat 7.3, I notice that when MySQL starts on the Redhat 8 system it is only launching one /usr/sbin/mysqld process... and not the additional 2 (which I already understand ar

Re: Find out what version I am using?

At 10:10 +0900 6/4/03, Nils Valentin wrote: Hi Paul, did I get something wrong or did you actually mean "mysql SELECT VERSION(); " instead of " mysql> SHOW VERSION();" ??? You're right, I'm wrong. SELECT VERSION(); (In case I am right, I didnt post as I thought is not so polite to "overwrite"

Re: Regarding inoperable symbolic links in Win2K Pro

Hi Charles, Having spoken to "somebody" from MySQL AB in person last month here in Tokyo I know that the problem seems to be adressed currently. What I dont know is when, how and which new mechanism will be applied to the mailing list. Best regards Nils Valentin Tokyo/Japan 2003年 6月 4日 水曜日 1

Regarding inoperable symbolic links in Win2K Pro

Hi, I recently posted an email about 'Inoperable Symbolic Links in Win2K Pro ' and I subsequently subscribed to the belief that MySQL would fail when installed in a location that was different that the default location. I tried a myriad of things to get the database system to function correctly.

[Fwd: More than 255 chars in column in heap table]

Hi, I want to make a HEAP table which must contain somewhat large text (at least larger than 255 chars), but I need to store a little more data. Is it somehow possible to have a column in a heap table which can contain more than 255 bytes? (I'm thinking of not pretty much more like 1024 chars)

Re: MySQL Mirroring.

My Message was in English. Thank you for your help. On Wed, 4 Jun 2003 00:33:10 +0100 , Andrew Braithwaite <[EMAIL PROTECTED]> wrote: >Assuming that you speak english - you can do the following... > >http://www.mysql.com/doc/en/Replication.html > >Cheers, > >Andrew > >-Original Message-

RE: MySQL Mirroring.

Assuming that you speak english - you can do the following... http://www.mysql.com/doc/en/Replication.html Cheers, Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday 04 June 2003 00:24 To: [EMAIL PROTECTED] Subject: MySQL Mirroring. Hi, Pleas

Limiting Characters

I would like to limit the amount of characters that appear on a PHP page, using PHP. Here is the code that I am using: $title\n"; echo "$author\n"; echo $article_contents['LimitChars']; ?> This code works, however it limits the characters to one (1) character. I would like to

MySQL Mirroring.

Hi, Please excuse me if this question has been discussed before. Is there a way to securely setup 2 MySQL Servers to be in sync with each other? Let's say that I have server A at home and Server B at my work and I want server be to mirror exactly what I do on Server A. Can this be done? Is ther

RE: table copying/replication

OK - in that case there's not much you can do with replication... But with mysql you could write some bash to copy the raw files over like: Run this from /datadir (on the server you want to copy from): tar cf - databasedirname | ssh server_you_want_it_to_go_to 'cd /datadir; tar xf -' And supply

Re: cant grant privileges?!

Hi Allann, Ajos, Mysql List members As far as I know the flush privileges is not necessary when using GRANT. flush privileges is only used after you updated the privilege database "mysql" manually using INSERT or UPDATE. Somebody please correct me if I am wrong. Best regards Nils Valentin Tok

RE: table copying/replication

I looked at that type of idea, and the reason I didn't mention it was the indexes -- each table involved has ~5 indexes, and on a large table, that equals a lot of work that's already done on 'stage' that must be redone on 'prod'. I'd really like to preserve the indexes from stage if at all possib

Re: MySQL Secure connections

I've just done a similar thing. Are you sure that you are running the mysql client that you have just compiled. I used the following build options CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions \ -fno-rtti" ./configure \ --enable-assembler \ --enable-lo

RE: table copying/replication

Hi, Assuming that this system runs on *nix and that "prod" is set up to replicate to all the "replicas" you could write a small bash script to push the data from the "stage" to the "prod" which would then replicate as normal. I would author the script something like this... [bash]# mysqldump -e

Re: help creating foreign keys

yes, quite right. thanks for pointing that out. jeff Kevin Fries wrote: > > In InnoDB you *must* put an index on foreign keys. It doesn't do this > for you automatically. > > You can do it in one statement: > > create table bar ( >bar_idint unsigned auto_increment, >foo_idint

RE: table copying/replication

Thanks for the reply. I didn't explain properly :) A diagram should help: || |-| 1 || 2 | || |stage| --> |prod| --> |-| || |-| || |-|replicas| || 'stage' is a staging mysql instance,

RE: Mysql / PHP image link problem.

'; ?> Peter -Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 20:57 To: [EMAIL PROTECTED] Subject: Re: Mysql / PHP image link problem. FWIW, there is a PHP-DB mailing list that might prove more helpful to you. I know certain folk on both lists can g

Re: optimize entire db

Mark, > Can anyone give the command line syntax for optimizing the entire db? > thanks in advance. mysqlcheck [OPTIONS] --databases DB1 [DB2 DB3...] This program can be used to CHECK (-c,-m,-C), REPAIR (-r), ANALYZE (-a) or OPTIMIZE (-o) tables. Some of the options (like -e or -q) can be used at

Re: optimize entire db

I've used a simply shell script in the past.. run from cron to do it... I just see someone posted a perl solution.. I've used a php one aswell.. #!/bin/sh # DB OPTIMIZE SCRIPT - !! WARNING, DOES TABLE LOCKING DURING OPTIMIZES user=root pass=secret host=10.1.1.1 db=mydb [EMAIL PROTECTED] mysql="/

Re: Red Hat linux database to Mac OS X

You shouldn't have any problems if you are using mysqldump. I've used it plenty of times on OSX. On Tuesday, June 3, 2003, at 02:19 PM, Greg Grasmehr wrote: Hello, I was wondering if anyone has experienced moving a MySQL database from Linux/Intel X86 to Mac OS X? I plan to use mysqldump of cour

Re: Re[4]: MySql data between Linux and Windows

And you are completely wrigth. There is no MySql problem. I solved the problem but I did not gave you all the necessary information. In the middle of all the problem there is also a php application, apache and the OS so I was confused. The problem was with php. In php.ini there is the following con

RE: optimize entire db

You can use this script that I wrote. Also you can change OPTIMIZE TABLE with ANAYLIZE TABLE #!/usr/bin/perl -w # If you use this give me CREDIT!! :) Dathan Vance Pattishall # use strict; use DBI; use lib '/site/lib'; my $USER = ""; my $PASSWD = ""; my ($host,$DB,$TABLE) = @ARGV; die "must speci

strange SSH/libmysql.dll problem - this time with dbug infos

I think I need a MySQL code guru... I am using the 4.0.12 client library on a Win2k host to connect to a 4.0.13 linux server. If I connect directly to the server using mysql_real_connect, everything runs fine. However, I want to use SSH tunneling. So I set up a SSHv2 tunneling connection from l

Re: Mysql / PHP image link problem.

FWIW, there is a PHP-DB mailing list that might prove more helpful to you. I know certain folk on both lists can get mighty annoyed when an off-topic question is posted, so I thought I'd give you a heads-up. [EMAIL PROTECTED] Edward Dudlik Becoming Digital www.becomingdigital.com - Original

Re: debuggine 1205 / LOCK wait timeout exceeded errors

Roman, you can use SHOW INNODB STATUS to look what active transactions you have and how many lock structs they have. Also innodb_lock_monitor helps. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical sup

MySQL Secure connections

Hi, Please can someone help with advise on setting up a Secure MySQL Connection. The details are as follows. I have built and configured OpenSSL 0.9.7 and MySQL 4.0.12. MySQL was configured with the options ./configure \ --enable-local-infile \ --with

MySQL stops working, process cannot be killed

I have been having a problem with MySQL lately. Specs are: RedHat Linux 7.3 MySQL 3.23.56, for pc-linux (i686) (same behavior with 4.0.12 as well) Apache 1.3.27 PHP 4.3.2 (most (99%) of the MySQL connections are made through PHP scripts running as an apache module) The problem happens as such:

optimize entire db

Hi - Can anyone give the command line syntax for optimizing the entire db? thanks in advance. MS

Re: Problem with priv_db

Hello, Egor Egorov wrote: I even flushed the privileges and restarted the MySQL server. Any idea? Please, show me the structure of table 'user'. I found it. Create_tmp_table_priv was Y. thanks anyway, elian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

RE: Mysql / PHP image link problem.

You'll have to check if the result is NULL or not. Try this " : ""; ?> This is print out nothing if your result is equal to null. On another notes, how do you specify the width and height of this image? Or the alt tag, or set the border so that on older versions on Netscape it does not defau

Re[4]: MySql data between Linux and Windows

Carlos, > Character set > In windows 2000 latin1 > In Linux hosting latin1 > Character sets > In windows 2000 > latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru > latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr > greek wi

Re: Mysql / PHP image link problem.

keep the lines at or under 72 characters, please. # [EMAIL PROTECTED] / 2003-06-03 19:20:17 +0100: > To display in my web page im using: > > > > This displays the above images in my html page > > The problem i have is where the field in my table is left blank > (null), a web browser shows

RE: help creating foreign keys

In InnoDB you *must* put an index on foreign keys. It doesn't do this for you automatically. You can do it in one statement: create table bar ( bar_idint unsigned auto_increment, foo_idint unsigned, bar_value int, constraint bar_pk primary key (bar_id), index (foo_id),

Re: Mysql / PHP image link problem.

At 19:20 +0100 6/3/03, Daniel Crompton wrote: I have a mysql table column called 'imagecolumn' The rows contain links i.e. image.gif image.gif null image.gif image.gif To display in my web page im using: This displays the above images in my html page The problem i have is where the field in m

Re: Red Hat linux database to Mac OS X

Hello, I was wondering if anyone has experienced moving a MySQL database from Linux/Intel X86 to Mac OS X? I plan to use mysqldump of course. I was only wondering if anyone has run into problems they might share. You can't use BDB tables. Thanks. Greg -- Paul DuBois http://www.kitebird.com/ s

RE: Red Hat linux database to Mac OS X

Not that particular move, but have used mysqldump/mysql combo to move between linux-->windows and back. Works well. -Original Message- From: Greg Grasmehr [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 1:19 PM To: [EMAIL PROTECTED] Subject: Red Hat linux database to Mac OS X He

RE: full text searching question

Chris, I should have added that the explanation is that the full text query does not automatically sort on the score when boolean mode is selected. Andy > -Original Message- > From: Chris Wilkinson [mailto:[EMAIL PROTECTED] > Sent: 03 June 2003 13:12 > To: [EMAIL PROTECTED] > Subject: fu

RE: full text searching question

Chris, You're nearly there - the way to do it is: SELECT first_name,last_name,MATCH(first_name,last_name) AGAINST ('+wilkinson* chris*' IN BOOLEAN MODE) AS score FROM names_table WHERE MATCH(first_name,last_name) AGAINST ('+wilkinson* chris*' IN BOOLEAN MODE) ORDER BY score DESC; The db engine w

Re: full text searching question

At 13:11 +0100 6/3/03, Chris Wilkinson wrote: can anybody explain this to me please! I search am searching through a database with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in case that matters. I created a fulltext search on both fields together so I can search the

Mysql / PHP image link problem.

I have a mysql table column called 'imagecolumn' The rows contain links i.e. image.gif image.gif null image.gif image.gif To display in my web page im using: This displays the above images in my html page The problem i have is where the field in my table is left blank (null), a web browser

Red Hat linux database to Mac OS X

Hello, I was wondering if anyone has experienced moving a MySQL database from Linux/Intel X86 to Mac OS X? I plan to use mysqldump of course. I was only wondering if anyone has run into problems they might share. Thanks. Greg __ Do you Yahoo!? Yahoo! Calendar -

Re: full text searching question

User ORDER BY First Name Chris Wilkinson wrote: can anybody explain this to me please! I search am searching through a database with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in case that matters. I created a fulltext search on both fields together so I can search t

RE: database copy

If you check the documentation about mysqldump, you'll find the command line syntax for using a combination of mysqldump on the source machine and mysql pumping to the target machine. It's simple, fast and everything is there to work just fine. -Original Message- From: Paul Najman [mailt

Re: database copy

Hello I use SQLyog at http://www.webyog.com/sqlyog. It has a great facility to do exactly what you want. Just connect to two differt servers and choose DB->Copy Database To Another Host/DB option...and wholla you are done. Karam --- Paul Najman <[EMAIL PROTECTED]> wrote: > Fabio, > > I have had

full text searching question

can anybody explain this to me please! I search am searching through a database with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in case that matters. I created a fulltext search on both fields together so I can search them like this: mysql> SELECT first_name,last_name

RE: mysql query output get wrapped

Since this in running in Windows, I don't think you will have much luck in a simple console display. While you can change size properties for Window and Screen Buffer, these sizes are ONLY for length and you can't really do much for horizontal size. What I'd suggest tying is to run mysql as a co

RE: table copying/replication

-->-Original Message- -->From: Ross Simpson [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, June 03, 2003 10:31 AM -->To: [EMAIL PROTECTED] -->Subject: table copying/replication --> -->Hello, --> -->I have a need for fast copying of a specific table from a master mysql -->server to a number o

Making MySQL 5.0 Source Tree

Hello, I gave the follow commands to make the binary form in cygwin: autoconf configure.in ./configure and the messages were: loading cache ... bla bla bla checking build system type... i686-pc-cygwin configure: 724: Syntax error: word unexpected (expecting ")") Maybe the cause is the linefeeds

Re: mysql query output get wrapped

Are you using the -S switch to less? Note that it's a capital S, not lower case. Does the output get properly sent through the less pager (i.e do you have to page through the results that get selected)? Check the manpage for less on your machine and find out what the truncate lines option is,

  1   2   >