Re: TCP/IP Security for Remote Access of MySQL DBs...for newbie

Hi Rich, Just so I understand you correctly; 1. Are you trying to use the replication features of MySql for this communication? Or 2. Are you talking on the client side application, like PHP, Java, Perl...? How about encrypting the data itself and skipping the wh

Re: [PHP-DB] any good web hosting with php and mysql support? (OT)

Starting @ $20.00/month http://www.ocsny.com > >-- Original Message -- >From: Gurhan Ozen <[EMAIL PROTECTED]> >Date: Mon, 14 Jan 2002 13:17:59 -0500 > > Hi All, > I am currently looking for a reliable web host to host my personal website. >I know there

Re: mysqldump - basic question

Rory, Take a look at the shell scripts for mysqlbackup here http://www.ocsny.com/main/index.ocs?url=mysqlbackup It will explain things quite nicely. Cheers, m! ROry O'Connor wrote: >this is an absolute newbie question - but when i try to run mysqldump with a cron >(like with a shell scr

Re: Need help with SELECT and JOIN pls

I'm no expert in this in fact I just recently started playing with joins, but here's one that I actually used for a recent shopprt cart piece. I appologise if it wraps but the output is long...content conatins the basic content info but product contains the list of prices. Yes I could have jus

Re: ALTER TABLE error

are you sure you don't want to UPDATE Advertisers SET PACK_KEYS=0;? Steve Osborne wrote: >Can anyone tell me why I am receiving the following error? I am connecting >to a remote server via ssh, and accessed the mysql prompt by typing: mysql > The following is the screen contents after try

Re: Image's

tryt constructing a URL like file:///images/110101/yourpic.jpg out of the location... [EMAIL PROTECTED] wrote: >Either the coffee is flat or someone switched to decafe on me. > >What is the proper way to retrive an image that is stored as a path in a >field name with SQL? > >My path would be so

Re: conceptual question.

Recommend that you store the link/url in lieu of the actual files. cheers, mikel Venu Allavatam wrote: >hello all! >i have a question regarding the storage of data. The >doubt is... >Should the data (mostly binary files) be stored in the >database as a field or a link(a path) to the data be >st

Re: question

Check your grants table in the mysql db...make sure you have given yourself permission to user said db from the specified host as that user... "Wells, Kenneth L" wrote: > How can I fix this? > > Database: mysql_error:Host 'localhost.localdomain' is not allowed to connect > to This mysql server F

Re: How to make apache webserver on a Linux box connect to a remote mySQLdatabase on a separate Sun box

well for starters you should look into updating your grants table, to allowe the remote server to access the db. Don't forget to properly set the userid, password, and perms for this...Highly encourage to grant this id read only access...but that's your call. Then on the prospective webserver m

Re: FreeBSD server help

Kyle, Need a bit more info, what version of mysql? Have you granted the other host(s) permission to use mysql? are you using mysqladmin to stop and start the daemon? cheers, m! Kyle B wrote: > Hi all, > > I am going to try and describe my problem as best as possible. here it goes. > > Am

Re: Unix Shell Auth from MySQL

checkout pam_mysql under the ports collection in fBSD...;) cheers, Mikel Chris Aitken wrote: > Hi, > > Something ive been thinking about for a while but havent been able to come > up with a definitive answer is this... > > Is there a system out there which can take over from the normal

Re: Expect Script accessing MySQL

I'm not up on expect, but I would assume that since you can use sh then you should ber able to use expect. Generally speaking in sh you can do the following: #!/bin/sh MYSQLCMD="/usr/local/bin./mysql" USER="me' HOST="some.host.com" PASSWD="whatever" QUERY="SELECT userId FROM thisTable WHERE id=

Re: ACT2 Conversion

Hi guys, Are we talking about Symantec's ACT product? Cheers, Mikel Rolf Hopkins wrote: > I've never heard of ACT2 but if you can export the data to a delimited text > file, you could import it into mysql. You may have to edit the file a bit > though. > > - Original Message - > Fr

Re: MySQL performances?

Well what exactly do you consider big? Mohamed Sadok MOUHA wrote: > Hi, > does any one used MySQL in real environment with big databases and > a big number of connections? If yes, what's the hardware config? > > Thanks > -- > >

Re: Saving pictures in MySql

Greetings, In most cases you will find that the storage of pictures and mp3's for instance are better left to the host fs rather than the dbs. Then you would only store the link to such files. Some will argue that this slows down access to the perticular file et cettera, blah blah blah...but

Re: Once again... quotas...

At the company I work for we decided to try and implement reverse quotas. rather than limit said user to x we keep track of their usage and compare it to x. If they should happen to exceed that values then they are billed for the overage. It's very muhc like how UU bills us on our bandwidth for th

Re: taxes

core storefront locations...Anyway that's how they do it...not how everyone else does...this make good sense if your host is located in one state...;) ok I think we've veer far enough off course... cheers, mikel Mike Wexler wrote: > Mikel King wrote: > > > > guys I think

Re: taxes

