t affecting other db writes during this operation?
Thanks,
Van
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ysql server, which will
accept the db update and render via a php script this list (song, number
plays, skip count, etc.) as an include for publication from other pages
on this site.
Anyone started on such a thing?
If not, and anyone else interested, I'll post my final mo
3s/SeemsIllUnpluggedMixed.mp3 | 2 |
| Seems I'll | Song | Wasted Tears|
mp3/mp3s/seemsill.mp3 | 2 |
+----+--+-+-+-+
The count should be 3, right? What gives?
Thanks,
Van
==
ed Tears| mp3/mp3s/seemsill.mp3 |
++-+-+
So, here the listing is the group of records I want and there are 3, and
it's distinct.
Why when I put the group on this query (which is what I need) does it
double
Tom:
The second
file_details.FileName NOT LIKE '%_ds.php3'
Was the culprit. Not a horrible explanation at all.
Thanks for the extra pair of eyes!
Regards,
Van
=
http://www.dedserius.com/-L
fect anyone who don't run windows and esp. Look Out!!!
MUA.
Nuf said?
Thanks,
Van
sql create table, mysqladmin drop mysql
=
Linux rocks!!! http://www.dedserius.com
DEC Alpha. >:)
Van
=
http://artists.mp3s.com/artists/113/ded_serius.html
Linux rocks!!! http://www.dedserius.com
=
On Thu, 6 Nov 2003, Jeremy Zawodny wro
t the disk / controller. INSERT = the
need for disk speed. The CPU doesn't really have to process much unless it's
IDE, and even then it would be minimal.
Somewhat correct? In other words, I wouldn't take your bet.
Van
=
test
--
=
- Linux rocks!!! http://www.dedserius.com/
=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
test disregard
--
=
- Linux rocks!!! http://www.dedserius.com/
=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
--
=
- Linux rocks!!! http://www.dedserius.com/
=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
appropriate for this? i.e. does
SELECT FIND_IN_SET("str2find", field_with_0-n_of_str2find);
> 0
Is that efficient for inserting/updating large rowsets?
Thanks,
Van
--
=
http://www.dedserius.com/-
ocks Used Available Use% Mounted on
/dev/hda1 1007960195116761640 21% /
Anyone else know what I need to increase?
Thanks,
Van
--
=
http://www.dedserius.com/
Never Mind:
I set in /etc/my.cnf
max_heap_table_size = 256M
and, all is good.
Van
--
=
http://www.dedserius.com/-Linux rocks!!!
=
Van wrote
What are your permissions on /tmp ?
should be:
drwxrwxrwt 3 root wheel 512 Nov 22 14:56 /tmp
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
Kenneth
mailer
you use.
I'll behave Augh!!! So tempted... LOOK OUT!!! Just kidding... >:)
Best Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
===
mysql db -e "select * from test3;" | lpr
Assuming Linux / UNIX, you have a line printer defined and db is the database to
connect to.
Van
--
=
Linux rocks!!! http://www.ded
Greetings:
Anyone else getting lists messages from several days, or longer ago?
Phrrrp!: sql database table mysql
Van
--
=
Linux rocks!!! http://www.dedserius.com
e user and password once.
>
> Thanks very much,
> Jim
>
> -
Create .my.cnf in your home directory with:
[client]
user = username
password = real-big-secret
Van
--
==
James Austin wrote:
>
> I put this line (with no space after the -p) in the .bashrc file and
> sourced it;
>
> alias mysql='mysql -u root -p"big_secret"'
>
> It gets me in ok. Van suggested the mysql way putting this in a .my.cnf
> file in m
ES ON db.* TO test@localhost
IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON db.* TO test2@localhost
IDENTIFIED BY 'some_pass';
Works exactly as detailed in the section in the manual you just read before
seeking clarification. >:)
Van
--
===
out it in MySQL terms (or Oracle, Sybase, DB2,
PostreSQL for that matter). But the 4 grant statements above will give you a DB
that 2 users "own" {have full permissions to except for GRANT}.
Regards,
Van
--
=
Linux roc
ng the most current version of PHP 4.x due to the
recent CERT announcement on the file upload flaw. PHP can be found at php.net.
Regards,
Van
--
=
ySQL implementation discussions if you don't mind.
Thx,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
. Just have the slave connect to the master using the ip address.
>
> Has anyone done this before?
Certainly.
>
> Thanks,
> John Hunter
Regards,
Van
--
===
n situation, regardless.
> changes to update the master, I do not see them on the slave. So it
> appears that it is simply reading the data files that I transferred
> over before restarting master and slave.
Because as soon as the first record update on the master
atty yesterday until... well, I
> could go on, but I won't.
>
> Nick
Actually, Nick; I don't think you're being presumptious, at all. Personally, I
prefer the ASS language since it allows me to access both XML and quasi-PHP APIs
in the same IDE-hole and across har
security:
http://www.mysql.com/doc/G/e/General_security.html
Simply stated: If the host that has your data is not in a room/building that
you have control over (i.e.: you have the keys), you can't have security. But,
the above link will give you some logical security practices, regar
Toni:
The problem is in the grants, not networking:
http://mysql.com/doc/S/H/SHOW_GRANTS.html
Please take a moment to educate yourself on how it works. It's quite
straightforward.
Regards,
Van
--
=
Linux rocks!!!
should be able to give the command to
fix your problem to you.
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
Richard Davidson wrote:
>
> Hi,
> I
the time the command is issued; not the
permissions at the time the mysqld daemon started. Also, there was no message
issued to the error log.
I doubt I'll repeat the mistake, but perhaps someone down the road might.
Perhaps Monty & crew cou
Paul DuBois wrote:
>
> At 13:12 -0700 6/12/02, Van wrote:
> >Greetings:
> >
> >Perhaps a bug, even. After about 5 months my mysql log file grew to over
> >300MBytes and I figured I'd do something about it as follows:
> >tail -n 10 /mysql/why.l
Consider taking a look at the manual:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
Perhaps read parts of it, too.
Fix your PC's date (the current year for most of us is 2002). Many of us who
receive e-mail dated in the past filter it to /dev/null.
n't work, get the binary server or the full
source version. RedHat has the mysql server on the CD as an RPM. Just install
that...
Van
--
tools are right before
you, as you've stated; use them.
Best Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=====
"D.K.Dubey" wrote:
>
>
Toby:
Beyond off-topic, but try Netscape...
If that isn't the cause; check that the web server has been patched for the
chunk-encoding vulnerability that existed on Apache before 1.3.26, which was
released last week.
Otherwise: try and give some more useful details.
Mark S Lowe wrote:
>
> Is there a nifty way to select just that last 100 records with MySQL? In
> Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
> out with MySQL.
>
> Please advise! Thank you!
>
> Mark
SELECT * FROM SOME_TABLE
ORDER BY S
=/home/luser/mysql\
--with-tcp-port=3306
Otherwise from the client specify port 33060:
mysql -P 33060 -h hostname
Van
--
=
L
f this message should clearly indicate their
feelings on this great OSS alternative to MSSQL.
Perhaps M$ is exerting more effort to qwell the OSS competition than they'd like
their stockholders to realize.
Interesting times... Keep at it...
Van
--
=
:
woka woka
woka woka
(View source after visiting it...) Again; just a guess, and like I said: wrong
place to post this question.
Good luck.
Van
--
=
Linux rocks!!! http://www.dedserius.com
Mary:
You can index fields containing NULL values in MyISAM tables, but not ISAM
tables. If you're using ISAM tables, this might explain your performance
issues. There are also other more featured table types, but MyISAM is probably
going to yield the most performance in your application.
Benjamin Pflugmann wrote:
> On Sat 2002-08-24 at 19:21:56 -0400, [EMAIL PROTECTED] wrote:
> > On Sat, 2002-08-24 at 18:38, Van wrote:
>
> > > Just thought I'd pass it along, since I haven't seen Monty and
> > > crew address it.
>
> I think that it
has to be
said.
-sql, query, table, join, union, drop database mysql
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
Marc Hus wrote:
>
> Yeah, I tried th
download a a tool like mysqlgui/mysqlfront and
> use it to load and run the queries.
>
> Sean
Or,
mysql -u username -p password databasename < file.sql
Van
--
=
{In case you
were curious}.
Thanks if anyone's got something that flows from client to MySQL db without ever
hitting disk (of course MySQL uses the disk, but, I
r-less
SQL-compliant features/syntax.
That's why the Progress database was possibly not good enough for NuSphere.
Best Regards,
Van
--
There are also a couple other projects that might be brewing on sourceforge,
but, you'll have to search around a little.
Also, check out Cricket, which is the next evolution of mrtg. They might have
some contributors dealing with this subject.
Hope that giv
PeterWR wrote:
>
> Hi Van,
>
> I have no experience with Progress software.
>
> Once, Progress must have seen their approach as the right way. That they
> sonner or later see a need to change, does not approved the way it is done.
>
> In short term, the "clien
for the
core MySQL application at mysql.com, and, if there's any value in a mysql.org
portal for issues extraneous to the core of mysql, fine, but, with a name that
doesn't dilute the MySQL trademark.
Hope you and the principles at MyS
re hid='$UId' and
(dlgdate >= DATE_SUB(now(), INTERVAL 31 DAY)
and (dlgdate <= '$DlgNow'
and
dialog like '%$rowexpl[expletive]%'))");
PHP application.
Result in this example is successful. No errors.
Start from the
quick applications using it. And,
you and Sinisa are always here. I don't know how you do it. Perhaps, because
you know it has a credible future.
I'd hope Progress could see the light.
Best Regards,
Van
> Regards,
> Monty
>
> PS: Thanks for all support. If anyone thi
he mysql.org product and check for PHP integration under interesting licensing
(not GPL). Not the same licensing as Apache, which could be integrated in
almost anything non-GPL, but makes the ears perk up.
My vote's for Monty an
me the situation.
>
John:
I beg to differ.
This discussion is very relevant to all of our planning, if we use MySQL as a
critical component in our Open Source application(s).
Use a filter.
Regards,
Van
--
=
ems of the money makers at our own expense. Time we
should look at how open we want our own model to be to clients who choose models
of lesser openness. I'd consider slamming the door shut on those who are truly
infected.
Sheesh!
And, no I don't hate Micro$oft for religious reasons.
my tribe of 10 who does this kind of thing to
my kernel from time-to-time. Pima has something nasty happening to his hardware
situation and dies running setiathome randomly. He's been running 57+ days, but
that doesn't mean he's all ther
Mario Witte wrote:
>
> On Fri, Aug 03, 2001 at 03:42:28AM -0700, Van wrote:
> > Mario Witte wrote:
> > Memory or motherboard. How many sticks of RAM do you have in the machine? Are
> > they the same speed (p100/p133, etc.)? What kind of motherboard? Is updatedb
-mm-dd hh:mm:ss ereg check?
Would love to do it cleanly.
Thanks,
Van
=
Linux rocks!!! http://www.dedserius.com
=
--
ng (using space,'/' and '-' or any ohter
> characters as the separators) - you would get an array of numerical values
> where the first one would be years, second one moths an so on.
>
> On Thu 16. August 2001 08:33, Van wrote:
> > Greetings:
> >
&
worm. Please see"; \
echo "http://www.wired.com/news/technology/0,1282,45427,00.html for more
information.")\
|$SENDMAIL -oi -t
}
I realize the MySQL list runs qmail (or, did before the recent outbrea
27;t think the (+) is standard ANSI SQL and is probably not necessary for
your Oracle query. The (+) is unnecessary. Lose it and the query will likely
work in both Oracle and MySQL.
I'm curious why you're not explicitely specifying your OUTER JOIN before the
W
ogo.
Do I need to remove it? I'd rather not, since it's just a link to point people
to a valuable resource. Is my site violating the terms of the trademark?
Van
--
=
Linux rocks!!! http://www.dedserius.com/
==
> truncate it at about a GB.
>
> Regards,
> Gary "SuperID" Huntress
Hi:
So, all your dbs are in /home/mysql/var, right? And, only one of 5500 are gone,
right?
If no, or no, then there's not enough information here to know.
If yes, and yes, then your us
>
> Have I did something wrong?
>
> Best Regards,
> Dennis
>
Dennis:
Are there files in the database directory? Remove them.
In the directory that holds your dbs:
rm -Rf databasename
Van
--
Sinisa Milivojevic wrote:
>
> Van writes:
> >
> > I'm also advertising for MySQL all over my site with the original logo.
> >
> > Do I need to remove it? I'd rather not, since it's just a link to point people
> > to a valuable resourc
v, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv,
Alter_priv) VALUES ('host', 'mydb', 'myuser', 'y', 'y', 'y', 'y', 'y', 'y', 'y
with FreeBSD should be noted. Perhaps, I
should stick with Linux. The BSD was good to a point, but, at times like this,
I have more important things to deal with.
Best Regards,
Van
--
===
Greets All:
I've got the above (subject) build created and, need to free up some space on
the machine. Anyone want it, and, is there a good way to shrink it down or make
a binary package?
Let me know.
Regards
rithm is similar to the Recall algorithm. If so,
what's necessary to do this, and, what are the complications in having each node
be a slave and master and all nodes listen to each node for updates as well as
notifying other nodes when updates ar
Patrick Calkins wrote:
>
> You might want to take a look at this site:
> http://www.phpbuilder.com/columns/tanoviceanu2912.php3
>
> --Patrick
>
Patrick:
Thanks. Read through the whole howto. It looks like that's what I need. Hope
it works with 5 master/slaves.
ewhere out there. If it's all *n*x, most of use use Perl, or PHP to
do any database work. I have no idea what people running MS Servers do with
MySQL. Most of my Windoze clients just pay for MSSQL and use access to do
stuff.
Van
--
==
f
/usr/local/etc/my.cnf
/usr/local/libs/mysql/my.cnf
Or, better yet, in /etc/rc.d/rc.mysql add:
--defaults-file=/etc/my.cnf
Anyone using this, please let me know. I'll play with some of the above options
in the meantime. Pro'ly the lattermost.
TIA,
Regards,
Van
--
==
Van wrote:
> Simple question:
> Where do I put the my.cnf file? It's nowhere on any of the servers except the
> user directories who use it.
>
Disregard above. I've been using mysqld to start the server since 1998. Hadn't
looked into safe_mysqld since I've onl
51:41 Error reading packet from server: Binlog has bad magic number,
fire your magician (read_errno 0,server_errno=65535)
Any thoughts would, obviously, be quite useful?
BTW: The magician is me. So, how do I pink-slip myself? >:)
Best Regards,
Van
--
=
Van wrote:
>
> This one's great:
> /usr/local/libexec/mysqld: ready for connections
> 010319 1:51:41 Slave: connected to master 'pima@scottsdale:3306', replication
> started in log 'FIRST' at position 4
> 010319 1:51:41 Error reading packet from
teven
>
Steven:
Check your compiler. I was getting this when compiling with egcs-2.91.
Upgraded to 2.95.2 and all is happy, now.
Van
--
Van wrote:
>
> Van wrote:
> >
> > This one's great:
> > /usr/local/libexec/mysqld: ready for connections
> > 010319 1:51:41 Slave: connected to master 'pima@scottsdale:3306', replication
> > started in log 'FIRST' at position 4
>
Steven Glogger wrote:
>
> hi van
>
> thank you for responding.
> but i have gcc-2.95.2-149 installed (a suse 7.1 version). so i think this
> isn't the problem...
> i tried several other things:
> i changed to other auth_mysql modules for apache: didn&#
-rw-r--r-- 1 root root 385188 Mar 2 22:06 gettext.tgz
-rw-r--r-- 1 root root 270797 Mar 2 22:07 readline.tgz
There's one other I need to get, but, the server's running and can't mess with
it for a few more days. Not sure w
is an indication
there may be resources out there.
Having worked with Progress, it's really it's own animal, so I'd imagine you'd
have to write your own tools if there are none out in the wild.
Regards,
Van
--
==
never seen this message except in this thread. So, it's only bombarding
people in the thread, as far as I can tell.
'Course I haven't used a Microsoft Mail program since '95 and am quite certain I
don't send virii.
g as user www.
This prevents any users from viewing the source code: i.e. the /www/ files that
contain your perl scripts. This might be an option for you if the perl user can
run as www.www and you can run those perl scripts as user www within the
Done. Now, you're perl scripts will run as user www and nobody on the system
will be able to read the perl scripts unless you add them to the www group.
Something tells me you won't.
Regards,
Van
--
===
you don't need 'em don't use 'em. If you do, firewall them and restrict access
to your own hosts/networks.
Best Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
11:30:44 is the start time
>
set @start = curtime();
SELECT somestuff
FROM sometable
set @end = curtime();
set @elapsed = TIME_TO_SEC(@end) - TIME_TO_SEC(@start);
select @start, @end, @elapsed;
Van
--
=
27;, 'n', 'n', 'n', 'n',
'n', 'n', 'n', 'n', 'n', 'n', 'n')
INSERT INTO db (Host, Db, User, Select_priv,
Insert_priv, Update_priv, Delete_priv, Create_priv, Dro
tends beyond U.S. borders
or this thread would never have started.
mysqladmin create db SSSCA
mysql> use mysql;
mysql> delete citizen from db;
mysql> quit;
mysqladmin -u Bush reload
Regards,
Van
--
=
Jeremy Morano wrote:
>
> Hi,
>
> very simple question.
>
> I would like to save and print the contents of myDESCRIBE table_1;
>
> How would I do this?
Jeremy:
mysql -e 'DESCRIBE table_1;' | lp
Regards,
Van
--
=
Greetings:
Sorry for the off-topic. All bookmarked .il irc servers are currently
unavailable.
If any on the list has an active .il IRC link it would be helpful. (Israeli
BBS-es also useful)
You can post anonymously from safeweb.com at http://www.dedserius.com/guestbook/
Best Regards,
Van
t;
> Error
> SQL-query : [Edit]
>
> Duplicate entry '127' for key 1
>
> I can not insert any more data to this table. This is an important
> issue, please help me to resolve this.
>
Change the field type for key 1 to an int (not a tinyint).
Van
--
==
Greetings:
Not really, but for those unfortunate enough to have a server they can't get
time synchronization via xntp/ntp to work, here's a simple bash script you can
use to keep the machine's time current:
#!/bin/sh
#Tue Oct 30 21:12:14 MST 2001: Van; ntpdate doesn't w
re the chances you're out of disk space?
df
The above command will tell you if you've used up all your disk space on your db
partition.
Van
--
=
Linux rocks!!! http://www.dedserius.com/
have them forwarded off to their
proper owners brand new.
Any other scripts that solve the same problem would be helpful.
TIA.
Regards,
Van
--
=
Linux rocks!!! http://www.dedseriu
Disregard please...
database,sql,query,table
--
=
Linux rocks!!! http://www.dedserius.com/
=
-
B
= 0x1200ba000
--- SIGSEGV (Segmentation fault) ---
+++ killed by SIGSEGV +++
Any ideas?
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
--
Sinisa Milivojevic wrote:
>
> Van writes:
> > Running a Debian kernel 2.4.9 and MySQL 4.0 compiled and appears to be running.
> >
> > vanboers@tempe:~$ strace ./mysqlscan 1 2
> > execve("./mysqlscan", ["./mysqlscan", "
thorough.
The administrivia that shows up at the end of each message is by design to give
people the hint to check the manual before posting; and a quick unsubscribe
reference for the occasional list member who has a nervous breakdown during the
departure-from-the-list process.
Van
(Look, it will
et. This is more a php3/cgi question than MySQL.
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
---
Bernard Chambon wrote:
> 020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more
>than
1024
Bernard:
How come you're not giving your OS more file descriptors?
ulimit problem, perhaps.
Van
database
developers and database programmers building applications who
have at least enough aptitude to use FILTERS!!! of their own, and love the list
despite it's volume.
Spam exists. The moderator(s)/software used by the list is more effective than
it could be
Encoding: 8bit
>
> ---
Could someone please determine what the hell naver.com is trying to accomplish
and ensure they don't succeed?
Thx,
Van
sql, table, grant, mysql
--
===
1 - 100 of 1512 matches
Mail list logo
