Hello Folks
(B I am building a C/S application with Delphi. I am now placing all my
(Bmain databases in MySql 4.0.3(InnodB) Server. The temporary databases for
(Bindividual users are kept as text files and as *Paradox db* files.
(B There are cases when both the connections are active
- Original Message -
From: Mike Wexler [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, December 25, 2002 6:43 PM
Subject: Re: SOLVED! (was: Re: What is wrong with this query?)
This is getting a little bit away from mysql
You are right, Mike, and, after this post, I will take
sir/madam
while in our script trying to reach a particular hostname related
mysql_data to monitor the calls . we get an error database connect failure
please advice us how to proceed further .
eagerly waiting for ur earliest reply
regards
Geetha
Sr.Engineer [VAS]
vsnl/chennai
Hi all,
I've some problem with my Mysql servers since the beginning of last week :(
I've upgrade mysql from 3.23.53a to 3.23.54a and i still have same errors :(
I've got plenty of error like this :
Failed to connect to database: Error: Access denied for user:
´[EMAIL PROTECTED]´ to database
MySQL Reference Manual for version 3.23.7-alpha. - ...:ÄúºÃ!
ÆÕ¹âÍøÂç:http://218.5.79.211/soho/?mid=extraterres
Ò»¸öÄÜÁîÄã³ÉΪ¸»Î̵ĺÃÍøÕ¾£º¿´¿´×Ü¿ÉÒÔ°É£¡£¡£¡
¡Ñ
»úÓöÖ»ÇàíùÇڷܵÄÈË£¬ÕâÊÇÒ»´Î»úÓö£¬²»ÊÇÃâ·ÑµÄÎç²Í£¡http://218.5.79.211/soho/?mid=extraterres
¡Ñ
On Saturday 09 November 2002 14:17, Elegant Systems wrote:
To The Mysql Support Team, We are stuck in a problem while installing mysql
in linux.This is exactly what the error shows :
021109 12:59:10 mysqld started 021109 12:59:10
/usr/local/src/mysql/bin/mysqld: Can't create/write to file
SELECT name,COUNT(listings.*) as cnt from agents LEFT OUTER JOIN
listings ON agents.name=listings.agent GROUP BY name;
IMO, joining by name is a real bad idea.
Thanks for the help. The above query provided gives the follwing error.
ERROR 1064: You have an error in your SQL syntax near '*)
Oops! I guess it doesn't work fine. The query returns 1 as the count for
agents that do not have any listings. How can I remedy that?
Thanks,
Ed
SELECT name,COUNT(listings.*) as cnt from agents LEFT OUTER JOIN
listings ON agents.name=listings.agent GROUP BY name;
IMO, joining by
Sorry to post again, i've simply forgot to give some details :
mysql show databases;
+--+
| Database
+--+
| mysql
| test
+--+
2 rows in set (0.00 sec)
However, i still have databases files present on the system :
syst@datasrv:/var/mysql$ ls -al
total 40
drwxr-xr-x8
Hello.
On Wed 2002-12-25 at 20:06:22 -0800, [EMAIL PROTECTED] wrote:
My company is currently upgrade our company'database from PICK, an
old database system to mysql..
Our company database got 1 table where the record is more than 40
million records, and the other table also got about i
i would try using php to have you page connect to the mysql database.. The code gets
parsed
first then is loaded into the browser...so the user pass for the database is never
seen.. i
would use something like:
$db = mysql_connect(localhost, mysql-user, mysql-user-password);
Hello.
On Thu 2002-12-26 at 09:26:09 -0500, [EMAIL PROTECTED] wrote:
i would try using php to have you page connect to the mysql database.. The code gets
parsed
first then is loaded into the browser...so the user pass for the database is never
seen.. i
would use something like:
$db =
Greetings
When I try to execute a query in SQLYOG( last query I have executed 2 Hours
before ), it is giving no database selected, evenif in databases combo box
the database is already selected. I am not understanding ? Does MySQL lose
the current DB status after a long time of idleness ?
Insane
I am failing to connect to the mysql database, the error is failing to connect to
/tmp/mysql.sock What should i do?
Harry
___
NOCC, http://nocc.sourceforge.net
-
Before posting, please check:
You are missing the socket file. Make sure 'mysqld' is up.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 9:57 AM
Subject: failing to connect to /tmp/mysql.sock
I am failing to connect to the mysql database, the error is failing to
Does the CGI-script need to be world-readable, or just world-executable?
All my perl CGI scripts are set up that way, so while anyone can run it,
only I can read the source code
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Brent Bailey [EMAIL PROTECTED]
Cc:
I have a website that uses MYSQL, PHP, IIS, WMS4.1 on a win2k box. The
WMS4.1 is on a separate box and uses MyODBC to connect to MySQL. It only
does look up. On the other box that has MYSQL, PHP, IIS there is insert,
delete, select, etc. How do I secure MYSQL with NTFS permissions so that
Hi all,
I want to find out the number of days in MySQL for the current month and I
found that I need to use something like:
- getting the current date.
- Finding the first date of the current month.
- Finding the first date of the next month.
- Substracting a day for finding the last day of the
I am getting the following message when submitting the following:
how-to-repeat:
[root@localhost sam]# rpm -ivh /mnt/cdrom/MySQL-4.0.6-.0.i386.rpm
error:/mnt/cdrom/MySQl-4.0.6-.0.i386.rpm: MD5 digest : BAD
expected(ba03cefd50c27d9d993ce693457c072d) !=
I don't think there is since MySql is a db and not so much of a scripting
language. Perl or PHP have functions that could do something like that.
Regards,
Bhavin.
- Original Message -
From: Octavian Rasnita [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 5:44 AM
- Original Message -
From: Nicholas Elliott [EMAIL PROTECTED]
To: Benjamin Pflugmann [EMAIL PROTECTED]; Brent Bailey
[EMAIL PROTECTED]
Cc: Octavian Rasnita [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 4:17 PM
Subject: Re: Hiding the password
Does the CGI-script
I chmod 511, on a CGI script owned by me. My username has access to read
the source code, and apache can run the cgi script, but other users on the
server cannot read the source themselves (minus root, etc).
The original question was,
I want to make a CGI program in Perl that queries a MySQL
- Original Message -
From: Nicholas Elliott [EMAIL PROTECTED]
To: Mark [EMAIL PROTECTED]
Cc: Octavian Rasnita [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 5:09 PM
Subject: Re: Hiding the password
I chmod 511, on a CGI script owned by me. My username has access
I don't understand why I'm getting so much spam
from the mysql list...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Yup, so, I guess my setup is a little off-key. *Engage sheepish mode*
Turns out the admins for my system have apache in a development group, which
all my files belong to, with 751 permissions. So, yeah, other users can't
read the password per se but its obviously not what I thought it was.
mysql£ºÄúºÃ£¡
ÕâÊÇ×îлúÌؼÛÐÅÏ¢£¬»¶Ó²éÔÄ¡£
µã»÷½øÈ룺¾Æµê²éѯ¡¢ÔÚÏ߶©Æ±¡£
ÖØÔÚ·þÎñ-¹óÔÚÆ·ÖÊ-ÖµµÃÐÅÀµ-°é¾ýÅô³Ì
http://www.zhongqi.net/special1214.htm
(REMOVE)
Èç¹ûÕâ·âÓʼþ´òÈÅÄúÁË£¬·³ÇëËæÊÖɾµô£¬²¢Çë¼ûÁ¡£ÈôÄú²»Ï£ÍûÔÙ´ÎÊÕµ½ÎÒÃǵÄÓʼþ£¬Çëµã»÷ÕâÀï
I am trying to compile mysql (version 4.0.7 or 3.23.54a, same thing )
/usr/include/linux/autoconf.h:66: warning: `CONFIG_SMP' redefined
../include/global.h:223: warning: this is the location of the previous
definition
mysqld.cc: In function `void print_signal_warning(int)':
mysqld.cc:726:
Hello,
We run several frontend servers (Linux/Apache/PHP) behind a load balancer.
Each frontend is also a MySQL slave, and all queries are done locally
(all changes go directly to the master). The problem is, whenever
somebody makes a lot of changes to the database at once (deletes, updates,
or
Does anyone know how to integrate easily MySql tables with Microsoft SQL
Server tables?
Thanks in advance,
Micheline.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi!
InnoDB is a MySQL table type which offers transactions, row level locking,
foreign key constraints, and a non-free hot backup tool.
InnoDB is included in MySQL-Max-3.23 and all MySQL-4.0 downloads available
at http://www.mysql.com.
MySQL AB decided to release MySQL-4.0.7 just a week after
Hi @ll,
ich changed my Server from SuSE to Redhat, but now i have the following
problem, when i try to connect to my mysql database. I'm using Redhat 8.0, i
testet Mysqlfront and got the following error message
LOst connection during query error 2013
Anyone an idea,
Gruß
Thorsten Lasrich
On Thu, Dec 26, 2002 at 12:17:28PM -0700, Matt Sturtz wrote:
Hello,
We run several frontend servers (Linux/Apache/PHP) behind a load
balancer. Each frontend is also a MySQL slave, and all queries are
done locally (all changes go directly to the master). The problem
is, whenever somebody
Hi, Happy holiday !
I'm not happy right now.
I can't compile src distribution of mysql-3.23.54a on Sun Solaris 8 with
gcc version 3.0.3.
Does anyone has luck with Mysql using gcc 3.0.3 ?
Is a version of Mysql other than mysql-3.23.54a that can be compiled with
gcc version 3.0.3 ?
I've
Hello -- The db_stat utility displays statistics for the Berkeley DB
environment variables. I have a version of MySQL that can use Berkeley DB
tables. Does anyone know how to use db_stat in MySQL, to get BDB
statistics.
The db_stat utility can be invoked with db_stat -h where the -h flag
should
Hi, does anyone have any experience using db_stat to get statistics on BDB
tables in MySQL. How did you go about this please? Thanks.
Geetika
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Given the two tables: fruit_table, and vegetable_table, how do I get
the Desired ResultSet below? Thanks...
fruit_table
+-++
| date| fruit |
+-++
| 2002-12-16 00:00:00 | Apple |
| 2002-12-17 00:00:00 | Banana |
query.
I happened to find out that the lots of following error messages are
stored
error log file:
Warning: thr_alarm queue is full
What's this? Is it serious problem?
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub http://www.sayclub.com
NeoWiz http://www.neowiz.com
At 15:13 +0900 12/26/02, Chung Ha-nyung wrote:
I've heard that I should periodically alter innodb table to MyISAM and
back to InnoDB to optimize table structure.
I guess only dropping index and recreating it is enough, but should I
change table type?
Dropping an index doesn't change a
What I'd like to do is not to alter table type but to optimize table.
Somewhere I read that to optimize the structure of innodb type table,
I should
alter table type two times: to MyISAM and back to InnoDB. Or dump
load
data.
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub
At 11:56 +0900 12/27/02, Chung Ha-nyung wrote:
What I'd like to do is not to alter table type but to optimize table.
Somewhere I read that to optimize the structure of innodb type table,
I should
alter table type two times: to MyISAM and back to InnoDB.
Uh, well, what I wrote below shows how
At 11:47 +0200 12/25/02, Octavian Rasnita wrote:
Hi all,
I gave the following command in the default MySQL client:
select from_days(365);
The result is -00-00 instead of 0001-00-00.
If I gave the following command:
select from_days(366);
It gives the result 0001-01-01.
If I give
My name is Arun, I subscribed recently to the mysql
list, but I have some problems sending my mails to
this group(but I am receiving all mails). Also I have
some urgent problem at hand, I wanted answer to one of
my question. It would kind of you to post this
question onto the mysql
What you want is the FULL OUTER JOIN syntax which MySQL doesn't support.
SELECT fruit_table.date, fruit, vegetable FROM fruit_table FULL OUTER JOIN
vegetable_table ON (fruit_table.date = vegetable_table.date);
(I'm assuming that NULL is acceptable instead of the empty string for the
empty cells
Scott Ambler recommends in his publication Mapping Objects to Relational
Databases not to do joins but to traverse tables. He claims that 'several
small accesses are usually more efficient than one big join'.
Is that true for mysql? I am particularly interested in a scenario where I
would
Hello all,
I'm creating a db to track a contest involving sports teams and scores.
My table matchups has columns for team1_id, team2_id, team1_score and
team2_score.
I can write a simple calculation using the api I use (Lasso - similar in
function to php) and display the results
oY!
I am running RH 6.2 with PHP 3.0.15 (don't ask why I do not run php 4 yet, I really
need to install theses versions to start everything) but when I am trying to access a
mysql function I get the following error : Fatal error: Call to unsupported or
undefined function mysql_connect() in
Hi,
Is anyone know how to view image that is stored in
mysql as binary format to
a browser ?
Thank you.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
47 matches
Mail list logo