it up as a dedicated MySQL dbase server. It looks good, but,
want to know if anyone has any experience with this machine.
It will run Linux, since RH is installed.
TIA.
Best Regards,
Van
--
=
Linux rocks!!! http
-11122
http://www.beaconet.net
Aftab:
To my knowledge, such a port doesn't exist.
Why would anyone want such access without authentication?
Just curious.
Van
--
=
Linux rocks!!! http://www.dedserius.com
Andreas Vierengel wrote:
Try option --skip-grant-tables to mysqld or in mysql.cnf.
This will dectivate ALL authorization-checking, but will make the server a
little bit faster...
--Andy
Andy:
Not very secure, I'd argue.
Van
the most viable way
to keep servers up, secured, and complete. What inspires this most is uptime.
There are MySQL means to do this without shutting the server down, if there are
additional servers to play with. If I'm off-base, I apologize.
Regards,
Van
pretty big and busy dbase. That load's gonna kill the
machine over time. What's the temperature on that thing?
Van
--
=
Linux rocks!!! http
ception to their admin account. Tell them to set
the root password, also.
Hope that helps.
Van
--
=
Linux rocks
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
--
=
Linux rocks!!! http://www.dedserius.com
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,
Van
-
Cathy:
Please, refer to the manual. There's no successful career path for a hand-held
dba.
This is basic:
http://www.mysql.com/doc/A/c/Access_denied.html
Van
Greetings:
Anyone else getting lists messages from several days, or longer ago?
Phrrrp!: sql database table mysql
Van
--
=
Linux rocks!!! http://www.dedserius.com
-
Create .my.cnf in your home directory with:
[client]
user = username
password = real-big-secret
Van
--
=
Linux rocks!!! http://www.dedserius.com
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 -pbig_secret'
It gets me in ok. Van suggested the mysql way putting this in a .my.cnf
file in my home directory.
[client]
user=username
password
periods in it's implementation, I'd look at correcting that
before trying to think about 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
be found at php.net.
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
-
Before posting
discussions if you don't mind.
Thx,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
-
Before posting
using the ip address.
Has anyone done this before?
Certainly.
Thanks,
John Hunter
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
record update on the master attempted to replicate
to the slave the data was read-only so it couldn't have changed.
Doesn't look like a port-forwarding problem, although there might still be one,
but rather a replication problem.
Regards,
Van
Then, go here: http://lists.mysql.com/php/unsubscribe.php
Or, try using a real MUA.
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
David Busby
... no aspersions. Don't be silly... Just develop your stuff. That's
okay. Perl advocacy in the MySQL list: ot and... that's what I'm talking
about: silly :)
Best Regards,
Van
--
=
Linux rocks!!! http
, table, drop, explain, database--
Best Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
Paul DuBois wrote:
(some stuff I snipped)
http://www.kitebird.com/mysql
. But, since the DOJ and the current
administration refuse to enforce the law on M$, someone must. Hopefully, you
guys across the drink can assist us coders in the U.S. to rid the planet of this
useless software company before there's no longer any reason to code...
Regards,
Van
sql,query
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
://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, regardless.
Regards,
Van
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'm rather new
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 could throw a safety check in place for such events.
Regards,
Van
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.log /tmp/why.log sudo mv /tmp/why.log
/mysql/
mysqladmin
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.
Van
. RedHat has the mysql server on the CD as an RPM. Just install
that...
Van
--
=
Linux rocks!!! http://www.dedserius.com
, as you've stated; use them.
Best Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
D.K.Dubey wrote:
Hi Van,
I read that before sending u the query
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.
Van
it cleanly.
Thanks,
Van
=
Linux rocks!!! http://www.dedserius.com
=
-
Before
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:
Building a web form. There are 3 datetimes: RequestDate, FulfillDate, and
CancelDate.
New record
runs qmail (or, did before the recent outbreak{s}).
Modify as useful.
Best Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
query.
CONCAT() is definitely not supported in MSSQL as of 7.0, and will cause you
problems there, but that's another issue. I'm assuming you're shooting for a
cross-sql capable application. A thought to consider.
Best Regards,
Van
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ www.mysql.com
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 resource. Is my site violating the terms of the trademark?
Van
/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 user dropped the db. Bummer. You should NEVER give
drop db privileges to anyone. Not even yourself. :)
Van
:
Are there files in the database directory? Remove them.
In the directory that holds your dbs:
rm -Rf databasename
Van
--
=
Linux rocks!!! http://www.dedserius.com
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 resource. Is my site violating the terms of the trademark?
Van
create db SSSCA
mysql use mysql;
mysql delete citizen from db;
mysql quit;
mysqladmin -u Bush reload
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
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
--
=
Linux rocks
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
]
snipped
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
--
=
Linux rocks
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 want to build
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 SOME_KEY
LIMIT 0,100
Van
the client specify port 33060:
mysql -P 33060 -h hostname
Van
--
=
Linux rocks!!! http://www.dedserius.com
of 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
:
html
head
titlewoka woka/title
/head
body bgcolor=white
h1woka woka/h1
?
phpinfo();
?
/body
/html
(View source after visiting it...) Again; just a guess, and like I said: wrong
place to post this question.
Good luck.
Van
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.
Van
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 is a non-issue and that this already has been convered
; 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 that too
.
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
-
Before posting, please check:
http
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.dedserius.com
Disregard please...
database,sql,query,table
--
=
Linux rocks!!! http://www.dedserius.com/
=
-
+++
Any ideas?
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
-
Before posting, please
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, 1, 2], [/* 17 vars */]) = 0
...
brk(0x1200ba000)= 0x1200ba000
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 be right after this line {unless you use lookOut mailer
-
Sebastian:
The MySQL end of it is the LIMIT clause.
But, you'll need to do some math manipulation within your web application for
creating forward and backward links, etc. for navigating through the result
set. This is more a php3/cgi question than MySQL.
Regards,
Van
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,sql,query,table
be. Spam cannot be
completely stopped, period. Posting about how poorly the list deals with it is
fairly useless. Including this post you're reading right now...
Regards,
Van
database,sql,query,table
--
=
Linux rocks!!! http
---
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
--
=
Linux rocks
bash-2.04$ for i in `mysql mysql -e 'show tables;'`; do mysql mysql -e describe
$i;; done
Assuming bash as the shell, and os as UNIX, of course...
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
use.
I'll behave Augh!!! So tempted... LOOK OUT!!! Just kidding... :)
Best Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
Alex Shi wrote
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.dedserius.com
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 are needed?
Thanks for any useful thoughts.
Best Regards,
Van
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. :)
Best Regards,
Van
, 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
--
=
Linux rocks!!! http://www.dedserius.com
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
--
=
Linux rocks!!! http://www.ded
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 only noted that mechanism on RedHat
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
--
=
Linux rocks!!! http
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 server: Binlog has bad magic number,
fire your
and all is happy, now.
Van
--
=
Linux rocks!!! http://www.dedserius.com
=
-
Before
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
010319 1:51:41 Error reading packet from server: Binlog has bad magic
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't help
i used apache 1.3.17
mess with
it for a few more days. Not sure what the remaining package is, but, hopefully
when you do your rpm -Uvh's, it will tell you. I'd be interested to know.
BTW, the GLIBC-2.2 was a security fix for all Linux distros.
Regards,
Van
n I
don't send virii.
Just thought I'd pitch in. Doesn't really seem rampant.
Regards,
Van
--
=
Linux rocks!!! http
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 web
context.
This is just how I do it, but, others might have different imple
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
--
=
Linux rocks!!! http://www.dedserius.com
. They're
not getting anywhere, anyway. They'd have better chances finding a way to break
the web server.
The biggest concerns are the lpd, named, ftp, rpc, and, now ntp daemons. If
you don't need 'em don't use 'em. If you do, firewall them and restrict access
to your own hosts/networks.
Best Re
somestuff
FROM sometable
set @end = curtime();
set @elapsed = TIME_TO_SEC(@end) - TIME_TO_SEC(@start);
select @start, @end, @elapsed;
Van
--
=
Linux rocks!!! http://www.ded
'localhost', 'phil', 'phil',
'y', 'y', 'y', 'y', 'y', 'y', 'n', 'y', 'y', 'y')
mysqladmin reload.
Of course you can use the grant command, too, but, this works better for me.
Note that the db privs doesn't not give this user (Phil) grant privs.
Re
to your system.
Hope that gives some insight. BTW, the package I built for the Alpha is still
running to this day, so I'd be curious to hear that some of the files were
omitted. If anything, there should have been more than necessary (src included
for instance).
Regards,
Van
comme NLS tendu (support de langue
maternelle) est avec des Windows. Vous pourriez devoir compiler MySQL vous-mme
avec un compilateur des Windows C pour que ceci travaille, bien que, je ne sache
pas.
Respects,
Van
Mr/Mme Hello,
I have a precise question: How to code them
special characters
diverses listes ainsi tout pourrait
bénéficier. Juste une suggestion.
En particulier, puisque le poteau initial a dû faire avec Windows-MySQL et le
jeu de caractères français.
Salut,
Van
Greetings Ken:
Perhaps this is overkill, but, one of the downsides of spreading these
conversations across
and one Linux entry in your Lilo boot
selection menu. Install the boot-loader to the MBR, and it should work fine.
Van
--
=
Linux rocks!!! http://www.dedserius.com
would
suffice, i.e.: My_Column, instead of `My Column`. Would make the statement:
Please insert $1MM into My_Account more understandable and efficient to
process.
Spaces, should be avoided in `Column Names` and in File\ Names.
Regards,
Van
there one the http://www.mysql.com/ web-site.
Download it here:
http://download.sourceforge.net/pub/mirrors/mysql/Downloads/MyODBC/
Van
--
=
Linux rocks!!! http://www.dedserius.com
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
=
-
Before posting, please
know where the problem could
be.
Give it a shot. You might be surprized that you'll receive some useful info to
help you fix the problem.
Best Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
the
registry looking for references to the drive letter for mysql data. Not sure if
mysql uses the registry, but, probably does.
Wouldn't have shed my ignorance on this topic, but, weekends tend to be slow
volume, so I thought I'd try and give a hint.
Regards,
Van
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
=
-
Before posting, please
. Depending on the table structure, shouldn't take more than a couple
hours.
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
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/-Linux rocks
% Mounted on
/dev/hda1 1007960195116761640 21% /
Anyone else know what I need to increase?
Thanks,
Van
--
=
http://www.dedserius.com/-Linux rocks
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
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
. :)
Van
=
http://artists.mp3s.com/artists/113/ded_serius.html
Linux rocks!!! http://www.dedserius.com
=
On Thu, 6 Nov 2003, Jeremy Zawodny wrote:
On Wed
/ 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
=
http
bulls wrote:
dear everybody,
i've got error message when test ./mysqladmin -u root
-h my-host version, but if ./mysql -u root -p , it's
ok.how to solution?.
tank you
=
Bulls:
Try mysqladmin -p -u root version
Van
.
If this is a MySQL issue, please advise. I've no problem with disseminating the
full source to any interested party.
Best Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
redirect , or you may lose
something else. You might want to brush up on the *n*x init process, also.
Just a tip.
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
1 - 100 of 1464 matches
Mail list logo