mysqldump options

2004-10-12 Thread Shannon R.
Is there a way to tell mysqldump to dump all tables in the specified database except certain specified tables? Like maybe: "mysqldump dbname !exclude_this_table > data.sql"? Thanks! Shannon __ Do you Yahoo!? Take Yahoo! Mail with you! Get it o

securing proftpd

2004-08-22 Thread Shannon R.
Is anyone using proftpd's RejectValidShell directive in a box running stable? That is, reject users with valid shells from logging to ftp as soon as they enter their usernames (and not give them the chance to enter their password at all). Support for that is supposed to be in unstable already (htt

Re: ssh and root logins

2004-08-10 Thread Shannon R.
> I've noticed a fair number of attempted root > logins on my various boxes > i only have 1 important box yet i'm getting the same thing also. by the way, won't leaving only "console" in /etc/securetty disallow remote root logins? i did it and my box still accepts remote root logins. any ideas w

IIS worms and apache

2004-08-06 Thread Shannon R.
Is there a debian package wherein the app recognizes IIS worm attacks? Then blocks these IPs in real time? Would also be nice if it'll unblock those IPs after a certain amount of time. Thanks! Shannon __ Do you Yahoo!? Yahoo! Mail Address AutoC

Re: mysql refusing access from other machines

2004-08-02 Thread Shannon R.
yes simply comment it and restart mysqld. > > -achim > > Am Mo, 2004-08-02 um 11.47 schrieb Shannon R.: > > good day all! > > > > > > i'm getting really confused with how to properly > allow > > users to access mysql from other machines. (on &g

mysql refusing access from other machines

2004-08-02 Thread Shannon R.
good day all! i'm getting really confused with how to properly allow users to access mysql from other machines. (on debian woody, using all stable packages) that is, i tried this as mysql root user: GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.* TO [EMAIL PROTECTED] IDENTIFIED BY 'passwor

Re: q re transferring mysql db from redhat to debian

2004-07-27 Thread Shannon R.
--- Henrik Heil <[EMAIL PROTECTED]> wrote: > > The record_ids will stay the same with mysqldump. > What makes you think they will not? Something must have made me think the auto-incremented ids will be re-generated. My bad. > > you could set up replication to keep the databases > in sync unti

q re transferring mysql db from redhat to debian

2004-07-26 Thread Shannon R.
hello list! i'll be moving from a RedHat server to a Debian server very soon. despite the different linux distributions, is it ok to transfer my entire mysql database by just copying everything in /var/lib/mysql of the RedHat system to the Debian system? has anyone tried this before? the reason wh

Re: max requests a celeron web server can handle

2004-07-19 Thread Shannon R.
hi robert, all,     my problem is that i can't run a benchmark because i don't have that machine. it's a managed hosting package im interested in.   the machine will be hosting 1 website only. with about 3,000 static html files and about 5,000 image files (from 3kb to 100kb. and no, it's not a porn

max requests a celeron web server can handle

2004-07-19 Thread Shannon R.
Hello List!     I've been googling around for recorded info on how many static files per second a 1.3GHz Pentium Celeron (1Gb RAM, 7200 RPM IDE hardisk), Apache web server can serve before it starts getting slow. The static files we're talking about here are just small files ranging from a few kilo