Can you say codefendant?
David T. Ashley
[EMAIL PROTECTED]
(This e-mail was sent from a
handheld wireless device.)
On Jan 2, 2008, at 5:20 PM, Daevid Vincent [EMAIL PROTECTED] wrote:
Do it anyways. Release it as Open Source. IBM is big into the FOSS
On 12/3/07, Chris Sansom [EMAIL PROTECTED] wrote:
My apologies in advance if this is a bit off topic, but...
On a rather old site we have a dreadful old bulletin board system
based on Matt Wright's WWWBoard - all horrid text files and ancient
Perl code. We want to replace that with a decent
On 11/25/07, Stut [EMAIL PROTECTED] wrote:
David T. Ashley wrote:
I have a table with two integer fields (call them p and q).
When I insert a record with a known p, I want to choose q to be one
larger
than the largest q with that p.
What is the best and most efficient way to do
On 11/25/07, Chris W [EMAIL PROTECTED] wrote:
Stut wrote:
insert into test1 set p = 2, q = (select max(q) + 1 from test1 as tmp
where p = 2)
Probably not very efficient, but it works.
-Stut
Auto increment is much easier to do. If your primary key is made up of
two fields and
Hi Martin,
The easiest way to restore context in this conversation is to go to the
MySQL home page (www.mysql.com), then go to Community, then Lists, then
to look at the archives of the main MySQL mailing list (this one).
I believe at this point that Chris and Stut answered my question
I have a table with two integer fields (call them p and q).
When I insert a record with a known p, I want to choose q to be one larger
than the largest q with that p.
What is the best and most efficient way to do this?
For example, let's say the table contains (p,q):
1,1
1,2
1,3
2,1
2,2
2,3
Hi,
I am developing a large database where the web interface may be shared
among many companies, but the data will generally not be shared. For
the purposes of example, let's call it a bug tracking system such as
Bugzilla. Each company has their own private software bugs.
Many companies may
On 11/19/07, Mohammad wrk [EMAIL PROTECTED] wrote:
Hi,
I'm working on a web 2.0 project that targeting small to medium size
companies for providing business services. Companies simply register to the
site and then start their business by loading their data, sharing and
discussing them with
On a *nix box, it is also traditional to configure IPTABLES or similar to
restrict TCP/UDP connections based on IP and/or adapter.
It seems likely based on your description that the box has two network
connections.
Dave.
On 11/13/07, Michael Dykman [EMAIL PROTECTED] wrote:
In my.cnf, you can
On 11/6/07, mos [EMAIL PROTECTED] wrote:
At 02:18 PM 11/6/2007, Richard Edward Horner wrote:
Hi,
I'm working on a program that will run in the event that tables are
crashed or corrupt. Can anyone recommend a good method for crashing my
tables or corrupting them so I have some test cases?
On 8/23/07, Jason Pruim [EMAIL PROTECTED] wrote:
I am planning on having the database open to customers of mine to
store their mailing addresses on-line, and be able to manage the
records.
Is it safe, to have 1 database with lots of tables? Or am I safer
setting up separate databases for
On 8/23/07, Jason Pruim [EMAIL PROTECTED] wrote:
b)Terminating TCP connections and ensuring that each PHP script
runs to
completion, anyway, and that the database isn't left in an
indeterminate
state due to this.
Dave.
What do you mean by b? If all the connections come from the
On 8/18/07, C K [EMAIL PROTECTED] wrote:
Friends,
I have one question - How to store passwords in MySQL database table in a
secure way so that no one can see the password(understand the password
string)?
It is considered bad security practice to store passwords using reversible
encryption.
On 8/13/07, Jonathan Horne [EMAIL PROTECTED] wrote:
i finally have a real need that i need to sit down and learn the basics of
databases. i need to learn to create a database that i can use to track
assets at my company, and have it be readable/updatable from a web
interface
(and hopefully
On 8/13/07, Jonathan Horne [EMAIL PROTECTED] wrote:
i finally have a real need that i need to sit down and learn the basics of
databases. i need to learn to create a database that i can use to track
assets at my company, and have it be readable/updatable from a web
interface
(and hopefully
You are more altruistic than I can ever be.
Every time I go through a nameless fast-food drive-through (too often, based
on my girth), they offer me a chance to win $1,000 if I complete a survey.
I never take those surveys.
Reasons:
a)If, for example, 10,000 people take the survey and the
You might not need to do this in the way you are suggesting (depending on
your application). I'm not sure why you feel you need to combine the
autoincrement with the hash into the same field. Does it really do harm if
two records have the same hash?
It might work as well to have two separate
On 8/7/07, Boyd Hemphill [EMAIL PROTECTED] wrote:
Suggestions to use a hash are a problem because once you have a few
million rows the likelihood of a collision is quite high if you cannot
afford an error stopping your application. This means that if you write a
trigger (the obvious way to
On 7/10/07, Octavian Rasnita [EMAIL PROTECTED] wrote:
I have exported a database using mysqldump from MySQL 5.0.27, and I have
tried importing it in a MySQL 5.0.41, but it gives the following error:
ERROR 1071 (42000) at line 483: Specified key was too long; max key length
is 1000 bytes
On 7/8/07, Steffan A. Cline [EMAIL PROTECTED] wrote:
I am trying to set up a forum where there are main posts with replies and
replies to replies. Rather than using nested queries in my middleware I am
thinking there has to be some kind of recursive query where I can output
the
results in a
I'd like to do full text search on some fields of some tables, but I'm a bit
confused by the documentation. Questions:
a)How do I set that up?
b)What storage engines are required?
c)Are there any restrictions on mixing and matching tables?
d)Do table locking and transactions work the same?
I'm sending this again, because the server seems to have been down for
several hours, and I'm not sure if it went out.
-
I'd like to do full text search on some fields of some tables, but I'm a bit
confused by the documentation. Questions:
a)How do I set that up (i.e. do I need to use
On 7/6/07, Hiep Nguyen [EMAIL PROTECTED] wrote:
we have warehouses all over U.S. and i just wonder what is the best way to
find out their timezone base on zipcode. Should i buy a database or is
there any function in mysql or php to get timezone base on a zipcode?
I looked at the zipcode
On 7/6/07, John Trammell [EMAIL PROTECTED] wrote:
-Original Message-
From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
Sent: Friday, July 06, 2007 10:51 AM
To: David T. Ashley
Cc: mysql@lists.mysql.com
Subject: Re: zipcode to timezone
i don't think there is any state got 2 timezones
I'm an old Microsoft Access user, so I just need to double-check on this
with MySQL:
I want to relate two tables (let's call them users and priveleges) in a
many:many way. That is, each user may have multiple priveleges, and each
privelege may have multiple users with that privelege.
Here are
On 7/5/07, David T. Ashley [EMAIL PROTECTED] wrote:
a)I'm assuming that under MySQL I have to create a third table that maps
between them? (Let's call it users2priveleges.)
b)I'm assuming that there is nothing special I need to do to get, for
example, all the priveleges with a user (just
If I have a table with rows like this, all varchar:
DOG_LUCY
DOG_CHARLIE
DOG_LASSIE
DOG_XRAY
CAT_MR_BIGGLESWORTH
CAT_SCRATCHER
CAT_WHISTLER
what is the form of a query that will return the rows where the first part
of the string matches?
For example, what if I'd like to return the rows that
On 7/4/07, gary [EMAIL PROTECTED] wrote:
SELECT column FROM table WHERE column LIKE CAT\_%;
Would it be reasonable to assume that if column is indexed, the query
would execute quickly, i.e. I would assume that the indexing would
facilitate this kind of query?
On 7/4/07, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Jul 04), David T. Ashley said:
On 7/4/07, gary [EMAIL PROTECTED] wrote:
SELECT column FROM table WHERE column LIKE CAT\_%;
Would it be reasonable to assume that if column is indexed, the
query would execute quickly
On 6/28/07, Magnus Borg [EMAIL PROTECTED] wrote:
Got strings in the format integer+(char)^0..1, ex 3456, 2323, 2324A,
2324B, ...
I want to order them as they where integers, like:
order by cast(STING as unsigned) desc
But when using that query resulting in error 1292. And the result
On 6/28/07, M5 [EMAIL PROTECTED] wrote:
Not being very strong at math, I have a little problem that I'm not
sure how to solve. Maybe someone can help me.
Basically, given a point (latitude, longitude) and a radius (100
meters) (think circle), I need to compute an equivalent square: That
is,
On 6/27/07, Dave G [EMAIL PROTECTED] wrote:
Queries on this table when it gets large is slow as molasses. I'm
thinking about making a new table for anything with a different test_id
any opinions as to whether this is good or bad?
Hi Dave G.,
We need to know how:
a)How large the table
On 6/27/07, Dave G [EMAIL PROTECTED] wrote:
select payload_time,HEX(processed_data) from data__ProcessedDataFrames
where test_id=18 AND top_level_product_name=DataProduct AND payload_time
11808.74704 AND payload_time 1180564096.24967;
What I'm concerned about is with how much data I will
On 6/27/07, Eddy D. Sanchez [EMAIL PROTECTED] wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
me an opensource
On 6/27/07, Eddy D. Sanchez [EMAIL PROTECTED] wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
me an opensource
In reading the syntax of the CREATE TABLE statement, I'm a little confused
by the two keywords KEY and INDEX.
What does one use when one wants MySQL to arrange the column so that it can
find a given record WHERE column=whatever in approximately O(log N) time?
This is a key, right? MySQL uses
I'd like to represent our organization's chain of command (i.e. who is whose
boss) in a database.
The reason is that in some contexts, my database application needs to know
who can view whose time and project records (and the rule is that anyone
above in the chain of command can, anyone at the
Just speaking as a newbie who has no idea what he is talking about ...
If nobody suggests anything better ...
I've noticed that there is a clear correspondence between table names and
the files that MySQL keeps, i.e.
[EMAIL PROTECTED] dashley]# ls -al /var/lib/mysql/fboprimedevel/
total 7832
On 6/11/07, kalin mintchev [EMAIL PROTECTED] wrote:
hi all...
from http://dev.mysql.com/doc/refman/5.0/en/features.html:
Handles large databases. We use MySQL Server with databases that contain
50 million records. We also know of users who use MySQL Server with 60,000
tables and about
Hi,
I'm implementing a software release database. Users may aribtrarily be
members of groups (a many-to-many mapping), and each software release may
contain multiple files.
I'd like to allow users the maximum flexibility in deciding who may view
what software releases. The most obvious
On 6/5/07, Brent Baisley [EMAIL PROTECTED] wrote:
I think you're missing the concept of a transaction in the database sense.
The idea behind a transaction is that you can perform multiple steps and if
you don't complete all steps, any changes are reversed. The reversal process
is handled by the
On 6/5/07, Baron Schwartz [EMAIL PROTECTED] wrote:
David T. Ashley wrote:
There is no concept that I'm missing. I understand what a transaction
is.
But I just don't want to bothered. My application is simple enough that
bogarting the database until all necessary modifications have been
I decided to go with a simple paradigm for my web-based database. Rather
than transactions, each process locks the entire database while it is
changing something, then unlocks it. This just serializes access (all other
processes will block until the one modifying the database has finished).
On 6/4/07, Gerald L. Clark [EMAIL PROTECTED] wrote:
David T. Ashley wrote:
LOCK TABLE thistable, thattable, theothertable,
goshthislistcangetlongtable;
Do whatever is needed;
UNLOCK TABLES;
You could use a string lock for this.
Thanks for the suggestion. It looks logically correct
On 6/4/07, Jerry Schwartz [EMAIL PROTECTED] wrote:
Whatever you do, make sure that every bit of code that locks multiple
resources locks them in the same order. That's the only way to avoid
deadlocks.
Hi Jerry,
I really appreciate the good advice.
However, my original question is still
Once you issue a LOCK TABLES command, you may not access any tables not
in the LOCK statement. You must lock *ALL* tables you will use, perform
your updates, and then UNLOCK TABLES.
I didn't know that. I reviewed the documentation. Thanks.
OK, then my only remaining question is how many
On 5/15/07, Ratheesh K J [EMAIL PROTECTED] wrote:
Hello all,
I have a requirement of maintaining some secret information in the
database. And this information should not be visible/accessible to any other
person but the owner of the data.
Whilst I know that encryption/decryption is the
On 5/15/07, Mathieu Bruneau [EMAIL PROTECTED] wrote:
Hi, yeah, apparenlty you're running into the 32 bits memory liimt. Note
thta some memory is allocated for the OS so you don't even have the full
4GB of ram you can technically adressesed.
The 64 bits os would increase this limit to 64gb++
On 5/9/07, James Tu [EMAIL PROTECTED] wrote:
The database server and the web server are on separate machines.
Table A contains a record for each user.
Let's say Table B contains 'relationship' information. They can be
of type 'friend' or 'family'.
If a user knows another user, this
On 5/10/07, James Tu [EMAIL PROTECTED] wrote:
I think b/c of the way the tables are designed, I have to perform
multiple queries, unfortunately.
Hi James,
My suggestion to you would be that if you have a situation you don't believe
you can handle in one query, post all the details to the
On 5/10/07, James Tu [EMAIL PROTECTED] wrote:
David:
I definitely can get the result set using one query, but what I do
with the result set has me thinking about breaking it up into two
queries.
Technical Details Omitted
Ah, OK, I misunderstood. You want to (get two results, each of which
On 4/25/07, Daevid Vincent [EMAIL PROTECTED] wrote:
A co-worker sent this to me, thought I'd pass it along here. We do tons of
failover/replication and would be eager to see mySQL implment the Google
patches in the stock distribution. If anyone needs mission critical,
scaleable, and failover
On 4/25/07, mos [EMAIL PROTECTED] wrote:
At 02:36 PM 4/25/2007, you wrote:
On 4/25/07, Daevid Vincent [EMAIL PROTECTED] wrote:
A co-worker sent this to me, thought I'd pass it along here. We do tons
of
failover/replication and would be eager to see mySQL implment the Google
patches in the
On 4/17/07, John Comerford [EMAIL PROTECTED] wrote:
Hi Folks,
A) One character string contain a string I build with the date and
milliseconds tagged onto the end
b) Two separate fields Field1 TimeStamp Field2 Milliseconds
I am leaning towards approach B, but saying that it's more gut
On 4/18/07, Tim Lucia [EMAIL PROTECTED] wrote:
-Original Message-
From: John Comerford [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 17, 2007 10:50 PM
To: mysql@lists.mysql.com
Subject: Millisecond time stamp
Hi Folks,
I am putting together a table to hold log entries. I was going
I have a box where I'm forced to use PHP before 64-bit integers became
standard ...
If I run a MySQL query where one of the fields returned is 64-bit integer,
how do I get this into PHP as a string? My recollection is that in the
PHP result sets it auto types so that it is an integer, and
I'd like to have a table in MySQL with the key field being a 12-character
text string consisting of digits and upper-case letters (minus the vowels
and Y, to prevent accidental bad words), i.e. something like:
XM39C6B4...
When I do queries and get back result sets sorted on this text string, is
On 2/28/07, Chris McKeever [EMAIL PROTECTED] wrote:
Does anyone have any resources, guides, insight into the best practice
for storing date/time information when developing a custom web app?
I am mainly concerned with how the TZ should be stored? Should it go
in as UTC and the code accounts
On 1/4/07, Daniel Kiss [EMAIL PROTECTED] wrote:
Hi All,
I'm designing a database where it is required for each row in a table to
have a unique identifier accross a bunch of running MySQL servers on a
network.
I'm considering two options:
1. Have a two-column primary key, where the first
On 12/18/06, Peter Smith [EMAIL PROTECTED] wrote:
Hello MySQLers,
Since I'm mildly technical and I know how to spell orakle,
I've been asked to write up some technical interview questions
for a MySQL position at a startup.
Can any of you help me out?
Your apparent focus on doing what is
On 12/17/06, Mike Duffy [EMAIL PROTECTED] wrote:
I am sure this question has probably been asked in this group before, but
I would like to get an
updated answer.
If you were building your own boxes to run clustered MySQL servers, how
would you configure the
boxes? (This would of course be for
On 11/27/06, Nicholas Vettese [EMAIL PROTECTED] wrote:
I am looking for a book that will help me understand PHP/MySQL, and the
way that they work together. My biggest problem is multi-valued
selections, and INSERTING them into the database. A book with great
examples like that would be a huge
Has anyone ever written C-language CGI-BIN programs (to be executed from
Apache) and which use the C-language interface of MySQL?
Does it work OK?
Thanks.
What happens if I use the C API of MySQL and the process dies (maybe a
pointer error or something)?
a)Will the connection be killed automatically?
b)What about LOCK TABLES and similar statements that were issued ... will
the locks clear automatically?
Thanks.
Hi,
I'm a little bit lost on MySQL statements.
I am implementing a many:many relationship using a string (wrong way, I
know, but I'm trying to keep the design simple and this is a trivial
application).
In a VARCHAR field, I will store a comma-delimited set of integers
corresponding to the
it should work.
Dan
On 11/4/06, David T. Ashley [EMAIL PROTECTED] wrote:
Hi,
I'm a little bit lost on MySQL statements.
I am implementing a many:many relationship using a string (wrong way, I
know, but I'm trying to keep the design simple and this is a trivial
application).
In a VARCHAR
On 8/7/06, James Tu [EMAIL PROTECTED] wrote:
If I create a table for each user (I can potentially have hundreds of
thousands of users), will MySQL be able to handle this?
If I just have one table, I could potentially have millions of
records in one table. Will MySQL be able to handle this?
On 8/6/06, Chris W [EMAIL PROTECTED] wrote:
David T. Ashley wrote:
Can I just write something like:
SELECT * FROM mytable WHERE fieldofinterestvalue ORDER BY MIN(field1,
field2) ASC;
I think this will work..
SELECT *, IF(a-b 0,a, b) as SortField
FROM table
WHERE whatever
ORDER
Hi,
I have a table and I'd like to do a SELECT query with the result ordered by
the minimum of two fields. I might also like to query by the minimum (but
that is an easier problem, as I can just rephrase it as an OR).
Can I just write something like:
SELECT * FROM mytable WHERE
Nigel wrote:
mod_php will persist the MySQL connection holding open any lock or
syncronisation token obtained through any of the three methods :
begin/commit, lock/unlock tables or get_lock/release_lock. PHP does
ensure that even in the event of timeouts or fatal errors any shutdown
Hi,
I'm doing a PHP application, and there are just a few instances where I need
to do atomic operations on more than one table at a time and I can't express
what I want to do as a single SQL statement.
What I'm trying to guard against, naturally, is race conditions when more
than one process is
Nigel wrote:
If you can't or won't do this properly by using a transactional table
and begin/commit at least look at using get_lock() based guard
conditions which only lock a string leaving the database accessable.
Whatever you do if you client is php install a shutdown handler to clean
up
I'm using PHP, and I sometimes INSERT new records in a table. MySQL assigns
a new autoincrement int field on each INSERT ... nothing surprising there.
It goes 1, 2, 3, etc.
What query can I use to find out what value this int autoincrement assigned
field was? I could of course SELECT based on
There is a technique called unit cancellation that may serve you well.
The technique is essentially to treat each unit as an orthogonal vector
(orthogonal to all other units), so one unit can't be mixed with any other
unit.
The only way to convert is to multiply by various forms of 1. 1 is a
I am slowly considering leaving GoDaddy, who has a very good bandwidth and
ok tech support (I have seen better but much much worse) and acceptable
prices, but unfortunately does not support MySQL 5 and PHP 5 either.
SNIP
Who think we could make them make the right move and pretty quickly?
Hi,
I'm a beginning MySQL user ...
I have a table of log entries. Over time, the entries could grow to be
numerous. I'm like to trim them to a reasonable number.
Is there a query that will, say, trim a table down to a million rows (with
some sort order, of course, as I'm interested in
, i.e.
192.168.0.10 would become 19216810.
b)Store the IP as a 64-bit integer.
I think MySQL will key on strings, right?
Dave.
---
David T. Ashley ([EMAIL PROTECTED])
Thousand Feet Consulting, LLC
--
MySQL General Mailing List
For list archives: http
.
---
David T. Ashley ([EMAIL PROTECTED])
Thousand Feet Consulting, LLC
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tue, February 7, 2006 10:46 am, [EMAIL PROTECTED] wrote:
David T. Ashley [EMAIL PROTECTED] wrote on 07/02/2006 14:03:04:
a)Will MySQL allow joins that involve more than two tables (in my case,
perhaps as many as 5)?
b)Can limits on a key field be included in the join in the same SQL
the integer field reaches 2^32-1 or whatever the upper limit is, what
happens then? Will it try to reuse available values from records that
have been deleted? Or is it always an error?
Thanks, Dave.
---
David T. Ashley ([EMAIL PROTECTED])
Thousand Feet Consulting, LLC
I am building a database with permissions for different modules. The
permissions table contains a separate row for each module/user combination, and
lists the add/mod/del permissions for that module. So, for example, user 'bob'
might have add and del rights for 'module1', add only rights for
and comma as decimal separator).
HTH HAND
:-D
- --
David T-G
[EMAIL PROTECTED]
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (FreeBSD)
iD8DBQFBPPGHGb7uCXufRwARAllpAKCzmDQpbLcVa5q9MvXlo8ZxkHjM1wCfQGAb
wind down.
TIA HAND
:-D
- --
David T-G
[EMAIL PROTECTED]
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (FreeBSD)
iD8DBQFBNFRwGb7uCXufRwARAsqrAKCfPPhC56rMGoza4dsz1rB4xN4IUgCeNRBC
0frePa4NG3sEv57ysVDsfAo=
=tHet
structure. Good enough...
%
% With regards,
%
% Martijn Tonies
Thanks HAND Still listening...
:-D
- --
David T-G
[EMAIL PROTECTED]
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (FreeBSD
HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg
and then give the user permissions on
it (thereby creating the user record).
%
% Any help would be appreciated.
%
% Thanks,
% BGLefty
HTH HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work
denied for user: '[EMAIL PROTECTED]' (Using password: YES)
and, similarly, the web script cannot get in. Yet when I select the user
record from mysql.user and mysql.db they appear complete.
What glaringly obvious omission have I failed to see?
TIA HAND
:-D
--
David T-G
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi again, all --
...and then David T-G said...
%
% I have just moved my web site from one server to another (whew!) and I am
% having a problem with a mysql user definition for a calendar program.
...
Sorry for the duplicate post; I only realized
a password
properly asks me for one (so I'm not showing it on the command line to
anyone with ps tools :-)
%
% /OFF TOPIC
Thanks HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Egor, et al --
...and then Egor Egorov said...
%
% David T-G [EMAIL PROTECTED] wrote:
%
% I have just moved my web site from one server to another (whew!) and I am
% having a problem with a mysql user definition for a calendar program
HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg
for each database .
% is it possible to copy the particular folder(database) to 3.23.58 and then running
it smoothly ...
Probably. Back up your .58 system, try it, and see!
%
% Any body got any idea ???
%
% Please help me out..
%
% Thanks in advance
%
% Binay
HTH HAND
:-D
- --
David T-G
, there is, indeed. CF normalization :-)
HTH HAND good luck Paul
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
. Is there any way to do
What about, on machine two,
mysqldump -hmachine1 -uuser -ppassword --opt --all-databases backup
or so?
% this besides using ftp.
Definitely. There's scp, for instance ;-)
%
% Any help would be appreicated.
%
% Richard
HTH HAND
:-D
- --
David T-G
in the script file for all to see,
how do you keep all from seeing them? And those of you who don't, what
are you doing to stay secure? And those of you who have a different
approach, what is it?
TIA HAND
:-D
- --
David T-G * There is too much animal courage in
(play
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mike --
...and then Michael Stassen said...
%
% Mikael Fridh wrote:
[And thank you to Mikael, too.]
%
% On Wednesday 12 November 2003 17.15, David T-G wrote:
%
% What if one user connects to the database as different users (as I do
. Read this once at
% least.
Agreed. It has everything you need.
HTH HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
password?
Why not instead save the encrypted password and then when checking always
encrypt what you're given and compare it? Not only is it more secure,
it's easier :-)
%
% thanks,
Sure thing.
%
% Luis R. Lebron
% Sigmatech, Inc
HTH HAND
:-D
- --
David T-G
% corrupt the database files?
Very probably.
%
% Thanks,
Sure thing!
%
%
% Keith
HTH HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy
to speak :-) Could you afford a little bit of
extra load time at startup to have your un-split, all-RAM, fast table?
HTH HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL
1 - 100 of 221 matches
Mail list logo