Hi,
I have to install a mysql server for managing several database, from small to
quite big (tables with about 2M rows). I've got a SAS disk array and I was
wondering what the best configuration could be:
1) raid 10
2) raid 5
3) a combination (e.g., raid10 for the data and raid 5 for the logs).
Hi all,
I've got an account table with password encrypted thru the encrypt() function,
and I should transfer them to a table with password() function. I don't want
to decrypt the password, and I'd like to know if there's a way to build the
password hash from the encrypt one.
Any suggestion?
Hello,
sorry if this is not the right mailing list to ask this question, hope someone
can point me to a better list in the case.
My problem is that I'd like to use mysql as database for storing user accounts
for different services, and I started using vsftpd. Now, following the
instruction
On Thursday 26 July 2007 Rajesh Mehrotra's cat, walking on the keyboard,
wrote:
Check out
http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
Please note that PostgreSQL provides a gateway to other databases thanks to
the DBI-Link extension, as well as it support more than
Hi all,
I'm new to MySQL coming from PostgreSQL backgroud. I'd like to know how to
obtain the same effect of a sequence + concat as default value of a table in
mysql. For example, consider the following table definition:
CREATE TABLE competenza
(
id_competenza character varying(30) NOT NULL
On Tuesday 02 January 2007 16:51 Brent Baisley's cat, walking on the keyboard,
wrote:
CREATE TABLE competenza (
competenza varchar(30) NOT NULL default 'comp-06-',
id_competenza int unsigned not null auto_increment,
descrizione varchar(100),
PRIMARY KEY (competenza, id_competenza)
)