Haryana wrote:
> I have a job to make a mail server that store mail
> data in mysql table.
I was under the impression that the MySQL API does not have a
proper BLOB interface. Access to data in a BLOB is limited by the
max_packet parameter and therefore a BLOB larger than that cannot
be retrieve
I have been using languages like Smalltalk, Perl and Java for about 15 years. I am a
huge fan of putting one in the DB for embedded server procedures.
I also beleive the best strategic option for MySQL to continue its adoption in the
Enterprise IT world is to choose Java as this language. Perl i
On Tue, Apr 02, 2002 at 11:07:43PM -0800, Scott Broderick wrote:
> Does anyone know of a good place to start looking at how to mirror a
> MySQL database on two different computers?
Lookup REPLICATION in the on-line manual:
http://www.mysql.com/doc/
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTE
Hello List,
Does mysql support raw device? In this case, two or more mysql servers
could share the same raw device as the backend storage.
On Wed, 3 Apr 2002 17:35:41 +1000
"Paul" <[EMAIL PROTECTED]> wrote:
> Scott,
>
> Try the following perl script to copy the contents of one mysql table fr
Scott,
Try the following perl script to copy the contents of one mysql table from a
mysql database and insert it's contents into another mysql database on a
different host/server/computer under the same table name. Essentially a
mirrored copy. Can be useful in a cron or a shedule as it wont outpu
Hi,
I have a job to make a mail server that store mail data in mysql table.
Currently we used a maildir based mail server, that store each mail data in
one ordinary file.
Therefore, I need some advise in choosing between storing the whole mail
data in one big mysql table, or storing per user mail
Does anyone know of a good place to start looking at how to mirror a MySQL
database on two different computers?
Any help would be great, Thanks
Scott
-
Before posting, please check:
http://www.mysql.com/manual.php (the
On Tue, Apr 02, 2002 at 11:49:10AM +0200, Nico Sabbi wrote:
> HI,
>
> I have two questions:
>
> 1) is there a way to tell my mysql master not to log failed
> executions, such as creation of existing tables, drop of inexistant
> databases etc?
It's been a while since I checked, but it either doe
On Tue, Apr 02, 2002 at 06:20:41PM -0600, Russell E Glaue wrote:
>
> On the mysql-internals mail list we had a thread going about this. I
> was suggesting something like embedding PERL into MySQL to produce
> something like PERL/SQL (similar to PL/SQL in oracle).
> Unfortunately, although promisi
Chuck,
Maybe it's just me, but I'm not sure what you're asking here.
You wrote:
> Hi again i didn't get any feed back regarding MqSql boolean
> field/datatype i note that it is evident in version 4.1 my version is
> 3.23 ok.
http://www.mysql.com/doc/C/o/Column_types.html
BIT
BOOL
>> What would the script look like if I'm on Win2k ?
> Good luck!!
Don't listen to the naysayers
@echo off
set zdate=%date%
set zdate=%zdate: =%
set zdate=%zdate:/=-%
C:\mysql\bin\mysqldump -A > E:\mysqlDataBackup\%zdate%.txt
save as a .bat and put it in the scheduler. Mine runs every hou
From: "Russell E Glaue" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 2:20 AM
> On the mysql-internals mail list we had a thread going about this. I was
> suggesting something like embedding PERL into MySQL to produce something
> like PERL/SQL (similar to PL/SQL in oracle).
> Would anyone
Not yet, but hopefully in 4.1.
Check out http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html.
Craig
sql,query
At 06:07 PM 4/2/2002, you wrote:
>Does any know if mysql has any kind of stored procedures?
>If not, is there any plans on including them?
>
>-matt
---
The queries will be a little complicated using a self join, but the table
is simple should include:
CUSTOMERID
REFERRERID (Which is the CUSTOMERID of their referrer)
CUSTOMERFIRSTNAME
CUSTOMERLASTNAME
ETC!
The queries will then use a self join and table aliases to determine the
commissions for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello Marcus,
i think you forgot the
mysql> flush privileges;
Regards,
Sherwin T. Ang
Web Technical Administrator / Programmer
Alchemy Solutions
http://www.alchemy.com.ph
Creative. Technology.
Tridel Technologies, Inc.
7th Floor Hanston Buildin
Marcus,
Check the options page
http://www.mysql.com/doc/C/o/Command-line_options.html
for the startup option
--skip-grant-tables
and note the instructions about flushing or reloading after you have
restored the root password.
(And, next time, don't get so excited that you forget to check the
Here are some results from what I have tried in a addition to my
previous post.
mysql> GRANT ALL ON *.* TO root@localhost IDENTIFIED BY 'pasword';
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)
mysql> show GRANTS for root@localhost;
+--
Russell E Glaue mentioned:
> On the mysql-internals mail list we had a thread going about this. I was
> suggesting something like embedding PERL into MySQL to produce something
> like PERL/SQL (similar to PL/SQL in oracle).
> Unfortunately, although promising and liked among people of the list,
I was revoking a users access when I accidentally ran the following:
REVOKE all on *.* from root@localhost;
Now I can't seem to get it to work in reverse and grant permission back.
I have reset the server and done the following:
afe_mysqld --skip-grant-tables
mysqladmin -h localhost flush-pr
Hi, I just now signed up for this list a second ago and thought I'd say
howdy to everyone.
I'm not sure what the typical discussions are like on this list, so I'll
go ahead and ask anyhow.
If there is another list that would be better suited to this type of
question, please let me know.
A fr
>Description:
mysql 3.23.49 uses libtool 1.3.5. That version of libtool happens to be broken
on Tru64 4.0F PK3. It fails 17 of 49 tests that come with the libtool package.
libtool 1.4.2 passes all of its tests on this platform. The problem I have
when building mysql 3.23.49 is that libtool does
On the mysql-internals mail list we had a thread going about this. I was
suggesting something like embedding PERL into MySQL to produce something
like PERL/SQL (similar to PL/SQL in oracle).
Unfortunately, although promising and liked among people of the list,
there are no plan right now to devel
Does any know if mysql has any kind of stored procedures?
If not, is there any plans on including them?
-matt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
forgot to mention.
you'll have to use ZIP, since TAR is not available on Windows (unless
you use the previously mentioned software packages).
-RG
On Tue, 2 Apr 2002, Russell E Glaue wrote:
>
> Maybe... after some long hours and many lines. I am not sure. I know it
> won't necessarilly be easy.
Maybe... after some long hours and many lines. I am not sure. I know it
won't necessarilly be easy.
You'd be better off using PERL.
You can download the windows binary of PERL for free. (www.perl.org)
You can install PERL anywhere you want on the system just so long as your
PERL scripts point a
Could I run something similar as a BAT file?
-Original Message-
From: Russell E Glaue <[EMAIL PROTECTED]>
To: Mark Stringham <[EMAIL PROTECTED]>
Cc: Rodney Broom <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Tuesday, April 02, 2002 4:25 PM
Subject: Re: backup databases
Check out cygwin.com. I think it's free. Great for unix guys having to
run on NT.
Dave
On Tue, Apr 02, 2002 at 05:25:15PM -0600, Russell E Glaue wrote:
>
> On Tue, 2 Apr 2002, Mark Stringham wrote:
> >
> > What would the script look like if I'm on Win2k ?
>
> Good luck!!
>
> But seriously; th
On Tue, 2 Apr 2002, Mark Stringham wrote:
>
> What would the script look like if I'm on Win2k ?
Good luck!!
But seriously; there is a $300 software package out there (can't remember
name) that will give your billy-boy OS some unix shell-like capabilities,
including TAR. It was featured in like
What would the script look like if I'm on Win2k ?
Mark
-Original Message-
From: Rodney Broom <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, April 02, 2002 12:22 PM
Subject: Re: backup databases
>From: David McInnis <[EMAIL PROTECTED]>
>
>> Could you share
Hi all,
I d like to now is there any way to optimize mysql table space judging from
the data there is in.
My table can be read only.
I put some arbitrary varchar(x) which ddn t correspond to true max len in
table.
Is there a free gpl tool to diagnose my tables ?
Thanks.
query -> sql
$retval = .= " ".
"- ".$a["title"]."";
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 3:46 PM
To: [EMAIL PROTECTED]
Subject: need some help...
Hey Guys,
I need help indentifiying why I have an error in this line of syntax:
while($a=
Hi all,
I d like to now is there any way to optimize mysql table space judging from
the
data there is in.
My table can be read only.
I put some arbitrary varchar(x) which ddn t correspond to true max len in
table.
Is there a free gpl tool to diagnose my tables ?
Thanks.
___
sounds like you have a problem in your phpmyadmin config file, I forget the syntax I
stopped using phpmyadmin some time ago, but I remember those error messages.
opinion: if the mysql database is on your network, you can try mysql front as a tool
to add databases, tables, users, and everything
i got a problem thats keep on coming and coming, it's like this:
first time i run WINmySqladmin and try to make a database on my localhost
(http:/localhost:82/PHPmyadmin/index), it will give no problem, so i make my
database and connect it to my PHP scripts, so it worked :). But now, when i
re
While this should be on the PHP list, here's the problem. You're not doing a
printf or whatever function that is that replaces %s with values - you're
just assigning the string to $retval. It should look something like:
$retval .= printf(" ...yadayada");
look up the syntax - I never use printf,
Hey Guys,
I need help indentifiying why I have an error in this line of syntax:
while($a=mysql_fetch_array($r)) {
$retval.=" - %s",$a["url"],$a["picurl"],$a["url"],$a["title"])";
}
It just gives me a parse error on the page for the $retval. = line
Thanks!
-
Hello, All:
We have encountered the problem to install Mysql-3.23.49 version on Linux
Redhat 7.1.
1. Run rpm with Mysql-3.23.49a-1.i386.rpm, the installation failed.
2. Gunzip mysql-3.23.49.tar.gz, we got the error: invalid compressed
data--format violated.
Can anyone offer some assistance o
Stéphane,
> I have INVOICE table here is the layout:
>
>
+-+---+--+-+-+--
> --+
> | Field | Type | Null | Key | Default |
Extra
> |
>
+-+---+--+-+-+-
[EMAIL PROTECTED] writes:
>Not sure what to tell you - check to see if you have logging enabled on your
Logging is not enabled.
>
>This is a longshot, but you might have had a corrupted index that
>inaccurately reported 75k records when you really were only at 13k, and
>optimizing the table did s
Hi,listers,
I am using java servlet and mysql to develpe a
application. i am wondering can i put jtable in
session?
Thanks in advance
bin
__
Find, Connect, Date! http://personals.yahoo.ca
---
Im going to take a shot in the dark since I have not messed with ASP in
years
Have you just tried to verify the data is there with a simpler script?
Just do the connection script then the user_check then see if it is
still there. If it was PHP I would be able to find it.
-Original Messa
It's easy shell.
-
#!/usr/bin/bash
DATE=`/usr/bin/date '+%Y%m%d%H%M%S'` # or '+%Y%m%d'
mysqldump -uUsername -pPassword --all-databases > tmp.sql && tar \
-cf MySQL-Backup-${DATE}.tar.gz -z tmp.sql && rm -f tmp.sql
-
-RG
On Tue, 2 Apr 2002, David McInnis wrote:
> Date: Tue, 2 Apr 2002
We use mybackup.pl - a perl script found on sourceforge (well, not
anymore I just looked). It creates a compressed tarball of each
database, with a file for each table. The files can be used with the
mysql client without change to rebuild a table. It also can be setup to
rotate the backups base
How do you set up the server.xml and web.xml files to use connection
pooling in Tomcat using the org.gjt.mm.mysql.Driver JDLC driver (version
mm.mysql-2.0.11)?
I have set up and used a simple data source, but I can't get the pooled
one working - do I need to set it up differently?
Originally, I
Folks,
The database I setup 2 weeks ago was operating fine, if a bit slow. Yesterday, I tried
running the OPTIMIZE TABLE command on it, as recommended on this list for improving
performance.
Yesterday there were 75,000 records in my database.
Today, there are 13,000 records.
Apart from the Op
I granted all privileges to [EMAIL PROTECTED], and everything
worked well.
thanks a bunch,
c.
"Land, Christopher" wrote:
> [EMAIL PROTECTED] -- perhaps?
>
> C:~
>
> -Original Message-
> From: Chris Huisman [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 10:51 AM
> To: mysq
I thank all the people that helped me... was very usefull, I tried each one...
But i'm using ASP with a DSN Connection
Check the code:
Set MyConnection = Server.CreateObject("ADODB.Connection")
MyConnInfo = "DSN=MyDSN;UID=MyUser;PWD=MyPass;"
MyConnection.Open MyConnInfo
SQL = "INSERT INTO user
Sure. Just create a new file called something like mysqlbackup.sh and chmod
it to make it executable. Change any of the vars you want, and it should
work (but remember to update the e-mail part of it to use whatever e-mail
client you want, unless you just want to leave that part out)
This is a cu
I have the following query:
select *, max(event_date) as high, min(event_date) as low from schedule
where event_date between '2002-03-01' and '2003-04-30' group by
week_ending,meeting_id order by name, event_date, start_time
If I order by event_date, start_time, name, I get the proper results.
There is a great page with instructions and binaries for this stuff at
http://www.entropy.ch/software/macosx/
Michael
Bensin Joseph wrote:
> I have MACOSX 10.1.3.
> PHP runs fine with no problem could someone help me install or direct me
> to where i can get instruction of how to install MYSQL
From: David McInnis <[EMAIL PROTECTED]>
> Could you share your script for doing the date thing with the rest of
> us? That sounds useful.
> > From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
> > mysqldump -uUsername -pPassword --all-databases > tmp.sql && tar -cf
> > MySQL-Backup-DATE.tar.gz
I have INVOICE table here is the layout:
+-+---+--+-+-+--
--+
| Field | Type | Null | Key | Default | Extra
|
+-+---+--+-+-+--
--+
| ID
Will you never put your files on the net? If so, what will you expect to
find at the remote server? Your character set?
IMO forget character mapping and use BINARY option at fields creation,
usally the contains will be upercase or lowercase, not both. The only
exeption I can think is to index - or
* Gordon Stewart
> (I'll assume you can do EVERYTHING in PHP as you can in dos... ??)
yes, almost... when you say 'dos', I assume you mean the mysql client
console. There are a couple of things you can do in the client console that
can not be done with the client api... like using \c to cancel a
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
David McInnis
-Original Message-
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:40 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: backup databa
Hello,
I am having a problem connecting to a mysql database.
My url string is as follows:
private static final String url = "jdbc:mysql://localhost:3306/test";
and I call the DriverManager with:
DriverManager.getConnection(url, userName, password);
The output of this is:
--SQLException--
Hi all,
I hope I am not too far off the topic here. I actually need help with cgi,
and mysql.
Please refer to the this file to see the program itself:
http://www.jhanna.com/ExtraPage4.txt
What I need to do is to break apart the subroutine, and do some
manupulations on it before displaying the out
I regularly back up all my databases with mysqldump:
mysqldump -uUsername -pPassword --all-databases > tmp.sql && tar -cf
MySQL-Backup-DATE.tar.gz -z tmp.sql && rm -f tmp.sql
I use a script (to determine DATE) in conjunction with cron to back all
databases up nightly, and I also have the script
We use mysqldump.
It is fast and easy. restoration is not hard.
If you want more a more percise restoration option, look at using the
change-log. It wil allow you to revert back in time to a state of the DB.
-RG
On Tue, 2 Apr 2002, Kory Wheatley wrote:
> Date: Tue, 02 Apr 2002 11:26:58 -0700
>
Assuming you have the developer tools installed, it compiles just fine:
./configure
make
make install
if you don't have the dev tools, check VersionTracker. Someone probably
has the binaries packaged up.
On Tuesday, April 2, 2002, at 01:11 PM, Bensin Joseph wrote:
> I have MACOSX 10.1.3.
> P
What is the best method to backup all your MYSQL DATBASES with not a lot
of down time. I have read about using "mysqlhotcopy" and "mysqldump"
are these the best methods. Also what procedure is followed in backing
up the databases. I'm basically looking for the must accurate and
reliable way of
How about newsgroups for php? They have a couple on php/mysql I
believe and they respond quite quickly... Look at php.net
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 12:12 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE:
Here's a good one:
http://www.xmbforum.com/
-Original Message-
From: Javier Gloria [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 11:27 AM
To: mysql
Subject: mysql forum
Hi everybody:
where i can find a forum than works with php,mysql. for my site. or the
source code for o
Hi all,
I have a mysql table, which gives the error read-only when I use LOAD DATA
INFILE command. How do I change this, I read the online manaul with no
success.
Thanks.
-
Valerie Brooks
Fujitsu Software
3055 Orchard Dr.
Sa
I have MACOSX 10.1.3.
PHP runs fine with no problem could someone help me install or direct
me to where i can get instruction of how to install MYSQL on my
machine please.
-
Before posting, please check:
http://www.mysql.com
Hi,
I just installed MySQL 3.23.49 on NT and executed the following
commands:
UPDATE USER SET password=password("test1") WHERE host="localhost";
UPDATE USER SET password=password("test1") WHERE host="%";
Now, after doing 'mysqladmin reload', I cannot connect...
> mysql -p
> Enter password:
From: Curtis Maurand <[EMAIL PROTECTED]>
> y'all are kidding, right?
http://www.google.com/technology/pigeonrank.html
---
Rodney Broom
Programmer: Desert.Net
sql
-
Before posting, please check:
http://www.mysql.com/ma
you can try http://phpnuke.org
Thank You
<><><><><><><><><><><><><><><><>
Daniel Negrón
Lotus Notes Administrator / Developer
KB Electronics, Inc.
954.346.4900x122
http://www.kbelectronics.com
<><><><><><><><><><><><><><><><>
|+>
|| Javier
y'all are kidding, right?
On Mon, 1 Apr 2002, Dan Zarrella wrote:
> i've read the bit on google about thier pigeon rank thing, sounds like a
> cross between reality and alittle aprils' fools to me, either way id
> apreciate a better explanation of this technology and how it may be
> implem
I want to use MySQL to connect to a UniData database and 'replicate' (via ODBC)
some UniData tables. Has anyone used MySQL in this way? Do I need MySQL and
MyODBC?
-
Before posting, please check:
http://www.mysql.com/manual
Hi everybody:
where i can find a forum than works with php,mysql. for my site. or the
source code for one.
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
From: Lee, Andrew <[EMAIL PROTECTED]>
> If user_id and passwd are fields in your table and the passwd field is
> encrypted :
> SELECT user_id FROM user WHERE passwd = PASSWORD('plaintext_user_pass')
Woops, I was typing too fast Ramiro. Andrew's query is right and mine is wrong.
---
Rodney Broom
From: Kenneth Hylton <[EMAIL PROTECTED]>
> Basically, if you encrypt the password, then you have to look it up using
> the password function, too.
What he means is this:
SELECT user_id FROM user WHERE PASSWORD(user_pass) = PASSWORD('my_var')
---
Rodney Broom
Programmer: Desert.Net
sql
--
--- Ramiro Varandas Jr <[EMAIL PROTECTED]>
wrote:
> I think that this question might be kinda of stupid
> for all of you but I
> couldn't find a good answer... When we use the MySQL
> internal function -
> Password('string') - MySQL inserts that string
> codified into the database, so
> that
If user_id and passwd are fields in your table and the passwd field is
encrypted :
SELECT user_id FROM user WHERE passwd = PASSWORD('plaintext_user_pass')
> -Original Message-
> From: Ramiro Varandas Jr [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 11:49 AM
> To: [EMAIL PRO
Okay, here's a hint...
4.2.9 in the manual (;o)
Basically, if you encrypt the password, then you have to look it up using
the password function, too.
Ken Hylton
Programmer Analyst IV
LEC Systems & Programming
Billing Concepts, Inc.
7411 John Smith Drive
San Antonio, Texas 78229-4898
(210) 949
I think that this question might be kinda of stupid for all of you but I
couldn't find a good answer... When we use the MySQL internal function -
Password('string') - MySQL inserts that string codified into the database, so
that people that look for that doesn't know the real password. But i h
A few weeks ago, my mysql 3.23.46 server spontaneously started changing
its data directory to /var/tmp/ once or twice a week, and once or twice
a day for a short span. Nothing in the error file. Anyone seen anything
like this or have any idea what's going on? I changed the data directory
to a
Hi everyone,
I am trying to understand what's going on here and I hope you can help me.
The swe7 characters set in swe7.conf has some really strange mappings in it.
For instance, the to_upper array maps ASCII 0x7E (a tilde) to 0x5E (a "hat"
aka Ctrl character). Why doesn't a tilde remain a tilde?
Hello everybody,
I am running mysql-3.23.41 on FreeBSD 4.5, and everytime I use myisamchk I
get the following error:
><
[root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.*
myisamchk: error: '/opt/db/mysql/netcard/d_usuario.MYD' doesn't have a
correct index
Hello everybody,
I am running mysql-3.23.47 on FreeBSD 4.5, and everytime I use myisamchk I
get the following error:
><
[root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.*
myisamchk: error: '/opt/db/mysql/netcard/d_usuario.MYD' doesn't have a
correct index
On Tue, Apr 02, 2002 at 08:53:27AM -0600, Rick Emery wrote:
> What happened when you tried this experiment?
I just did the following:
In one client connection, issued 'lock tables outgoing write'.
Then in another client connection, tried to do an 'insert delayed' without
specifying the timestam
I have setup replication between two servers. Everything works great.
I wanted to change the location of the bin-log file. I tried
'log-bin=/somedirectory/replication.log' but I get this error
'replication.1 not found (Errcode: 2)'. I took this from the manual:
|--
At this 09:33 2/04/02 +0200 Roger Baklund told us all something interesting :-
>* Gordon Stewart
>[...]
> > http://homepages.slingshot.co.nz/~gordon52/3.txt
>[...]
> >while ( $row = mysql_fetch_array($result) ) {
> > echo("" . $row["JokeText"] . "");
>[...]
> > But how do i list the ac
Liivar,
Tuesday, April 02, 2002, 10:52:01 AM, you wrote:
LP> How I can use ',' instead of '.' in a number values in mysql. I changed
LP> charactermap but nothing.
LP> MySQL 3.23.41 RH7.2
No, you can't use ',' in a numeric values. If you want to store data
separated with a ',' you can store as a
soracchi,
Tuesday, April 02, 2002, 2:55:37 PM, you wrote:
s>Description:
s> when I try to start mysqld I have the following problem:
s> ld.so.1: ./mysqld: fatal: libz.so.1: open failed: No such file or directory
Seems it's not a bug, looks like that zlib is not installed on your
box.
Bob,
Tuesday, April 02, 2002, 12:49:55 AM, you wrote:
BL> ./safe_mysqld --user=mysqld --datadir=/db/
BL> ./safe_mysqld --user=mysqld --datadir=/db/
BL> 020401 16:55:04 mysqld started
BL> 020401 16:55:04 /d2/usr2/local/mysql/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
BL>
Everitte,
Monday, April 01, 2002, 11:28:31 PM, you wrote:
Eeoen> I have the 3.23.49 Version of MySQL and it is saying the load data command
Eeoen> does not work with this version. I also read in my book that any version
Eeoen> past 3.22.15 should be able to complete this function. Please advise
jim,
Tuesday, April 02, 2002, 2:54:13 PM, you wrote:
jalf> I have a table that recieves raw data form results for an online quiz. The
jalf> boss wants to analyse the data , I have it all going to one table for
jalf> processing. From that table of "Raw Data" I pick out what I need. I want to
jalf>
Carl,
Tuesday, April 02, 2002, 2:54:45 AM, you wrote:
CWK> I downloaded mysqlgui linux semi static binary and installed it. I copy
CWK> my.cnf to ~/.my.cnf. I set the user name to my user. When I start it up
CWK> it prompts for password then indicates that it can't connect. I am using
CWK> the s
Zack,
Saturday, March 30, 2002, 10:52:40 PM, you wrote:
That appears to be a PHP script problem, not MySQL one. But first try
to upgrade MySQL to 3.23.49a and see how the behavior changes.
ZA> Hey, I'm having MySQL exhibit some really weird behavior. I am running
ZA> 3.23.41 on OS X. I'm tryin
Marek,
Tuesday, April 02, 2002, 3:20:45 PM, you wrote:
MW> Where is stored and/or how to remove history of command line in mysql client
connected to the server ?
If the variable MYSQL_HISTFILE is set, history is written in the file this
var points to.
In other case history is written in ~/.my
Hytham,
Monday, April 01, 2002, 9:29:40 PM, you wrote:
HS> how can i use arabic language in the mysql tables data, my data in the
HS> table looks like Extended Ascii, and it is re-interpreted in windows
HS> programs - as MySQLMaker - into arabic, how can i let MySQL itself
HS> understand arab
Andrew,
Tuesday, April 02, 2002, 10:06:42 AM, you wrote:
A> I keep on getting the following error message when trying to connect to
A> MySQL - ERROR 2002: Can't connect to local MySQL server through socket
A> '/var/lib/mysql/mysql.sock'
A> This can be fixed by creating a link from the /tmp/mys
Have you looked at mysqlmanager?
It is still being developed and I am told it should not be used other than
for testing MySQL. There is a mysqlmanagerc (client) app that goes with
it. It looks like it is being made to execute commands remotely.
I am waiting for someone to tell me what 'bin/mysq
Currently there is no built-in straight-forward methods to authenticate
against LDAP Directories. However, I have heard from others who have
compiled OpenLDAP using MySQL as a back-end database.
OpenLDAP: I do not know if the possibility exists to replicate the
MySQL tables storing the Op
You can use the LIMIT clause to break up a long DELETE into a series of shorter ones,
executed in a loop.
So, in pseudo-code:
Set delete_row_max = 1000 (or another appropriate value)
do
{
DELETE FROM outgoing
WHERE timestamp < last_time
LIMIT delete_row_max;
row_count = no. of
perhaps you can run this more frequently, say once an hour if
it does not interfere with your application logic.
> -Original Message-
> From: Viraj Alankar [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 4:57 PM
> To: [EMAIL PROTECTED]
> Subject: help optimizing log table delet
Hello,
We have an 'outgoing' table being used to store email header information
defined as follows:
CREATE TABLE outgoing (
rpath varchar(80) default NULL,
auth varchar(80) NOT NULL default '',
ip varchar(80) default NULL,
hfrom varchar(80) default NULL,
hto varchar(80) default NULL,
What happened when you tried this experiment?
-Original Message-
From: Viraj Alankar [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 8:50 AM
To: [EMAIL PROTECTED]
Subject: insert delayed and timestamps
Hello,
When using 'insert delayed' syntax and there is a timestamp field in
1 - 100 of 119 matches
Mail list logo
