Hi,
Friday, August 10, 2001, 8:05:41 PM, David Harrison <[EMAIL PROTECTED]>
wrote:
DH> You can't use inetd, but if you have a machine with System V type run
DH> levels, the file support-files/mysql.server can be placed in
DH> /etc/rc.d/init.d or whatever your flavor of UNIX uses, with appropriat
VDA wrote:
>
> Hi,
>
> Friday, August 10, 2001, 8:05:41 PM, David Harrison <[EMAIL PROTECTED]>
>wrote:
> DH> You can't use inetd, but if you have a machine with System V type run
> DH> levels, the file support-files/mysql.server can be placed in
> DH> /etc/rc.d/init.d or whatever your flavor of
ok...here's the deal.
I have successfully developed a script to verify user authenticity. however,
i need to verify what the "User Type" is for purposes of redirection to a
certian page.
++-+---+--+
| ID | BearID | SSN | UserType |
+
Environment: Red Hat 7.1
mysqld 3.23.36-log
/etc/my.cnf as follows:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin=/bu/mysql/online-log/iServ2
log-bin-index=/bu/mysql/online-log/iServ2.index
[mysql.server]
user=mysql
basedir=/var/li
On Tue, 14 Aug 2001, Kit Kerbel wrote:
> This is a sample of my table.
>
> how would i go about checking the user type after I have verified that the
> user exists in the table? I tried this query:
> // Determine User Type For Redirection
> $redirect = "SELECT UserType FROM User WHERE
>
If you create a Berkeley-DB table (es. CREATE TABLE TEST TYPE BDB) is not
possible delete it after.
The command DELETE TABLE TEST responds Table unknown.
Thank You
Luciano
-
Before posting, please check:
http://www.mysql.com/
Look at this MS SQL:
Declare @BF char(10)
Declare @BL char(10)
SET ROWCOUNT 1
Select @BF=Date From Results Where GameID=1 Order by Date ASC
Select @BL=Date From Results Where GameID=1 Order by Date DESC
Select @BF As BF, @BL As BL
--
Now wonna to implement above to myS
Subject : Database
Hello all,
We have various routines which Insert in to tables. And in some cases there
are alot of rows involved, which understandably can take some time.
I just want to check that my understanding of the INSERT DELAYED option is
correct. When using DELAYED, are all rows 'm
Hi1
I have built MySQL++ lib on OS X and have uploaded static version of
the library for Mac OS X on MySQL++ page.
OS X users just have to install manually that library and include
files and can start using it.
Library is built with GNU 2.95.2 and is therefore useable only with
that compiler
Hello,
I am currently changing a simple PHP4-based application from PostgreSQL
7.1 to MySQL 3.23. I have some tables in the database which I would like
to create as TYPE=HEAP in MySQL. Because I have read the MySQL manual
(applause here, please!) I know that auto_increment cannot be used there.
T
Hi,
You are trying to use nested select for that update wich MySQL do not
support insted use :
update table set field = value from table inner join table where bla = bla
Sincerely,
Yosi Oren
VP,R&D manager
Tel : +972 4 908 2180 ext 217
Fax : +
Hi List!
I got some questions about tables:
- How do I get the creation date of a certain table?
- Is there a SQL-statemanet to delete tables that have a certain age?
- If I delete a table do all the indizes created on that table get dropped
automatically?
Thanks in advance for your answers,
B
Hi, I am curious if there is a way to delete exactly the same rows from a
table with one query?
Or must I do select and delete one query at a time?
I accidentally parse an html file twice, and I want to keep the rows that
are distinct.
Thanks for your help,
-Jon
Hi,
How can I add a new type to MySQL ?
Thanks.
--- Sylvain BARTHELEMY
http://www.tac-financial.com | http://barth.netliberte.org
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.
Luciano Pulvirenti writes:
> If you create a Berkeley-DB table (es. CREATE TABLE TEST TYPE BDB) is not
> possible delete it after.
> The command DELETE TABLE TEST responds Table unknown.
> Thank You
> Luciano
>
Your CREATE statement is a bit dubious, so check that there is such a
table at all.
Hello mysql mailing list readers,
Secure Attention Key is supposed to kill all processes on current
console. Usually init respawns new getty. This way I can be sure that
login prompt I see is not mimicked by password collecting program.
I like this idea a lot.
I noticed that when I press Secur
Hello mysql mailing list readers,
>Daemons surviving SAK: klogd gpm dhcpcd
inetd: Me too! And I don't let you SIGKILL my children!
automount: I'm at least as tough as inetd!!
Also I see '?' in TTY column in 'ps -AH e' output for all these
daemons (both dying and surviving), so ps does not pr
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MYSQL bug with if and datetime fields
>Description:
In queries where datetime field is in "WHERE" condition, the same
field
in "IF" statement causes incorrect query result.
>How-To-Repeat:
#--
Arturs Aboltins writes:
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: MYSQL bug with if and datetime fields
>
> >Description:
> In queries where datetime field is in "WHERE" condition, the same
> field
> in "IF" statement causes incorrect query result.
> >How-To-Repea
Hi!
> "Eric" == Eric DeCosta <[EMAIL PROTECTED]> writes:
>> Description:
Eric> Index analysis and optimization is choosing wrong index when a
Eric> table involved in a JOIN is compound. MySQL should still be using
Eric> the first part of the GECK_STATE PRIMARY key (geck_id) since it is t
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Rene Churchill writes:
>>
>> I'm having a problem with mysql forgetting the location
>> of it's datadir. After the server has been running for
>> some time, it looses track and starts throwing errors
>> when I attemp
I am running a mysql server on a stand-alone host that is queried
by a web server. I am currently seeing an average of 33 queries
per second, although this is often a lot higher.
The problem is, when large numbers of connections start
to arrive, the machine load gets very high - but MySQL doesn't
> I nave no problem in running mysqld.
> But my Linux machine have only 32 Mb of RAM.
> I just like to make mysqld load *on demand*.
Just for reference, most modern *nix variants will
handle this situation properly. If MySQL isn't doing
anything, its memory space will get swapped out to
disk and
Michael T. Babcock writes:
> > Thank you for your technical question to the MySQL team.
> > Unfortunately, our developers are not able to answer this type of
> > inquiry if you have not purchased a technical support contract.
>
> I'd like to know if this is now official MySQL policy (filling t
Hello,
I am new to mysql. I install windows version MySQL. I want to initial mysql with
command mysqld, I get an error message as "can't initialize innoDB as
'innodb_data_file_path' is not set". Could you please help me how to solve this
problem?
Thanks
Henry
Hi Heitzso,
Thanks for your suggestion, and in the absence of feedback from anybody else
I suspect you're probably right. The system this thing is running on is a
vastly outdated P150 with 128MB.
I was hoping that I could do a little trick with the tables to optimize the
queries a little more a
You are connecting TO host www.4cdg.com, but the permission table entry
list the hosts you connect FROM.
You need to grant privileges to the user and machine you connect FROM.
Butch Evans wrote:
> Can anyone explain why this is happening?
>
>
> root@www:/# mysql -u dgadmin -h www.4cdg.com -p
This really is not a MySQL issue, but a Red Hat issue.
Don't logrotate the MySQL bin logs.
Joel Fowler wrote:
> Environment: Red Hat 7.1
> mysqld 3.23.36-log
>
> /etc/my.cnf as follows:
>
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
To avoid the "Fatal Embrace" where two users each lock a table, and
then attempt to read the table the other locked, you must lock
all table you intend to use for the duration of the lock.
The manual clearly states that a subsequent lock or unlock command
will first unlock all the tables you curre
MySQL does not support multi table updates yet either.
Yosi Oren wrote:
> Hi,
> You are trying to use nested select for that update wich MySQL do not
> support insted use :
> update table set field = value from table inner join table where bla = bla
> .
>
> Sincerely,
>
I have two servers running mysql on UnixWare 7.1.1. The 1st (uwdev1) is on
level 3.22.25 and has been running for more than a year with no problems at
all. The 2nd (sqlsrv1) is new and is running 3.23.39. The same databses are
on each server. Eventually all mysql databases will be on the sqlsrv1
s
Now again I want to tell sorry to everyone who was shoked by my letter
which told that we do not give answers without money.
The truth is that MySQL developers have about 20 different mailing lists
to read in priority order. We have mailing list for people who pay for
support and their mails get
I noticed from the archives that some people had problems
configuring the MySQL source. They were getting the same
error message as I was getting, about termcap and curses
libraries being missing, but nobody seemed to work out
exactly what was wrong or what needed installing.
On Linux Mandrake 8
How to translate this to mySQL:
--
IF NOT EXISTS
(
Select Number From Results Where GameID=1
)
begin
INSERT INTO Results
(
GameID,
Date,
Number
)
VALUES
I've got a fairly simple MySQL system here using replication, one master
and one slave.
Looking at the system the other day and the database logs are sure building
up. Is there
any standard way ("best practice") - preferably automated - to keep these
under control?
If not, I've have a go at doi
I have an application that requires the storage of various flags (by
"flag", I mean a variable that is either 1 or 0).
What's a good way of doing this? I've thought about two ways:
Method 1: Make a TINYINT column for each flag
I can use TINYINT NOT NULL datatype for storing each flag. The
disad
Hello mysql,
I'm trying to install mysql from source in a redhat 7.1 machine but
got the following errors(under section 'compile status'). I tried the
same in my redhat 7.0 without any problem. Please give me some ideas
on the following matters:
1. Should I update the gcc compiler using the upd
Hi,
I'm trying to connect to a mysql database from linux
using the driver mm.mysql-2.0.2-bin.jar. The connect
is successfull, but when I want to retrieve some
records from the database, I get the message
"error reading communication packets". Do someone has
an idea, what it can be?
Thanks and be
Henry,
if you do not want to use transactional InnoDB tables,
add
skip-innodb
to your my.cnf or my.ini file.
If you want to use InnoDB tables, follow the instructions:
To use InnoDB tables you must specify configuration parameters in the MySQL
configuration file in the [mysqld] section of the
Update -- The problem I described happened again, and this time I was able
to get the "mysqladmin processlist" done. Here are the results from that.
Can you help me find my problem based on this information?
Thank you!!
Here is the "top" header: 11:09am up 4 days, 20:15, 1 user, load
averag
I have a user on my system with a normal shell account, and a normal MySQL
account that owns a database.
How can this unpriviledged user back up his database using mysqlhotcopy?
I've run into two problems:
1. He has to login as the MySQL root user in order to be able to execute
"FLUSH TABLES".
Having trouble with e-mail servers this morning and not sure if my
subscription request made it. If this has been reported already or is the
incorrect mailing list for this issue, please excuse and point me in the right
direction.
Had a internet connection failure last night and due to what appea
- Original Message -
From: "Ryan Shrout" <[EMAIL PROTECTED]>
To: "Tonu Samuel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 5:21 PM
Subject: Re: Mysql causing severe load problems on Dual-Athlon server?
> Update -- The problem I described happened again, an
You could use a separate flags table that contains the
parent record key, flag name, and flag value.
You can then add and delete flags at will.
Philip Mak wrote:
> I have an application that requires the storage of various flags (by
> "flag", I mean a variable that is either 1 or 0).
>
> What'
This is happening to me also!
I have a Dual P-III, 550, 896MB RAM.
Suddenly mysql says it has connections busy
most of them "LOCKED", and then suddenly they start working on all of them
at the same time. This creates a load average similar to .
Is this a problem related to Linux, or is it a MyS
This just happened a second time today... that is the most frequent yet.
Please, you have got to help me on this!
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: "Ryan Shrout" <[EMAIL PROTECTED]>
To: "Tonu Samuel" <[EMAIL PROTECTED]>
Cc:
Anybody seen this before:
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H
-I/export/home6/temp/mysql-3.23.41/include -DHAVE_RWLOCK_T -o mysqlbinlog
mysqlbinlog.o mini_client.o net_serv.o mini_client_errors.o
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Arturs Aboltins writes:
>> From: [EMAIL PROTECTED]
>> To: [EMAIL PROTECTED]
>> Subject: MYSQL bug with if and datetime fields
>>
>> >Description:
>> In queries where datetime field is in "WHERE" condition, the same
I've got two tables, "Current" and "Temporary", Current has a row with
login='keric', Temporary doesn't.
The following query:
mysql> select * from Current, Temporary where Current.login='username'
or Temporary.login='username'
-> \g
Empty set (0.01 sec)
obviously doesn't work. I want to k
Hi,
There seems to be a round-off problem with FLOAT.
Here's a scenario to replicate it...
<-->
$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1149 to server version: 3.23.41
Type 'help;' or '\h' for help. Type '\c' to clear the buffe
I used mysqladmin to create a database and set the grant properties to
root@localhost with the password, but now am unable to use mysql at all.
How can I rectify this problem? When I try to access mysql I get
'Access denied for user root@localhost'. I have tried, from the command
line, with -uroot
Sorry, but this system has quad 15K RPM SCSI hard drives running RAID 0+1.
I don't think hdparm applies to that.
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: "Werner Stuerenburg" <[EMAIL PROTECTED]>
To: "Ryan Shrout" <[EMAIL PROTECTED]
How about a UNION query...?
-Original Message-
From: Eric Anderson [mailto:[EMAIL PROTECTED]]
Sent: Tue, 14 August 2001 18:56
To: [EMAIL PROTECTED]
Subject: SELECT .. OR from multiple tables
I've got two tables, "Current" and "Temporary", Current has a row with
login='keric', Temporary
Actually, I ran this test:
[root@dagger /root]# hdparm -Tt /dev/sda
/dev/sda:
Timing buffer-cache reads: 128 MB in 0.93 seconds =137.63 MB/sec
Timing buffered disk reads: 64 MB in 13.92 seconds = 4.60 MB/sec
And that does seem pretty bad, doesn't it? Is there optimization for SDA
like t
Your query will work in every case, EXCEPT when either "Current" or
"Temporary" has 0 rows, because then there's nothing to join. I'm not sure
if doing a join is a "clean" way of doing this though.
If you know that "Current" will never be empty (but "temporary" might be),
then this query would wo
Dave Jolly wrote:
>
> Hi,
>
> There seems to be a round-off problem with FLOAT.
>
> Here's a scenario to replicate it...
>
> <-->
> $ mysql
>
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1149 to server version: 3.23.41
>
> Type 'help;'
We have had a MySQL/Apache/Perl combo running fairly smoothly. However
the other day MySQL seemingly went crazy, and brought the rest of the
system down; no sockets were available, even to ssh into. After a few
minutes, enough sockets were available to ssh into, however MySQL seemed
to far gon
This link, http://www.mysql.com/doc/P/r/Problems.html is a life-saver. Check
out A.9 for your specific problem.
Hans
[EMAIL PROTECTED] wrote:
> I used mysqladmin to create a database and set the grant properties to
> root@localhost with the password, but now am unable to use mysql at all.
>
> How about a UNION query...?
Hmm.. that construct is a little ugly for me - I think I'd rather just
issue two quick queries in each table. Thanks for the tip though.. I
missed that one.
> I've got two tables, "Current" and "Temporary", Current has a row with
> login='keric', Temporary doesn't.
> Your query will work in every case, EXCEPT when either "Current" or
> "Temporary" has 0 rows, because then there's nothing to join. I'm not sure
> if doing a join is a "clean" way of doing this though.
>
> If you know that "Current" will never be empty (but "temporary" might be),
> then this que
I agree that Red Hat has an issue with safe_mysqld and logrotate.
However, in my opinion MySQL has a much more serious problem.
In a logging system there shouldn't be any subtle ways to drop records let
alone entire logs.
Kill -HUP is exactly that -- a very poor design leading to a
big trap - o
On Tue, Aug 14, 2001 at 10:14:58AM -0700, [EMAIL PROTECTED] wrote:
>
> I used mysqladmin to create a database and set the grant properties
> to root@localhost with the password, but now am unable to use mysql
> at all. How can I rectify this problem? When I try to access mysql
> I get 'Access den
>Description:
mysql 3.23.41 doesn't build properly on IA32 with assembly and innobase enabled.
3.23.40 didn't have this problem
Configure statement in spec file ("%configure" is a standard rpm macro, specifying
CFLAGS and CXXFLAGS and various prefixes)
%configure --without-debug \
--wi
I don't recall ever losing a log.
Are you sure logrotate isn't renaming it?
Joel Fowler wrote:
> I agree that Red Hat has an issue with safe_mysqld and logrotate.
> However, in my opinion MySQL has a much more serious problem.
> In a logging system there shouldn't be any subtle ways to drop reco
These scripts should not be creating their own sockets.
The should be connecting to the one socket that the mysql server creates.
Hans Zaunere wrote:
> We have had a MySQL/Apache/Perl combo running fairly smoothly. However
> the other day MySQL seemingly went crazy, and brought the rest of the
Ok. I didn't write these scripts, as they were in place when I arrived at this
position, however
from looking through them, it appears the actual connection to MySQL happens with
something like:
my $dbh = connect("DBI:mysql:database:localhost", "user", "password");
The above is a perl line.
Hi all,
I am very new to the encrypt and decrypt data process and would like to know how
do I able to encrypt a string and store to MySQL and retrieve the data and decrypt it
at the later time.
I understood it sorts of contradict the point of security but I just want to use
it to cove
No, unfortunately they just seem to be gone along with the integrity of
most good recovery strategies.
Joel Fowler
==
At 01:16 PM 8/14/01 -0500, Gerald Clark wrote:
>I don't recall ever losing a log.
>Are you sure logrotate isn't renaming it?
>
>Joel Fowler wr
I've also reported this problem to Red Hat' Bugzilla as I understand
they're responsible for the /etc/logrotate.d/mysql script. It's Bugzilla
[Bug 51711] "Changed - MySQL looses bin-logs during logrotate".
Joel Fowler
===
At 01:16 PM 8/14/01 -0500
REAL MONEY
Subject: Fw: .AS SEEN ON NATIONAL TV
>
>
> > Subject:REAL MONEY
> >
> > Dear Friend & Future Millionaire:
> >
> > AS SEEN ON NATIONAL TV:
> >
> > Make over a half million dollars every 4 to 5 months from your home for
an
> investment of only $25 U.S. Dollars on
Michael,
I just did something like this, and used the ENCODE/DECODE. Works well.
Basically you want to assign a "special key" for the encoding/decoding of the
data you want to encode/decode. The column type should be either a BLOB or
TINYBOLD, as it's stored in a binary format, depend on the siz
Thanks for all the replies, I have followed the instructions in the manual
and am still getting
an error, here is the message:
---
simrad_4# safe_mysqld --skip-grant-tables &
[1] 57953
simrad_4# Starting mysqld daemon with databases from /var/db/mysql
simra
If all you're looking for is a trivial hiding of the data, then I'd
suggest doing a rot13 on the string. I highly doubt there is a native
SQL function that does this, so you'll need to write your own function
in whatever interface you're using. Perl/PHP/whatever.
Rot13 is a simple rotation of
Joel Fowler <[EMAIL PROTECTED]> writes:
> I've also reported this problem to Red Hat' Bugzilla as I understand
> they're responsible for the /etc/logrotate.d/mysql script. It's
> Bugzilla [Bug 51711] "Changed - MySQL looses bin-logs during
> logrotate".
3.23.41-1 uses a new method for flushing l
I have resolved this problem. The program doing the mysql_real_open had been
compiled with the thread library by a "cc -Kthread ..." compile. When
the -Kthread option was removed the problem went away.
- Original Message -
From: "Steve Rickard" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROT
Connect() does that for you.
The mysql library handles the communication to the server.
You just use the supplied functions.
Are you sure it was sockets you were running out of?
Hans Zaunere wrote:
> Ok. I didn't write these scripts, as they were in place when I arrived at this
>position, how
On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL PROTECTED] wrote:
>>Thanks for all the replies, I have followed the instructions in the manual
>>and am still getting
>>an error, here is the message:
>>---
>>simrad_4# safe_mysqld --skip-grant-tables &
>>[1] 579
Thank you for all your valuable help and input. I now got some idea to do
the job. Greatly appreciated.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Michael Tam" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 12:16 PM
Subject: Re: encrypt/decryp
What is your /etc/my.cnf? Do you see mysql daemon running? (use ps -ef)
Maybe it is under /tmp/mysql.sock. You need to change the configuration
and restart server.
Shu
At 01:28 PM 6/1/2006 +0530, sachin wrote:
>Hello,
>I am working on RH Linux 7.0
>MySql is not working at all.
>My MySql file
Thank You so very much. Your way was great, fast and efficient. Here is
my line of code:
insert into sub2 (email,list_id) select email, list_id from subscribers;
Thanks Again
Steve Buehler
At 03:31 AM 8/14/2001, you wrote:
>I'd do it this way:
>
>insert into table table_new
>select f
Adive, put the Spammer from the e-mail into an access file and
stamp reject next to it.
On Wed, Aug 15, 2001 at 01:14:25AM +, Dan Mitchell wrote:
> REAL MONEY
>
> Subject: Fw: .AS SEEN ON NATIONAL TV
>
>
> >
>
> >
> > > Subject:REAL MONEY
> > >
> > > Dear Friend & Fu
At 12:33 AM 8/14/2001 -0400, Trond Eivind Glomsrød wrote:
>Shu Xiao <[EMAIL PROTECTED]> writes:
>
> > Hi,
> >
> > I have problem starting MySQL on Redhat7.1. After installed Redhat7.1 which
> > include MySQL rpm installation, I saw the file named mysqld under
> /etc/init.d .
> > I set up symlink
Shu Xiao <[EMAIL PROTECTED]> writes:
> BTW, if I want to upgrade to new rpm version, what should I do.
> The RPM program will take care of upgrading itself?
If you get the new version of mysql in rpm format (eg. from Rawhide),
'rpm -Uvh mysql*rpm' should take care of it.
--
Trond Eivind Glomsr
I am trying to do a nested if, but it appears to break my query...
Here is a sample of what I am trying to, basically validating email
addresses out of a db:
select IF( (LENGTH( emailaddr ) <= 1 ||
NOT LOCATE( "\@",emailaddr ) ||
LOCATE( " ",emailaddr ),
(IF address.ts >= 2001081300,
> Connect() does that for you.
> The mysql library handles the communication to the server.
> You just use the supplied functions.
> Are you sure it was sockets you were running out of?
Well the supplied functions have been used. How could I confirm that the system was
in fact running
out of so
Hey im pretty new to mysql, but I made a basic html form and used php to post it to my
mysql database. It goes in fine, but it only carries the first word in each input box.
So say for "description" I put in "My little white dog" it only stores "My" in the
database. Would appreciate any insight
[EMAIL PROTECTED]@bellsouth.net on 08/14/2001 10:03:13 PM
Internet mail from:
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: I blew it big time... locked myself out of mysql
On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL PR
Title: Blank
I am getting this error when trying to install mysql
# ./configure --with-low-memory --prefix=/usr/local/mysql loading
cache ./config.cachechecking host system type...
i586-pc-linux-gnuchecking target system type...
i586-pc-linux-gnuchecking build system type... i586-pc-linux-
On Tue, 14 Aug 2001, Bruce Stewart wrote:
> How about a UNION query...?
Too bad MySQL doesn't support them yet ;)
-dave
/*==
www.urth.org
We await the New Sun
==*/
-
Before posting, please ch
>>I am very new to the encrypt and decrypt data process and would like
to know how do I able to encrypt a string and store to MySQL and retrieve
the data and decrypt it at the later time.
Grab a copy of mcrypt (search http://freshmeat.net/ for it) and read
the docs for it -- its a good idea t
Title: Blank
I am getting this error when trying to install mysql
# ./configure --with-low-memory --prefix=/usr/local/mysql loading
cache ./config.cachechecking host system type...
i586-pc-linux-gnuchecking target system type...
i586-pc-linux-gnuchecking build system type... i586-pc-linux
Hello,
My ISP provides me with a MySQL database. I have installed MyODBC and MySQL
on my Windows2000 machine. Can you tell me if its possible to replicate the
database to my own computer, make changes and these be replicated back to
the database hosted by my ISP ?
Thanks for any help
Neil
--
post some code. Make sure you're using quotes in the right places.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Tue, 14 Aug 2001 13:39:48 -0700
"Nate Sanden" <[EMAIL PROTECTED]> wrote:
> Hey im pretty new to mysql, but I made a basic html form and used p
On Tue, 14 Aug 2001 13:39:48 -0700, "Nate Sanden" <[EMAIL PROTECTED]>
wrote:
>>Hey im pretty new to mysql, but I made a basic html form and used php to post it to
>my mysql database. It goes in fine, but it only carries the first word in each input
>box. So say for "description" I put in "My li
I'm relatively new to MySQL and am drawing up some ideas for writing a
support/trouble tracking database for my company. I envisioned a single
database with seperate tables for various data I would be storing
(IP/Connection info table, Machine Inventory Table, etc). Each table would
have data for
Which Linux 7.0 are you using?
I'll assume you're talking about Redhat. So why don't you just download
the mysql rpm and install it instead of doing it from source?
Good luck,
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
--
At 16:41 Uhr -0400 14.8.2001, Hans Zaunere wrote:
>sort of thing. Would it be better to just switch to TCP/IP sockets?
>
> > > my $dbh = connect("DBI:mysql:database:localhost", "user", "password");
Well it seems like you ARE using INET TCP/IP sockets, since there is
'localhost' there (which go
Werner Stuerenburg <[EMAIL PROTECTED]> on 08/14/2001 11:55:37 PM
Internet mail from:
Please respond to Werner Stuerenburg <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: I blew it big time... locked myself out of mysql
I think it is
grant all on *.* to 'root'@'localhost' id
1 - 100 of 128 matches
Mail list logo
