We need to set up some primitives in php for mysql, then repeat for
postgresql, so that we bury most of the differences in the primitives.
Sorry about the noise. Joe Conway on the postgresql list pointed me
towards the database abstraction layers in pear, and I see lots of good
stuff there.
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 19 Mar 2003, Natalino Picone wrote:
can anyone tell me why the mysql-max 4.0.12 is not statically linked
against Glibc 2.2 ? (the standard one is ok)...
This is done intentionally, to enable the use of User Defined Functions
(UDFs) - you
Hi,
Since shm (shared memory) in Unix/Linux is only used to share memory
between independent processes and mysql server is a single process
(multi-threaded), I am convinced that shmmax value has no consequence
on mysql. (OTOH Oracle has a multiprocess architecture and uses
shared memory).
Hope
I'm trying to compile MySQL 4.1 on Mac OS 10.2.4 (Darwin Kernel Version
6.4) but run into some problems.
When following the general compilation guidelines...
cd mysql-4.0
bk -r get -Sq
aclocal; autoheader; autoconf; automake
(cd innobase ; aclocal; autoheader; autoconf; automake)
(cd bdb/dist ;
Hi Joseph,
thank you for your answer. While i was reading
about clustering some weeks ago i read the openmosix
FAQ claiming that openmosix would not work with apache,
because apache was using shared memory to communicate
with its threads, and i always thought mysql is designed
the same way.
Can someone tell me how do I find the default settings in MySQL. Mainly
I'm interested in knowing where are the data files stored. I'm building
a application server (RH7.3) and need to know which partition should be
sized to handle the database.
--
Jon Miller [EMAIL PROTECTED]
MMT Networks Pty
Dear Friends
I am new in this list
I am using mysql on linux
My problem is about the backup of mysql database
We are having 50 Databases and each database is of
minimum of 300 MB in size and maximum of 2 G.B size
I am planning to take incremental backup of the
database
For that i am planning
/etc/my.cnf: Global options
DATADIR/my.cnf: Server-specific options
defaults-extra-file: The file specified with --defaults-extra-file=#
~/.my.cnf: User-specific options
By default, data is in /var/lib/mysql.
Jon Miller wrote:
Can someone tell me how do I find the default settings in MySQL.
Dear Friends
I am new in this list
I am using mysql on linux
My problem is about the backup of mysql database
We are having 50 Databases and each database is of
minimum of 300 MB in size and maximum of 2 G.B size
I am planning to take incremental backup of the
database
For that i am planning
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
After experimenting with the input from Benjamin I can GRANT all I want,
but still only on a single database (though if I know the name I can do
so in advance of its creation). This still seems a little troublesome.
I expect that it's in
I reread the mysql manual again, and found the little piece I've missed : version 4!!
That's the problem.
Thanks for your reply.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
HI,
I create temporary tables using the query
CREATE TEMPORARY TABLE ..
How do i list all the temporary tables in the database
SHOW TABLES STATUS does not show the temporary tables.
Thanks
Anis
-
Before posting,
Mysql
(
)
CD-ROM
( ).
,
( 115 ) CD-
ROM. .
,
,
,, ,
,
.
17
( ,
-, , ,
, ,
Test
--
Karthikeyan Balasubramanian
[EMAIL PROTECTED]
--
http://www.fastmail.fm - Access your email from home and the web
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Tuesday 18 March 2003 22:34, Salada Duncan wrote:
Is it possible? Can it really be true? I check the website daily and
watch the lists eagerly. As I looked at the website just now, I saw it...
Database Server
Production: 4.0.12
Did I miss the announcement?
Yup ;)
Dear all,
how can I remove a foreign key in InnoDB?
ALTER TABLE DROP (FOREIGN) KEY `key`
isn't working (and also not specified in documentation)... : (
Thanks and best regards
Thorsten
(For bypassing the Filter: Here is sql,query,queries,smallint)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
...and then Roger Davis said...
%
% Maybe the [EMAIL PROTECTED] address should be changed to
% [EMAIL PROTECTED] so people can't pull the Username off the e-mail
% address and bypass the filter.
1) There were some changes to the
Hi,
I m using the following query
SELECT id,
subject,
news,
date_format(date, '%m/%d/%Y %h:%i %p') AS date,
author,
link
FROM news
ORDER BY id DESC LIMIT 5
heres my table structure
CREATE TABLE news (
Dear all,
how can I remove a foreign key in InnoDB?
ALTER TABLE DROP (FOREIGN) KEY `key`
isn't working (and also not specified in documentation)... : (
It's not implemented yet. You can copy your data to another table without
the foreign key constraint, drop original one and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 18 Mar 2003, Andrew Braithwaite wrote:
Anyone know why mysqladmin processlist is not showing the host that is
connected, but instead is showing the following in v4.0.12:
truncated excerpt
How do you know these possibly duplicate records are not already in the
table?
What is wrong with adding a unique index on (fld2,fld3) ?
Hu Qinan wrote:
Dear all,
I intend to write a large volume of records to a table tbl.
tbl:
fld1, int unsigned not null auto_increment primary key,
fld2,
At 5:39 -0800 3/19/03, Karthikeyan Balasubramanian wrote:
Hi,
I m using the following query
SELECT id,
subject,
news,
date_format(date, '%m/%d/%Y %h:%i %p') AS date,
author,
link
FROM news
ORDER BY id DESC LIMIT 5
heres my table structure
CREATE
a href=http://since.vip.sina.com/shoujijiaoyou.html;img
src=http://since.vip.sina.com/pic2/yzjiaoyou.gif; width=730 height=59 border=0
alt=/a
=
http://www.chinamysql.com
100M1010M20318/
http://3long.sayba.com
5881800
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 19 Mar 2003, Michael Edlund wrote:
I'm trying to compile MySQL 4.1 on Mac OS 10.2.4 (Darwin Kernel Version
6.4) but run into some problems. When following the general compilation
guidelines...
[...]
...the make process exits with
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul DuBois wrote:
At 5:39 -0800 3/19/03, Karthikeyan Balasubramanian wrote:
Hi,
I m using the following query
SELECT id,
subject,
news,
date_format(date, '%m/%d/%Y %h:%i %p') AS date,
author,
link
FROM news
Hi,
ok, no doubt about that's related software would be nice to informed about
here.
But what I found amazing that there wasn't a discuss just a non-related hint
to get back in mind
But if I'm lonely with my opinion, there's no problem for me!
2EMS HiTech Team:
BTW, I'm not a member of
In the last episode (Mar 19), Philipp said:
thank you for your answer. While i was reading about clustering some
weeks ago i read the openmosix FAQ claiming that openmosix would not
work with apache, because apache was using shared memory to
communicate with its threads, and i always thought
Hi All MySQL ers
I am now starting to confuse myself so everyone else should be just fine with
this query problem / clarification!
I have just discovered through luck that I need to have the same record in
(table items) accessable if it is listed as being in more than one city (table
city).
Hi All MySQL ers
I am now starting to confuse myself so everyone else should be just
fine with this query problem / clarification!
I have just discovered through luck that I need to have the same
record in (table items) accessable if it is listed as being in more
than one city (table city).
Hi Dan,
i just talked about openmosix because i read about
shared memory segments. my only desire is to make mysql
able to spawn 1000-1500 connections and *not* to tell
my client cant create new thread, perhaps out of memory
while 1.5 GB of RAM is only used for caching. Is that really
possible
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
thanks for reporting this. I assume, you used the MySQL package from
mysql.com?
On Thu, 6 Mar 2003, Perry Arnold wrote:
I installed the MySQL binary (4.0.11-gamma package) on my Mac OS X
machine (version 10.2.4) and I couldn't get it to start
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 9 Mar 2003, SUGIOKA Toshinobu wrote:
I found obvious bug that causes segmentation fault while building on
sh-linux. Please apply.
--- mysql-3.23.54a.orig/sql/gen_lex_hash.cc Thu Dec 5 18:37:06 2002
+++
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 14 Mar 2003, Jonathan Stockley wrote:
I've hit a problem on AIX 4.3 with mysql client include files. My app
needs to include xcoff.h which includes dbug.h. The problem is that
I also need to access mysql. It turns out that the mysql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
sorry for the late reply.
On Wed, 5 Mar 2003, ben nevile wrote:
Please define not compatible. What exactly happens when you try to
use them? Is there an error? Which version of MySQL/Code Warrior do
you use?
I am using the most
I am setting u a simple article storage/retrieval system and have set
up a MySQL database with a few VARCHAR fields for author, date,
source and a BLOB field for article. I have also set up two pages,
one for editing/adding new articles and a second one for viewing the
articles.
The
I have done this and have now started to populate the items_city table with the
appropriate records what I now need to do is show the records using the city
items_table. At the moment the records are dipslyed when a city is selected bu
the cityID is from the items table. Lie this:
Hi,
You may get a signal 11 because mysqld process is running out of
virtual memory (instead of physical memory).
If you want to run 1500 simultaneous connections, you have to be very
careful on how mysqld allocates its memory:
Since you are on a 32bits system, a process is limited to 4Gb.
On
Hello all,
I have a database with a type longtext called notes.
Say I wanted to append some text to this field, what command would I use?
I have tried the following sql..
update clients set notes=notes+text to append where id=1;
But this doesn't seem to do the job.
I am new to MySQL so
MySQL 3.23.54, Win2k Server:
I am trying to take a .sql file that I got from a mysqldump from one
mysql server, and use it to populate a new mysql server, as though I
were restoring a backup after a total system crash.
I am using the following command, following the only example I could
find in
Landy,
echo TD colspan=\3\ width=\532\P$article/P/TD;
The text displays, but the paragraph breaks are gone and all the text
is just run together into one long paragraph.
In PHP, you can use nl2br(), like:
echo TD colspan=\3\ width=\532\P.nl2br($article)./P/TD;
This will replace \n (the
In the last episode (Mar 19), Philipp said:
i just talked about openmosix because i read about shared memory
segments. my only desire is to make mysql able to spawn 1000-1500
connections and *not* to tell my client cant create new thread,
perhaps out of memory while 1.5 GB of RAM is only used
Landy Atkinson wrote on 19.03.2003 18:14
...
echo TD colspan=\3\ width=\532\P$article/P/TD;
The text displays, but the paragraph breaks are gone and all the text
is just run together into one long paragraph.
Any suggestions on how to get $article to display and keep the white
I think is better to have an additional record each time a user inserts
new information
Mr Orange wrote:
Hello all,
I have a database with a type longtext called notes.
Say I wanted to append some text to this field, what command would I use?
I have tried the following sql..
update clients
Andrew wrote:
I have just discovered through luck that I need to have the same record in
(table items) accessable if it is listed as being in more than one city (table
city). Obviously I don't want to create new records for the same item so it can
be displayed if it's in different cities. Is
Andrew wrote:
I have done this and have now started to populate the items_city table with the
appropriate records what I now need to do is show the records using the city
items_table. At the moment the records are displayed when a city is selected bu
the cityID is from the items table. Like
On Wednesday 19 March 2003 12:31 pm, Tab Alleman wrote:
I am using the following command, following the only example I could
find in the documentation (mysql prompt shown for clarity):
mysql mysql u:/db backup 20030318/cm_central.sql;
Run this from a command line, not the mysql client.
Ryan
At 12:31 -0500 3/19/03, Tab Alleman wrote:
MySQL 3.23.54, Win2k Server:
I am trying to take a .sql file that I got from a mysqldump from one
mysql server, and use it to populate a new mysql server, as though I
were restoring a backup after a total system crash.
I am using the following command,
It is not strange, it is expected behavior. A browser can only handle so
many lines of html before getting all wonky. Running a query that takes
over 5 minutes to run in a web application is a bad idea, no one is going to
want to sit there and wait for it and if there is no output for an
Hello, all!
I would like to alter MySQL in the following manner :
- If the standard MySQL [PASSWORD()] fails, use PAM to auth
- If the user is authenticated using PAM :
- If a database does not exist of the users name, create it
- Restrict the datamanipulation to that specific
Hello,
I'm using Win98 OS and MySQL 3.23.39-max. Now, I'm trying to load data from
the DOS Prompt into a new database (samp_db):
samp_db create_president.sql
and it returns ERROR 1064: you have an error in your sql syntax near
'samp_db create_president.sql' at line 1
Any ideas will be highly
At 20:57 +0100 3/19/03, Yasen Petrov wrote:
Hello,
I'm using Win98 OS and MySQL 3.23.39-max. Now, I'm trying to load data from
the DOS Prompt into a new database (samp_db):
samp_db create_president.sql
and it returns ERROR 1064: you have an error in your sql syntax near
'samp_db
I know DOS doesn't have a cat command, so try :
type create_president.sql samp_db
Or have I been out of the DOS world too long?
Joe
Yasen Petrov wrote:
Hello,
I'm using Win98 OS and MySQL 3.23.39-max. Now, I'm trying to load data from
the DOS Prompt into a new database (samp_db):
samp_db
Thanks for the replies, Ryan and Paul.
I tried the suggestion of using the command prompt, and it did attempt
to run the .sql file. That's when it *really* gets troublesome:
C:\mysql\bin mysql \mysql\cm_central.sql
ERROR 1049 at line 7: Unknown database '`cm_central`'
Line 7 is:
USE
Hehe.. I just got past this problem and on to the next. You need to
make sure you are executing the command from a DOS prompt..the response
you got indicates (I'm pretty sure) that you are executing it from a
mysql prompt (ie: a mysql client prompt).
Yasen Petrov wrote:
Hello,
I'm using
On Wednesday 19 March 2003 12:38 pm, Dan Nelson wrote:
In the last episode (Mar 19), Philipp said:
i just talked about openmosix because i read about shared memory
segments. my only desire is to make mysql able to spawn 1000-1500
connections and *not* to tell my client cant create new
In one of my tables, I have an AUTO_INCREMENT column that changes to
#Deleted in each column in Access when I add a new record. To read the
data, I just entered, I must close the table and then reopen it. In
another table when I do the same thing, I see the new AUTO_INCREMENT
number come up in the
Hi,
I am developing a mySql Backup software and I intend to develop two
different options for backup: Complete and Incremental, where Complete means
the full copy of a database, and Incremental means that only the log file
have to be copied. The logic is the follow:
Once a week, my
how to ececute it from dos prompt as long as I have to connect to mysql
first. so i'll have mysql prompt anyway. please give me a better
explanation. thank you
-
Before posting, please check:
http://www.mysql.com/manual.php
To be honest, I've never tried to compile MySQL with the CodeWarrior
compiler -
it sounds like nobody has! i guess i'll be the guinea pig.
I'd be interested to hear how it went!
i'll be sure to let everyone know (ie, gloat) if I am successful.
Ben
On Tue, 2003-03-18 at 21:38, [EMAIL PROTECTED] wrote:
Description:
Hello Peter,
Have you explained to Heikki this problem?
Have you fixed it?
Please, tell me about it.
Dear Rafarife,
This problem is qualified as wrong optimizer plan selection.
Happily you can
At 14:07 -0500 3/19/03, Tab Alleman wrote:
Thanks for the replies, Ryan and Paul.
I tried the suggestion of using the command prompt, and it did attempt
to run the .sql file. That's when it *really* gets troublesome:
C:\mysql\bin mysql \mysql\cm_central.sql
ERROR 1049 at line 7: Unknown
Paul DuBois wrote:
Line 7 is:
USE `cm_central`;
Try omitting the backticks from the database name.
mysql has a slightly different parser than the server and
that may be causing you a problem with the USE statement.
Thanks again Paul, that did the trick...which is kind of a BitterSweet
Sidar,
- Original Message -
From: Sidar Lopez Cruz [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, March 18, 2003 10:50 PM
Subject: fulltext search
when MySQL will support fulltext search on InnoDB tables?
we are still waiting for some customer to sponsor
ok this is making sense and I should have thought about this before* I created
my city table as now I have a city table that in effect is useless and
comlicated the existing queries :(
A lesson to be learnt indeed.
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Sent: 19
Hi All MySQL guru's
I have a query that I need some help with. I have put into operation a setup
that needs to be chnaged and could do with a little help before the Db get any
bigger. It's only a small MySQL DB at the moment but will grow so I need to get
this right now before it gets bigger.
Hi,
I am aware of the fact that with 4.1.0, you can specify comments on a column
by column by basis. I was wondering if this functionality could somehow be
simulated in 4.0.x? It is high priority for me, but I cannot deploy the
alpha stage 4.1.0 in a production environment.
Basically, what I
At 21:21 +0100 3/19/03, Yasen Petrov wrote:
how to ececute it from dos prompt as long as I have to connect to mysql
first. so i'll have mysql prompt anyway. please give me a better
explanation. thank you
Uh, sorry. Apparently you didn't even *try* to use the instructions
given, so I will just
At 14:56 -0500 3/19/03, Tab Alleman wrote:
Paul DuBois wrote:
Line 7 is:
USE `cm_central`;
Try omitting the backticks from the database name.
mysql has a slightly different parser than the server and
that may be causing you a problem with the USE statement.
Thanks again Paul, that did the
At 16:11 -0300 3/19/03, Dyego Souza do Carmo wrote:
Hi,
I am developing a mySql Backup software and I intend to develop two
different options for backup: Complete and Incremental, where Complete means
the full copy of a database, and Incremental means that only the log file
have to be
--- Andrew [EMAIL PROTECTED] wrote:
Hi All MySQL guru's
I have a query that I need some help with. I have put into operation a setup
that needs to be chnaged and could do with a little help before the Db get
any
bigger. It's only a small MySQL DB at the moment but will grow so I need to
Me again, new problem further down the same road:
C:\mysql\binmysql \dev_hotel_data.sql
ERROR 1030 at line 73106: Got error 28 from table handler
C:\mysql\binmysql \dev_hotel_data.sql
ERROR 1030 at line 74097: Got error 28 from table handler
Yes, just as it looks, the same error occurred on
At 17:18 -0500 3/19/03, Tab Alleman wrote:
Me again, new problem further down the same road:
C:\mysql\binmysql \dev_hotel_data.sql
ERROR 1030 at line 73106: Got error 28 from table handler
C:\mysql\binmysql \dev_hotel_data.sql
ERROR 1030 at line 74097: Got error 28 from table handler
Yes, just
Thanks, this works great in the MySQL server...I guess
I've never used temp tables before, but when I try to
run this in a PHP script, I get table does not
exist. How do I do this?
--- Harald Fuchs [EMAIL PROTECTED]
wrote:
In article
[EMAIL PROTECTED],
Daren Cotter [EMAIL PROTECTED] writes:
Andrew wrote:
ok this is making sense and I should have thought about this before* I created
my city table as now I have a city table that in effect is useless and
comlicated the existing queries :(
Well, your city table probably isn't useless... it can be used to
translate city IDs into city
Tuomas Heroja wrote:
I have red hat 8.0, gcc-3.2-7, gcc-c++-3.2-7 and
mysql++-1.7.9-3.rh8x.i386.rpm. When I use the command
g++ -I/usr/include/sqlplus myfirstdatabaseprogram.cpp, I get
several basic errors concerning the include file sqlplus.hh
Right now, MySQL++ isn't very well tuned for modern
Hello MySQL Guru's-
This is regarding UNION support in MySQL 4.0.12.
The query below is attempting to return rows that can
be easily parsed for the purposes of creating XML.
The ORDER BY is not being processed properly at the
end of the query. Sample scripts are shown below, to
setup the DB and
Basically, what I would like to do is associate a human readable label
with
each column (in the comment field) so that I can automatically generate
web-based forms for any given table. The script would look at the column's
metadata, display the appropriate HTML element, and display the
Re: this latest version of MySQL. Has anyone installed a production
version of MySQL 4 on the Macintosh platform yet? Anything significant
to report? Advice not to do it yet?
Thank you.
Steve Tiano
-
Before posting, please
At 19:38 -0500 3/19/03, Stephen Tiano wrote:
Re: this latest version of MySQL. Has anyone installed a production
version of MySQL 4 on the Macintosh platform yet? Anything
significant to report? Advice not to do it yet?
You can't use BDB tables.
Thank you.
Steve Tiano
--
Paul DuBois
Scenario:
The current JDBC Connection is
jdbc:mysql//localhost:3306/=xql?user=rootpassword=myrootpass
The database `xql` contains 1 table, `settings`
Another database, `login` contains 1 table, `users`
'm' is a Matcher Object, that contains the users Name
A few minutes ago I noticed the emails from MySQL list were being rejected
at my server because of the mysql.com server being listed in SpamCop.
Information from http://spamcop.net/w3m?action=checkblockip=62.119.101.229
reveals that some of the spam messages that have made it through the list
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Installation failure
Description:
I downloaded the MYSQL Complete package from
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark C. Roduner, Jr. wrote:
Scenario:
The current JDBC Connection is
jdbc:mysql//localhost:3306/=xql?user=rootpassword=myrootpass
The database `xql` contains 1 table, `settings`
Another database, `login` contains 1 table, `users`
'm' is a Matcher
GV wrote:
I think is better to have an additional record each time a user
inserts
new information
Mr Orange wrote:
Hello all,
I have a database with a type longtext called notes.
Say I wanted to append some text to this field, what command would I
use?
I have tried the following sql..
At 1:50 + 3/20/03, Mr Orange wrote:
GV wrote:
I think is better to have an additional record each time a user
inserts
new information
Mr Orange wrote:
Hello all,
I have a database with a type longtext called notes.
Say I wanted to append some text to this field, what command would I
Kindly help.
Where can I the difference between MySql versions 3.23.41 and 3.23.32.
thanks in advance
Ramanan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
if there is a long query i want to continue it
in next like
eg
Select canID from table1 where(text like '%a%' or text
lik
e '%b%') AND canID not in ( text like '%c%' or canID
like '%d%')
here i want to use some concatenation of lines any
solution
Hi, I have a question I hope you can help me with.
I try to develop a database in Borlands Delphi or with C++ and Visual Studio
6 (Windows 2000). Probably I choose Delphi.
Now I want to use MySQL as a platform for my program. According to
http://www.mysql.com/doc/en/libmysqld_overview.html
I can
Each line in MySQL is terminated with a semicolon (;). You can break your
query into as many lines as you need, and just end the last one with a
semicolon.
C:\mysql\binmysql --user=root -p
Enter password: **
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection
89 matches
Mail list logo