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
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 are
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
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
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
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
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
stored.
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 Fatal
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
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
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
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=1
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 -
From:
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
--
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
...
Original Message Follows
From: Mikel King [EMAIL PROTECTED]
To: LDL Enterprise [EMAIL PROTECTED]
CC: *MySQL mail list [EMAIL PROTECTED]
Subject: Re: taxes
Date: Wed, 14 Feb 2001 16:57:35 -0500
Wound't you just set a table with an id, state_abrev, tax columns
the 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 you are making this a way
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
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
that
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
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 it
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
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. Then
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
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 Table
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
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
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
28 matches
Mail list logo
