My choice was based on the fact that web requires a high number of reads
and normally far fewer writes. The speed of MySQL in read is very fast
compared to PostgreSQL. Where it comes to accounting, high transactions
and such applications I will continue to use PostgreSQL till MySQLv5
becommes
Hi Stone,
if you ask me which is bettet your car or mine, i'll answer mine.
Your question can't be answered here because it's not technical but political.
Better close this thread.
Mathias
Selon stone.wang [EMAIL PROTECTED]:
How do you think about PostgreSQL and mysql? want to know which is
Hi,
Have you tried '\\' ?
Mathias
Selon nyem [EMAIL PROTECTED]:
Hello,
I have a database (on Win2k) with merge table. Mysqldump output includes
some path information on the merged tables such as DATA DIRECTORY and
INDEX DIRECTORY
DROP TABLE IF EXISTS `rptpricing1996`;
CREATE TABLE
Hi,
I don't use C APPI, but found this in docs for you :
*** connect sample :
MYSQL mysql;
mysql_init(mysql);
mysql_options(mysql,MYSQL_READ_DEFAULT_GROUP,your_prog_name);
if (!mysql_real_connect(mysql,host,user,passwd,database,0,NULL,0))
{
fprintf(stderr, Failed to connect to
Selon James Tu [EMAIL PROTECTED]:
What have people done in the past regarding backup strategies?
Is it adequate enough to rely on filesystem backups for mysql? Basically
such that we can restore MySQL to the last filesystem backup. Is there a
reason not to do this?
I don't have any mission
Does any one know how PostgreSQL compares to MySQL regarding stability
and maintenance?
I have been using MySQL for about two years, and it has proved to be
very stable and requires almost zero maintenance.
FB
Hi Stony,
I didn't use PostgreSQL before, so couldn't comment. For MySQL, you
Isn't this what a User Defined Function would be used for? Your trigger
would call the UDF which would do a system().
Or is this not possible under Mac OS?
-Lee
Gleb Paharenko [EMAIL PROTECTED]
I don't know any SQL statements which could launch extern commands,
at least in MySQL. So in
Hi,
I did it so I thank you again. Belove is my code that did it, I hope,
what I expect.
I notice the version of documentation not the same as my copy on my hard
drive.
Thanks again,
mt
#include /usr/include/mysql/mysql.h
int modulMySQL() {
MYSQL mysql;
printf(01\n); fflush(stdout);
Hello.
Yes, you're right. I've forgotten about them, sorry.
[EMAIL PROTECTED] wrote:
Isn't this what a User Defined Function would be used for? Your trigger
would call the UDF which would do a system().
Or is this not possible under Mac OS?
-Lee
Gleb Paharenko [EMAIL
Dear List,
My system is RedHat EL3 and MySQL 5.0.7-beta.
I wanted to implement a check constraint (below), but after some testing
and googling, it seems I can't do this with MySQL. I've read suggestions
that check(s) should be done using triggers. Is a trigger a preferred
method of achieving the
I don't know how big your tables are, and if you can withstand any
downtime. Because we're using MyISAM tables, we use mysqlhotcopy,
which locks the database as it copies the tables to another location.
Once that's been done you can rely on your filesystem backup to keep
copies of the data
A trigger is a good place to check the value, and change it, bit I
don't believe you can actually generate a MySQL error within the
trigger that will prevent the data from being inserted. Currently
(unless there's been an update to triggers that's not yet in the
docs), you can only change
Another approach would be to use a view with a CHECK OPTION. This will
allow the view to behave exactly like a check constraint:
CREATE VIEW tblJob_view AS
SELECT JobId, CustomerId, JobType, Description,
QuotationDate, OrderDate
FROM tblJob
WHERE JobType IN ('DesignOnly',
I'm starting to play with linux. Till now I have over my shoulders three
days experience with it :-)
I have been able to install and successfully run mysql 4.1.12 but
something it's happening I cannot understand (no surprise)
With my sql stopped I go to console as root and write:
cd
But if you follow Partha's approach, you will need to make sure that the
only inserts to the table occur via the view. Nothing in the definition of
the view itself prevents a user with the necessary authority from inserting
directly into the table. You'll need to ensure that your GRANTs don't
Juan Pedro Reyes Molina wrote:
With my sql stopped I go to console as root and write:
cd /etc/init.d
mysql start
At this point, try (as root)
which mysql
It will certainly not be /etc/init.d/mysql, but somewhere in your
defined PATH; try
echo $PATH
to see what that is
I would like to
hello, Hassan
which mysql gives me /usr/bin/mysql. echo $PATH shows me that /usr/bin
is the fourth try. I thougth this was windows like, where PATH is only
used if program is not found in active directory.
So, I have a script in /etc/init.d called mysql and an executable in
/usr/bin also
Juan Pedro Reyes Molina wrote:
which mysql gives me /usr/bin/mysql. echo $PATH shows me that /usr/bin
is the fourth try. I thougth this was windows like, where PATH is only
used if program is not found in active directory.
Executables in the 'current working directory' will only be used
if
- Original Message -
From: Juan Pedro Reyes Molina [EMAIL PROTECTED]
To: Hassan Schroeder [EMAIL PROTECTED]
Cc: mysql general list mysql@lists.mysql.com
Sent: Saturday, June 25, 2005 2:08 PM
Subject: Re: starting mysql 4.1.12 on Ubuntu Linux
hello, Hassan
which mysql gives me
Hi,
Have struggled with this all day, and didn't know where else to ask.
If it's not appropriate to the list, I apologise - and advice or
pointers would be brilliant, as my head is now hurting!
So here's the situation:
3 tables. f_u_groups f_groups and f_images
f_u_groups contains the user's
Where do I look for log file?
I have read mysql log file and see no indication of start up with
linux, last entry is about prior shutdown. (BTW every time mysql starts
it writes on err file: /usr/sbin/mysqld-max: File
'/var/log/mysql/mysql.log' not found (Errcode: 13) but directory
Félix Beltrán wrote:
Does any one know how PostgreSQL compares to MySQL regarding stability
and maintenance?
I have been using MySQL for about two years, and it has proved to be
very stable and requires almost zero maintenance.
It really depends on what you are using it for. Stability
Hello Jonathan.
I have renamed /etc/init.d/mysql to mysqld and added symbolic link to rc2.d.
Now it works.
I will add symbolic link to rc1.d too.
Being this my third day with linux its being a long jump :-)
Thank you Jonathan and Hassan for your good help!
Jonathan Mangin wrote:
-
As previously posted to this list.
http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf
On 6/24/05, stone.wang [EMAIL PROTECTED] wrote:
How do you think about PostgreSQL and mysql? want to know which is good? How
to choose database for the web?
--
MySQL General
Nils,
Thanks for your support but still not working.
All I need is to have MYSQL installed with a root password.
For exemple, I can never login when I am a root user. I always need to be a
user like yannick
I can also not make any request other the localhost as when I add -h
fujitsu, he makes re
Selon W Luke [EMAIL PROTECTED]:
Hi,
Have struggled with this all day, and didn't know where else to ask.
If it's not appropriate to the list, I apologise - and advice or
pointers would be brilliant, as my head is now hurting!
So here's the situation:
3 tables. f_u_groups f_groups and
Selon Michael Kruckenberg [EMAIL PROTECTED]:
A trigger is a good place to check the value, and change it, bit I
don't believe you can actually generate a MySQL error within the
trigger that will prevent the data from being inserted. Currently
(unless there's been an update to triggers that's
Hi ,
You did a confusion between root for mysql (wihich is SA or DBA group) and the
root of the OS.
have you ever installed mysql in windows. there is a root user even in windows.
What you must do is to ask the person who installed for the Mysql root
password and check the users created in the
Another thing :
fujitsu:/home/yannick # mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/home/yannick #
is normal:
try fujitsu:/home/yannick # mysql -u yannick -p
Mathias
Selon Mathias [EMAIL PROTECTED]:
Hi ,
You did a confusion between root
On 25/06/05, Mathias [EMAIL PROTECTED] wrote:
I then write you this query which should give you the idea, and i think the
solution :
mysql select gid,ugid,FIND_IN_SET(gid,ugid) from groups,groupsList
- where FIND_IN_SET(gid,ugid) 0;
+--+-+---+
| gid |
Mathias,
Did what you asked :
[EMAIL PROTECTED]:~ mysql -u yannick -p
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
[EMAIL PROTECTED]:~ mysql -u yannick -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL
Since you can connect as yannick without password, just set it after login :
mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass');
see http://dev.mysql.com/doc/mysql/en/set-password.html for more details.
I advice to set it to another password than your yannick linux one.
Mathias
Vous être le bienvenue :o)
Selon W Luke [EMAIL PROTECTED]:
On 25/06/05, Mathias [EMAIL PROTECTED] wrote:
I then write you this query which should give you the idea, and i think the
solution :
mysql select gid,ugid,FIND_IN_SET(gid,ugid) from groups,groupsList
- where
Can someone tell me why this query works...
SELECT UserKey
FROM(
SELECT UserKey, Count(GiftKey) Gifts
FROM Gift
Group BY UserKey
) GC
WHERE GC.Gifts = 3
And this one doesn't?
SELECT UserKey, UserID,
FROM User
WHERE UserKey IN
(SELECT UserKey
FROM(
SELECT UserKey, Count(GiftKey) Gifts
Mathias,
I would love to do it but this is the answer :
mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('test');
ERROR 1133: Can't find any matching row in the user table
mysql
I also succeeded to enter with mysqladministrator. (Without password !)
The strange thing is that when I go to
Hi,
Use enum with a default type and let mysql do the check for you.
The problem with an enum is that if you insert a value that's not in
the enum, MySQL doesn't stop the insert, it leaves the column empty.
This doesn't enforce data integrity like I think Chris wanted.
mysql desc
So far this was what I did,
Took all files i.e frm, MYI and MYD files from the new
server. Created a database like on another box running
the version of mysql the old server was running and
pasted them in the data folder of the database I
created and viola - they all showed up, so i think it
was
Alla-amin wrote:
So far this was what I did,
Took all files i.e frm, MYI and MYD files from the new
server. Created a database like on another box running
the version of mysql the old server was running and
pasted them in the data folder of the database I
created and viola - they all showed up,
38 matches
Mail list logo