On Wed, Jan 17, 2001 at 11:53:40PM -0800, Mike Wexler wrote:
Actually, I'm pretty sure it would need to be done in the MySQL
server. It could be done with either the master or the slave, but I
think the slave would be cleaner.
Probably true. I just haven't thought too hard about it. I
Sasha Pachev writes:
cut
We will add a stricter sanity check for the referers to work around
the bugs in some browsers.
Completo.
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Matt Wagner [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/
On Thu, Jan 18, 2001 at 01:09:35AM -0800, Mike Wexler wrote:
Probably true. I just haven't thought too hard about it. I might
be possible today for the *first* slave, but after that it seems
like it can't be done.
I don't see why not. I'm assuming the master would transmit all
On Thu, Jan 18, 2001 at 10:13:15AM +0100, Marco Bizzarri wrote:
Hi all...
I would like to have some explanation about skip-locking feature of
the safe_mysqld. I've already read the manual pages of safe_mysqld.
The questions are as follows:
1) for a single daemon installation, without
Sinisa Milivojevic wrote:
Stefan Olsson writes:
Hi!
I'm trying to recompile the server with support for more than 16 keys.
This is what i have changed:
sql/unireg.h:#define MAX_KEY 32 /* Max used keys
*/
But when i try to insert data into a table
Valgard Blondal wrote:
Hi,
I was wandering if someone could help on this.
I am using mysql with php3 on a shared server, version 3.22.32
I had been running this for few days without any problems, but
when about 100 users were in to the database, the sign up form
at
Stefan Olsson writes:
By new mysql you mean which version ?
In this new version, is it the same variable to change?
/Stefan
--
I have yet to see any problem, however complicated, which, when looked
at in the right way, did not become still more complicated.
I meant : with
Fai wrote:
According to MySQL rule, the column matching order in mysql database should be as
following:
++-+-
| Host | user|
++ +-
|localhost| |root ||localhost| | ||pit.sample.com |root
Oliver Hinds wrote:
Has anyone experienced problems using DBI and perl with update statements
not updating tables when the equivalent statement at the command line
works, and all other operations work perfectly?
Oliver Hinds
Only when I make the wrong assumption about what perl is
I installed mysql on a Suse 6.4 and it's works, but with only one problem
when I tried connecting from another computer with a php file it says
Warning : MySQL connection failed : host ' ... ' is not allowed to
connect to this MySQL server on ' ... ' line X
If someone could help me please send
From: "Tom" [EMAIL PROTECTED]
Sent: Thursday, January 18, 2001 11:18 AM
I can't seem to get mysql server started on win2k. hell
I don't even know which file to run to start it up. I did
try all though and nothing seems to work.
http://www.mysql.com/doc/N/T/NT_start.html
Normally I'm not a
Hi,
Still not any info about the buffer-overflow discovered last week ?
Shouldn't be fixed at the beginning of the week ?
Please, dear MySQL team, give us info !!
Regards,
Nicob
-
Before posting, please check:
Hi!
This is the first time I am posting to the MySQL mailing list. So let
us see if this message gets through.
Monty recommended that I should write to this list. I am currently
putting my database engine called Innobase under MySQL as a new
transactional table handler. It is projected to come
Hello,
I am running out of possibilities. I scaled down my perl script to just
test a database that I have set up. It is a very small program,
however, I get an error when I run the script. I cannot figure out what
the heck is wrong with my commands that would give me those errors. I
just
Hi,
I need to generate a select statement that has a comparison in it.
I have checked the FAQ to no avail.
I want to write something like this:
SELECT * FROM customers WHERE name =~ 'Jo'
which uses the =~ comparison (used in Perl) to return any records that
contain the letters 'Jo', which could
A small correction: if you want "Jo" to match John or LittleJohn, you need
to do:
SELECT * FROM customers WHERE name LIKE "%Jo%"
Stephen L. Faustino
Senior Software Engineer
SecureLogix Corporation
-Original Message-
From: Craig Atkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
Hi.
I have a database where information is submitted to.
On the submit page I want to show the ID number of next 'thing' to be
submitted.
I use auto increment for the ID.
There must be some way of asking what the last ID number was (I can then add
one to this)
is there a function for this? or
something like this I was hoping
SELECT MAX([database.[ID]) AS [LAST-DEFECT] FROM [database]
Hi.
I have a database where information is submitted to.
On the submit page I want to show the ID number of next 'thing' to be
submitted.
I use auto increment for the ID.
There must be some way
Hi!
On Jan 18, Nicolas GREGOIRE wrote:
Hi,
Still not any info about the buffer-overflow discovered last week ?
Shouldn't be fixed at the beginning of the week ?
Please, dear MySQL team, give us info !!
Regards,
Nicob
Fixed in latest release (3.23.31).
Regards,
Sergei
--
MySQL
Anyone here keeping MySQL on a separate server than their Apache/Linux/PHP box?
Any advice?
I assume I should re-use persistent connections and things like that to reduce
needing to open new connections via TCP/IP.
But anything else I should know? Any URL where I can read more about
is there a function for this? or do I have to get all IDs and parse out
the
last one?
Try this function:
SELECT DISTINCT last_insert_id() from "table_name"
Regards,
David
-
Before posting, please
Description:
Trying to set the mysql root password using the command line given
results in a permissions error connecting to the database @localhost.
How-To-Repeat:
Cd to my home directory, and execute:
./usr/local/mysql/bin/mysqladmin -u root password 'anypassword'
Fix:
Unknown
Submitter-Id:
But it happens more likely if You load more tables
at once with a script, e.g.
drop table one
drop table two
drop table three
load table one from master
load table two from master
load table three from master
load table first,second,...,last from master
this command should load all these
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
#define def_user_name
I have a calendar db, and in there a base table (with
holidays and such). I need to create a table, exactly the
same as the base (data included). Is there an easy way of
doing this?..
Alejandro Lujan Toro
CAI: Centro de Aplicación de la Informática
On Thu, 18 Jan 2001, Gerald L. Clark wrote:
Oliver Hinds wrote:
Has anyone experienced problems using DBI and perl with update statements
not updating tables when the equivalent statement at the command line
works, and all other operations work perfectly?
Oliver Hinds
Only
As far as hardware goes, you should be able to increase performance with
more RAM and faster disks such as UW-160 SCSI.
Also, I don't think they make dual processor motherboards for Athalons.
- Scott
(The total throughput we need is on the order of 100 indexed updates
per second; currently
On Thu, Jan 18, 2001 at 04:47:47PM +0200, Heikki Tuuri wrote:
Monty recommended that I should write to this list. I am currently
putting my database engine called Innobase under MySQL as a new
transactional table handler. It is projected to come out with MySQL
version 4 as free open source
I have these tables:
table fields
a IPadd, MAC
u IPadd, MAC, user
si IPadd, deviceID, ifIndex
sf deviceID, ifIndex, MAC
For any given values of IPadd and MAC in 'a' there may or may not
be records in 'u', 'si' and
The 1.9.7 manual section (http://www.mysql.com/doc/n/o/node_17.html) is a list
of distributions that includes MySQL, and various distributions arent listed
there.
Conectiva Linux ships MySQL since version 4.0 (up to the last version, 6.0).
Sorry, I'm not in the list, any replys please CC it to
If there is a possibility for outside testing of this then I would also like
the opportunity, alpha/beta code or not.
Sounds extremely interesting.
Andy Jennings
Programmer/Systems Engineer
eAccountable
214-273-5492
-Original Message-
From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
Has anyone else experienced a problem in which queries get mangled
(using mysql 3.23.30 for both client and server, client is on redhat
6.2, server is on solaris 2.7)? It appears to happen only for one query
in particular (posted below).
select parts.part_code,parts.price,parts.name FROM
I have a table called CONTENT. Columns called ID (primarykey), DOCUMENT
(varchar(50)), DESCRIPTION (text). People submit files to our intranet and
we collect info. about them in this table. If people have made changes to
the doc. they just resubmit it to the intranet. So there can be many
I am currently developing an export control system that uses mysql and
would be very interested in testing your new tansaction table handler.
Roger Grayson
[EMAIL PROTECTED]
Motorola::SPS::ASP::SoCDT::MACS::me
Andy Jennings wrote:
If there is a possibility for outside testing of this then I
Sorry, I was away for a bit, and got side tracked!
I have a tiered Access application running over a WAN, and performance has turned out
to be an issue. But to convert the Access queries into something that MySQL can
understand takes a while. I started converting them before, but ran into a
I run a small business. A year and a half ago I embarked on a jorney to
port my DOS Foxpro Database to linux. I selected mysql as an the engine
and and begand writing the app. using perl/dbi and perlmenu
module/curses as the front end at first I used NFS to share the databse
files on the LAN.
Hi.
On Thu, Jan 18, 2001 at 03:25:24PM -0500, [EMAIL PROTECTED] wrote:
Sorry, I was away for a bit, and got side tracked!
I have a tiered Access application running over a WAN, and
performance has turned out to be an issue. But to convert the
Access queries into something that MySQL can
Oliver Hinds wrote:
On Thu, 18 Jan 2001, Gerald L. Clark wrote:
Oliver Hinds wrote:
Has anyone experienced problems using DBI and perl with update statements
not updating tables when the equivalent statement at the command line
works, and all other operations work perfectly?
On Wed, Jan 17, 2001 at 03:17:52PM -0600, Richard Reina wrote:
I run a small business. A year and a half ago I embarked on a
jorney to port my DOS Foxpro Database to linux. I selected mysql as
an the engine and and begand writing the app. using perl/dbi and
perlmenu module/curses as the
I know it's not "correct" to just jump in and ask and I apologize, but I'm
under a bit of a time crunch here...
I need to find a web front end that I can use to update a table in MySQL.
What I'm looking for is a program that will display an entire table with
records as a web page for editing.
Dear subscribers
I just baught the book "mySQL" from DuBois and it refers to a sample data base called
samp_db. This data base should be on the url: www.mysql.com/contrib/rxamples/
but this url doesn't existe. If anybody, who read this book has this file or knows
where i can download it from,
Thanks for the reply. Curses worked OK. But I was convinced that a web
server would be more efficient than NFS for sharing the database files.
Is that true? Or is a NFS a longtime viable solution for clients on the
LAN quering the database.
Richard
"Jeremy D. Zawodny" wrote:
On Wed, Jan
Hello all,
I am running 3.23.31 (rpm install) on a couple servers. The replication is
setup for bi-directional although most, if not all, of the updates are only
going in one direction. The other direction is only if the webserver fails
over and suddenly users are updating the backup server's
The link contained in the coumentation, http://dbimysql.photoflux.com/,
leads to page that points to a non existant link.
So.I HAVE checked the docs before asking. I require more
information on using the Perl API with my mysql than perldoc DBD:mysql
provides. Any links would be
You can connect to the DB on Linux using ODBC over any TCP/IP network, and
you don't need to worry about NFS, File sharing, Samba etc.
All you need is MySQL on Linux connected to your network and ODBC will
connect on port 3306 over TCP/IP, that's all you need.
A system built this way can use many
On Thu, Jan 18, 2001 at 01:49:30PM -0800, Jeremy D. Zawodny wrote:
On Wed, Jan 17, 2001 at 03:58:11PM -0600, Richard Reina wrote:
Thanks for the reply. Curses worked OK. But I was convinced that a
web server would be more efficient than NFS for sharing the database
files. Is that
1. I would just keep the names in the database table. Storing the
images themselves would require a blob field, which means that you would
have to run OPTIMIZE TABLE a lot more often to keep it running fast. If
you just store the name, you can use a varchar. Not only does it take
up less
How can I do the following:
update location set location.city_id = location_city.city_id where
location.city = location_city.name;
I want to update one field in a table with values from another table. Is
this possible within MySQL or do I need to write some code to do this.
Any help would be
Try phpMyAdmin if you are also using php. I use it all the time, works
great.
Search at phpbuilder.com for it.
Jason Frisvold wrote:
I know it's not "correct" to just jump in and ask and I apologize, but I'm
under a bit of a time crunch here...
I need to find a web front end that I can
Can someone tell me whats worng with my syntax:
use DBI;
$dbh = DBI-connect("DBI:mysql:rushload\@leader","richard", "passwd");
leader = name of server, rushload = name of database
Do I need a port number if so which one should I use?
Richard
"Jeremy D. Zawodny" wrote:
On Wed, Jan 17,
Hi.
On Thu, Jan 18, 2001 at 05:39:25PM -0500, [EMAIL PROTECTED] wrote:
How can I do the following:
update location set location.city_id = location_city.city_id where
location.city = location_city.name;
I want to update one field in a table with values from another table. Is
this
The grant was done by:
# echo "grant INSERT,SELECT on snort.* to
snortdb@'XXX.XXX.0.0/255.255.0.0';" | mysql -u root -p
The system has TCP wrappers setup and the hosts.allow file is empty and
hosts.deny is set to ALL:ALL. next time I'm at work I'll try putting in
hosts.allow the ip address of
Description:
I just downloaded MySQL 3.23.31 and the "patched version" of
Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure
with the option to enable the Berkeley DB, but it fails, telling
me I don't have the proper version of the DB. Here are the
Hi,
Running
# perror -v 132
gives
132 = No buffer space available
132 = Old database file
which result is correct?
Quentin Bennett
Transport Systems Division
Infinity Solutions
Phone: + 64 9 358 9720
Fax : + 64 9 309 4142
mailto:[EMAIL PROTECTED]
http://www.infinity.co.nz
The information
Chris Johnson wrote:
Description:
I just downloaded MySQL 3.23.31 and the "patched version" of
Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure
with the option to enable the Berkeley DB, but it fails, telling
me I don't have the proper
Description:
Installed:
* MySQL-3.23.27-1.i386.rpmMySQL-shared-3.23.27-1.i386.rpm
* MySQL-client-3.23.27-1.i386.rpm MySQL-devel-3.23.27-1.i386.rpm
#1)
Had to use "--nodeps" so the server and client portions would pass
the
Hi,
I'm curious if anyone knows the purpose of the DELETE_ITEMS defines in
the MySQL source tree. I'm guessing they were either put there by their
memory leak checking software, or perhaps to bypass broken compilers? I
see the defines in both 3.22.32's and 3.23.30-gamma's source trees.
I'm on
This gives me one instance of each file name in the DOCUMENTS column
submitted into the database. The only thing though is it gives me the
oldest of the file name in the DOCUMENTS column which are submitted. Any
ideas how to get the newest one? I've tried adding: , MAX(ID) after the
SELECT *.
did big table lock remove from MySQL BDB table while updating?
Regards
David
- Original Message -
From: "Michael Widenius" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 19, 2001 6:45 AM
Subject: MySQL 3.23.31 is released
Hi!
Hi.
Can anyone tell me how or refer me to any tutorials on how to connect to mysql using
Microsoft Visual Basic (v. 6)?
Any help would be much appreciated. Thanks.
Kind regards,
Dwight Mowbray.
E-commerce solutions provider.
Email: [EMAIL PROTECTED]
I am having a table of 60 rows of data with userid as
the primary key. I want to start the new data entry
with the userid '1' instead of from '61' now, how can
i do that with out dropping the table and its content
altogether.
TIA
Chakravarthy K Sannedhi
[EMAIL PROTECTED] writes:
Description:
Installed:
* MySQL-3.23.27-1.i386.rpmMySQL-shared-3.23.27-1.i386.rpm
* MySQL-client-3.23.27-1.i386.rpm MySQL-devel-3.23.27-1.i386.rpm
#1)
Had to use "--nodeps" so the server and client portions would pass
Someone sent me some samples of various connection type (ADO, DAO, etc)
about a month ago but I'll post off list.
- Original Message -
From: "Dwight Mowbray" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 19, 2001 10:18
Subject: Connecting to MySQL with Visual Basic
Hi.
phiLLip maDDux II writes:
Hello,
I am working on loading data into a table from a text file. I've read
the documentation on the LOAD DATA command. But I noticed that it only
works with some kind of delimited file. Is there any way to load a
fixed width file???
Hi!
Unfortunately this is
Greg Cope writes:
Chris Johnson wrote:
Description:
I just downloaded MySQL 3.23.31 and the "patched version" of
Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure
with the option to enable the Berkeley DB, but it fails, telling
me I
I want to write a sql to order by a column, whe column contain only three type
"a", "b", "c",
how can I order by the column with the sequence of b,a,c . thank you.
My english is not well ,sorry.,. :)
Best Regards
LSQ
TEL:13500011809
Company:020-83881512-223
Is there anyway to tell how many connections are currently being served by
MySQL. I'm using this in combination with PHP. Also, does MySQL
automatically shut down when you leave the page? I'm not using
mysql_pconnect - just the regular mysql_connect.
Thanks,
Mike
Hi there,
I am setting up a lab on MySQL and I am not able to.
Its a red hat 7.0 server and has PHP installed and working with apache.
I installed MySQL from the very RPMs Red Hat provided.
Whenever I try to start the server, I get the error message:
Can't connect to local MySQL server through
Sorry, I'm confused on what you have (machines? what is running on what?),
what your ISP has and what you are trying to do. Do you know about
phpmyadmin program? Maybe it is what you're looking for.
Most importantly, why did your ISP recommend you use ODBC on a Win2k? Do
they have some
69 matches
Mail list logo