There are sources out there for all of this information and you can get tax > > tables on a CD that can be imported. > > > > Brady... > > > > Original Message Follows > > From: Mikel King <[EMAIL PROTECTED]> > > To: LDL Enterprise <[EMAIL PROTE

Re: taxes

Wound't you just set a table with an id, state_abrev, & tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: > does anyone know how to calculateg taxes for a shop cart that would set the > tax depending on the state that they select when filling

Re: Shell Shocking

Absolutely this is nothing short of bad adminingIbet you could scag in their passwd file and has root access in short order...;( And of course the ISP will blame mysql if anything happens to them though...lazy bad ISP cheers, mikel Donald Korth wrote: > Hello > > The hosting company

Re: Shell Shocking

Problem is that most ISPs can't afford a competent DBA...;( clay bond wrote: > On Tue, 13 Feb 2001, Donald Korth wrote: > > > The hosting company has given me a user name and passwd . When i log into my own >site thro' a telnet session i 'm able to view all the databases created in the server

Re: PHP - working with two MySQL serwers

Or you could (if the two db servers are on the same lan) place a load ballancer before them and the php connection wouldn't really care because the two will look like one...;) Or you could write a connector script that checks the 'health' of each server and then return the connect for that one. c

Re: Port 3306

fwcmd=/sbin/ipfw<... on BSD usage like so ${FWCMD} add deny all from any to any via ${oif} Have to make a new kernel to support ipfw though cheers, mikel [EMAIL PROTECTED] wrote: > What OS? If Linux or *BSD, they have firewall software (ipchains on linux, > don't recall what i

Re: GUI for Linux mySQL

Marko, Check out... http://www.freebsd.org/cgi/url.cgi?ports/databases/mysql-navigator/pkg-descr Also there are a few php as wellas python driven utils out there that make it entirely web based Cheers, Mikel Marko Sarunac wrote: > Is there a GUI for mySQL that will run on either linu

Re: Problem for localhost connection.....

did you edit /etc/resolv.conf? dyu wrote: > Dear all, > > i m running mysql on freebsd webserver and using our own DNS server. > Everything run fine with database and web serving. However, i m trying to > change the DNS ip addresses to our isp's DNS server instead of ours on this > webserver.

Re: MySQL connecting to MSSQL7

If mysql were master then suppose you could use mysqlbackup to dump the mysql db regularly. Then you could do something like a diff on the previous dump and the recent dump to create an imcremetal update for the s7 box. You can mysqlbackup here: http://www.ocsny.com/main/index.ocs?url=mysqlbackup

Re: How to use a database from Sun solaris to Linux

Legeard, You can try this utility; I have never run it on Solaris but since it is based on sh it should run and of course I'd be curious to see how well it does. That asside it uses mysqldump and some shell scripting to auto discover all of the databases in a running mysql system and dump e

Re: Changing a Table name

Of course there is... ALTER TABLE name RENAME newname ; Of course you can find this sort of thing in the manual of even on Quetin Smith's SQL reference site... http://comclub.dyndns.org:8081/sqlref/ Cheers, Mikel Don wrote: > Hi, > > Is there a quick and simple way to change the name of a Tab

Re: OT - Cron

Ade, Try: http://www.ocsny.com/main/index.ocs?url=osl It should have what you need. Cheers, Mikel [EMAIL PROTECTED] wrote: > Hi, > > I`ve been searching for hours now so I thought I`d ask some lists I belong > to, does anyone know of a decent CRON tutorial??? > > TIA > Ade > > --

Re: OT - Cron

Ade, Try: http://www.ocsny.com/main/index.ocs?url=osl It should have what you need. Cheers, Mikel [EMAIL PROTECTED] wrote: > Hi, > > I`ve been searching for hours now so I thought I`d ask some lists I belong > to, does anyone know of a decent CRON tutorial??? > > TIA > Ade > > ---

Re: Drop Database

Hi David, Have you tried DROP DATABASE "\#Muffin" ; ? Cheers, Mikel David Lidström wrote: > Hi! > > I was testing some queries and now I've created a database > named "#Muffin", and I cannot drop it! > > I've tried the following: > DROP DATABASE #Muffin > DROP DATABASE '#Muffin' >

Re: Corrupted tables

I've had some db corruption on a few occasions, and luckily I was running the following in a nightly cron...it has since first install saved my butt on many an occasion. http://www.ocsny.com/main/index.ocs?url=mysqlbackup It doesn't do anything magickal just uses mysqldump and a basic routine to a

Re: Starting MySQL

Carlos; Carlos Corzo wrote: > OK, > > I am just a bit confused still so I will try again. Do I need to stop mysql as it > is running now before I start safe_mysql or will it just replace the current > running version? Also, does it matter where I start it from? I can telnet to the > server, e

Re: Starting MySQL

Yes stop the old and start the new...on a side note...should have bought DuBios's book...ISBN: 0-7357-0921-1 Found it to be an invaluable source on this sort of stuff. In any event safe_mysqld seems to be default on most sytems...Yes please get you security straight...if the app is colocated on th

Re: date_format

Hi Cindy, This might help... http://www.upan.org/rtfm/strftime.html Cheers, Mikel Cindy wrote: > OK. I went to the documentation at www.mysql.com and typed in > DATE_FORMAT in the search box, hopefully find a list of the %M's, etc > rules that may be used (I'd like December to become Dec,

Re: ISAM to MYISAM

Aaron, I sugest that you use this app, http://www.ocsny.com/main/index.ocs?url=mysqlbackup and then use the dumped files on the new server to rebuild you db you could quite conceivably br up within 2 hours... Cheers, Mikel Aaron Schlesinger wrote: > I've noticed that most of the reall

Re: Please read the manual

In order to conserver bw I'll only through my $0.01 in...;) I do believe that if you search the list you will see that many of us who are not on the devteam do answer questions. Although I do whole heartedly believe in RTFM; I agree with you about the power of the people, and feel it is important