would probably be very dependent on the data within the database. if it's
a lot of text data, then very compressable, as text typically compresses
nicely. if you store a bunch of binary data (images or something), then
probably not as much...
tar your mysql dir and gzip it, or gzip -9 or bzip2
you can use the password() mysql function to crypt it.
you cannot retrieve the encrypted password -- only compare input
(password() the input) against the saved encrypted password. if the
resulting text matches, the password is good. if not, the authentication
in your application should fail.
it's not all that dangerous. it just means that you can read your users'
passwords. anyone who can read that db table can become any of your
users. password fields are just another safeguard against a "just in case
someone gets read access to this" scenario. they also serve to provide
more pr
they're both behaving similarly, it's just that linux's implementation and
display of threads is different than solaris'. the same correlation of
threads for connections is there on solaris, you just won't see it on a
"ps" command's output.
-tcl.
On Thu, 6 Dec 2001, Peter M. Perchansky wrote:
check out the "set" type instead of enum.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Column_types
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SET
-tcl.
On Tue, 20 Feb 2001, [KOI8-R] "îÉËÏÌÉÎ óÅÒÇÅÊ" wrote:
> Hello
>
> I have situatio
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html#Missing_Transactions
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#BDB
-tcl.
On Tue, 13 Feb 2001, Eric Kwong wrote:
> I'm wondering if MySQL supports transaction?
> Since I have an appli
h php connections and from perl dbi
connections. the versions involved are:
mysql-3.23.32
php-4.0.4pl1
DBI-1.14
Msql-Mysql-modules-1.2215
oh and perl is v5.6.0.
which i believe are the latest stable releases of each.
anything else i should be looking for?
-tcl.
On Tue, 23 Jan 2001, tc lewis wr
Fixed buffer overflow bug when writing a certain error message."
On Tue, 23 Jan 2001, Maciek Uhlig wrote:
> Read the archives. The detailed story can be found there. Use newest MySQL
> and newest PHP CVS. These errors will go away.
>
> Maciek
>
> > -Original
we're seeing a lot of errors like these in our error log files from mysql:
010122 17:38:52 Aborted connection 177373 to db: 'XXX' user: 'YYY'
host: `ZZZ' (Got an error reading communication packets)
i haven't investigated too too much about this yet, but i was wondering
what common problems th
in the mysql manual, i noticed:
"Even though Berkeley DB is in itself very tested and reliable, the MySQL
interface is still considered beta quality. We are actively improving and
optimizing it to get it stable very soon."
a team i'm in is considering trying bdb tables for some things for a queu
er, what?
did i miss something? heh.
-tcl.
On Mon, 22 Jan 2001, Nathan Cook wrote:
> Note: As of version 3.2.3gamma Mysql Supports Sub-Selects.
>
> .:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
> Systems & Network Administrator :: Programmer
> [ phone - 208.343.3110 ][ pager - 208.387.9983 ]
>
11 matches
Mail list logo