none of these are open source and its under windows
http://www.minq.se/products/dbvis/images/screens/graph.html
this is what i want to do , except its on myisam tables not inondb so there
is no foreign key relations i join them in the query or can i still do
this ?
Hi Daniel,
The question
Am I missing a configuration setting somewhere?
I have been working on a MySQL Max (3.23.52-max-nt) database running on W2K
Server.
I am using a MySQL client remotely over a VPN but unfortunately the client's
internet connection is severely overloaded and the connection dies on
occasion.
When
Hi Daniel,
sorry for mistaken your request. So I guess you are a developer and want to
modify and create your own source code ?
2003 6 13 15:[EMAIL PROTECTED] :
none of these are open source and its under windows
http://www.minq.se/products/dbvis/images/screens/graph.html
this is what i
Hi people.
Installing MySQL 3.23.54 under Windows 2000
(according to instructions in Next handbook 'Introduction to MySQL.', and
from CD attached to book)
Installing MySQL
- worked fine.
Starting the Server
c:\mysql\bin\mysqld-nt
- worked fine.
Running the MySQL command line interface
Hello,
I develop with C++Builder 5 and 6. I replaced BDE by MODBC component.
It was working fine with MySQL 2.5.0.
It seems it is no more compatible with version 3. I get the following
error :
42000[ODBC 3.51 Driver][You have an error in your SQL syntax near]
followed by the beginning of the
Hi,
I develop applications that about GIS. I am using Oracle Database for our projects. We
store our geographical data on Oracle 9i with Oracle Spatial Support. But i don't like
Oracle, i want to change my company's database policy. Because Oracle is too
complex(in bad mean), expensive, its UI
Hi Mehmet,
I am not sure excactly what you are looking for as spatial data is quite new
for MySQL I believe.
How about this info ?
http://localhost/xoops/manuals/mysql/en/GIS_spatial_extensions_in_MySQL.html
2003 6 13 17:24Mehmet KADAYIFI :
Hi,
I develop applications that about GIS. I am
Mehmet KADAYIF?I [EMAIL PROTECTED] wrote:
I develop applications that about GIS. I am using Oracle Database for our projects.
We store our geographical data on Oracle 9i with Oracle Spatial Support. But i don't
like Oracle, i want to change my company's database policy. Because Oracle is
Fabio Bernardo [EMAIL PROTECTED] wrote:
Hi there... I have this situation:
table_A table_B
id name id name
1 A 1 A
2 B 2 B
3 C
If i run this statement :
SELECT table_A.* FROM table_A outer join table_B ON table_A.id=table_B.id
WHERE
Axel Tietje [EMAIL PROTECTED] wrote:
Hi everyone...
I actually have two servers:
1. Server: MySQL 4.0.12
2. Server: MySQL 3.23.38
This query:
SELECT o_obj,
MAX(CASE WHEN o_key = '69B96431' THEN o_val END) AS _69B96431,
MAX(CASE WHEN o_key = '69B96431' THEN o_typ END)
John Telford [EMAIL PROTECTED] wrote:
I have had a problem with my install of MySQL on Rehat7.0 and I wonder if anyone has
any advice. Here is what I have done.
1. When I installed RedHat, I installed the MySQL libraries from the RedHat CD. I
think it was version 3.23
2. I installed the
Hi Mehmet,
Sorry I send you the worng link. Try this one please
http://www.mysql.com/doc/en/GIS_spatial_extensions_in_MySQL.html
Best regards
2003 6 13 17:24Mehmet KADAYIFI :
Hi,
I develop applications that about GIS. I am using Oracle Database for our
projects. We store our geographical
I thought I had most things figured out for our challenging replication
setup. However this morning we have a failure I can't figure out... Here are
the errors:
030613 5:13:50 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'binary-log.035' at position
That got me greping through my Master's log and I came accross the
following :
Error reading packet from server: log event entry exceeded
max_allowed_packet - increase max_allowed_packet on master
(server_errno=65535)
This seems to have happened in the date ranges where replication was
Hi Bruce,
I dont know the solution, but error 1236 is a server issue as described below.
Starting and stopping the slave wont help anything. Are you sure that the
servers binary log is not corrupted ?
Try to reset the master.
4.10.7.5 RESET MASTER (master)
Deletes all binary logs listed
In the case of both the master and the slave the max_allowed_packet is set
to 1047552. In both cases I raised it to 2047552 just to be generous.
In order for changes to the max_allowed_packet to take effect, you'll need
to restart mysqld on that server.
Cheers,
Andrew
-Original
I have a question, when loading dates into mysql I have found I can always
use MMDD or -MM-DD, but frequently I need to load data from ASCII
csv files where the date is M/D/. Currently, I am using perl to read
the datafile and insert each record after converting the date data. I
Patrick Shoaf [EMAIL PROTECTED] wrote:
I have a question, when loading dates into mysql I have found I can always
use MMDD or -MM-DD, but frequently I need to load data from ASCII
csv files where the date is M/D/. Currently, I am using perl to read
the datafile and insert each
Chris Boget [EMAIL PROTECTED] wrote:
What's going on with the MAX() function? Why did it return NULL
in the first query above. There were no adding/deleting data between
the above queries and yet MySQL didn't pull the MAX from the table
until I added the AND assets IS NOT NULL to the
I receive the following error when trying to compile MySQL 3.23.56 on
Solaris 9:
config.status: creating readline/Makefile
config.status: error: cannot find input file: readline/Makefile.in
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello.
How can I recover query errors done on a mysql server?
Is there a log file?
It's very important to me to know about this.
Thanx so much!!!
Lorenzo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Guys,
I have the following table:
CREATE TABLE tempo_resposta (
id int(11) NOT NULL auto_increment,
idmaquina int(11) NOT NULL default '0',
tempo int(11) NOT NULL default '0',
horario datetime NOT NULL default '-00-00 00:00:00',
PRIMARY KEY (id)
) TYPE=MyISAM;
Hi All,
I created a user dfn and I granted access to only the
database dfn.
Now, if I log as dfn user query for SHOW DATABASES, mysql
returns me the error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Would anybody know what could be wrong?
Thank's
Ronan
--
Did you GRANT SHOW DATABASES to the user? If not then they will not be
able to use the command. The SHOW DATABASES GRANT clause is a new
addition.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Ronan Lucio [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 8:34 AM
Try using [EMAIL PROTECTED] (assuming you're connecting
from localhost) to grant permission. I had similar problems
and doing that fixed it for me.
Steven:)
Ronan Lucio wrote:
Hi All,
I created a user dfn and I granted access to only the
database dfn.
Now, if I log as dfn user query for SHOW
Mike,
On Fri, 13 Jun 2003 08:38:32 -0600
Mike Hillyer [EMAIL PROTECTED] wrote:
Did you GRANT SHOW DATABASES to the user? If not then they will not be
able to use the command. The SHOW DATABASES GRANT clause is a new
addition.
I'm sorry but I don't have experience with MySQL.
Actually, I
GRANT SHOW DATABASES will allow a user to see all databases, whether the
user can access them or not.
-Original Message-
From: Ronan Lucio [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 8:56 AM
To: Mike Hillyer
Cc: [EMAIL PROTECTED]
Subject: Re: Access denied
Mike,
On Fri, 13
Hi,
You need to index the column that is used in the where clause
try this
ALTER TABLE tempo_resposta ADD INDEX idmaquina (idmaquina);
HTH
Dobromir Velev
- Original Message -
From: Leonardo Rodrigues Magalhães [EMAIL PROTECTED]
To: MySQL ML [EMAIL PROTECTED]
Sent: Friday, June 13, 2003
Something else to consider here:
MySQL can use indexes to optimize order by as well, but your order by value can't be
indexed since
it is derived from a database lookup/calculation. If you really need to order by
diferenca
you may have to live with it, although you may still see Using
Hi all,
is it ok, that the mysqld_safe process runs under the root account!
Shouldn´t that be the mysql account, too?
10317 root 9 0 1060 1060 876 S 0.0 0.0 0:00 mysqld_safe
10359 mysql 9 0 1436 1436 1044 S 0.0 0.0 0:00 mysqld
10361 mysql 8 0 1436 1436
What's the latest version of MySQL for windows? Mysql.com says it's 4.1
alpha but the download that reads 4.1 alpha is actually 4.0.12. Is there no
version 4.1 available for Windows?
Many thanks,
rajendra
Unless expressly stated to the contrary, the views expressed in this email
are not
Hi all.
I have a fulltext index on a table.
If I have the following fields:
field1,field2,field3,field4
Field4 being the fulltext field.
I have the following indices:
index1-field1,field2,field3
index2-fulltext field4
If I do a select:
select * from table where match(index2)
The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
On Fri, 2003-06-06 at 09:36, H M Kunzmann wrote:
Hi all.
I am running RH9.0 with
The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
On Thu, 2003-06-05 at 09:59, H M Kunzmann wrote:
Hello All.
I am using Redhat
Have you tried adding force index on your fulltext index?
Something similar to this:
select field1,field2,field3 from table FORCE INDEX(index2)
where field1='something'
and field2='something_else'
and field3='something_more'
and match(field4) against ('word1 word2' in boolean mode)
Hi!
I am new here and wonder if anyone could help me with a problem in my community.
The adress is http://trashankarna.net/community/default.php
I can't figure this out. I get this message when I choose to read a message in my
outbox/utkorg:
Warning: 1 is not a valid MySQL-Link resource in
What's the client running on?
Curtis
On Thu, 12 Jun 2003, Chris Webster wrote:
Curtis Maurand wrote:
I'd write a perl script to pool the device and send the data to the
database.
Sorry for not being clearer. I can get the data into the database
fine. Assuming new values or rows
As this is really a PHP specific question, you may get a better response on the PHP
general mailing list at http://www.php.net/mailing-lists.php
Anyway, if my limited experience in PHP serves correctly, you may need to call
echo(mysql_error()); near the potentially troublesome code.
Regards,
Any reason why a SELECT which finds no matches returns instantly
but an update which has the same where clause takes about 2 secs to return.
explain reports that the select is exaninng 10 rows in a 300,000 row table.
which is exactly what i am expecting.
are there any know issues?
-Todd
--
At 17:44 +0200 6/13/03, Dingfelder Andy wrote:
Hi all,
is it ok, that the mysqld_safe process runs under the root account!
It should be okay.
Shouldn´t that be the mysql account, too?
10317 root 9 0 1060 1060 876 S 0.0 0.0 0:00 mysqld_safe
10359 mysql 9 0 1436 1436
Mike,
On Fri, 13 Jun 2003 08:59:09 -0600
Mike Hillyer [EMAIL PROTECTED] wrote:
GRANT SHOW DATABASES will allow a user to see all databases, whether the
user can access them or not.
How should I securely grant SHOW DATABASES to an user?
GRANT SHOW DATABASES ON mysql.db to [EMAIL PROTECTED];
Hi!
On Jun 13, H M Kunzmann wrote:
The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
No, this is wrong.
Any xxxTEXT field can be
Mike,
I forgot to say I'm using mysql-3.23.52
Perhaps, this GRANT option do not work for this version, look:
-
mysql grant show databases to dfn@%;
ERROR 1064: You have an error in your SQL syntax near 'show databases to dfn@%' at
line 1
mysql grant show databases
At 14:20 -0300 6/13/03, Ronan Lucio wrote:
Mike,
I forgot to say I'm using mysql-3.23.52
The SHOW DATABASES privilege is not relevant until MySQL 4.0.2.
Perhaps, this GRANT option do not work for this version, look:
-
mysql grant show databases to dfn@%;
ERROR 1064:
Curtis Maurand wrote:
What's the client running on?
Not the same machine as the server. Could either be a windows or
linux box across ethernet.
--Chris
Curtis Maurand wrote:
I'd write a perl script to pool the device and send the data to the
database.
Sorry for not being clearer. I can get
I think I need to clarify :
The fulltext indexing searching here works great.
The search completes in good time, but then I want it in a different
order, as described by index1 down below. This resorting step is the one
that takes forever, not the fulltext search.
So essentially, a FORCE
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything that makes since to me.
Can someone point me in a direction as to where I can find this out?
The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and Apache 2.0.46.
I
I've been asked to setup a MySQL DB for critical mass usage. The programmer is asking
that I use MySQL-Max. Does this have to be installed along with the regular MySQL
version or is it a single product on it's own?
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks
Jon Miller wrote:
I've been asked to setup a MySQL DB for critical mass usage. The programmer is
asking that I use MySQL-Max. Does this have to be installed along with the regular
MySQL version or is it a single product on it's own?
From the MySQL/downloads page for 4.0:
The Standard
Since we are on the subject
Why is mysql-max(16meg) mysql(25meg) (for x86 v4.1)?
No docs or something?
-Original Message-
From: V. M. Brasseur [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 1:00 PM
To: Jon Miller
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL-Max
Jon Miller
Hi
1- Is there a command to rename an existing database ?
2- If not, how does one create a new database from an existing database ?
could you show me the steps?
Any help is appreciated.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Wong Zach-CHZ013 wrote:
Hi
1- Is there a command to rename an existing database ?
2- If not, how does one create a new database from an existing database ?
could you show me the steps?
Any help is appreciated.
Thanks
Have you tried the mysqlhotcopy util?
I'm having a problem with some very slow queries that spend a very long
time in the 'Sorting result' state and I'm wondering how sorts are
implemented in mysql and what I can do to optimize these types of queries.
The query looks something like this:
SELECT col1,col2,col3 from table1 where
I think something is definitely wrong with your setup or your query. A
query for a count of the number of rows should be almost instantaneous.
How are your querying? You should be using:
select count(*) from tablename
Any other query that you filter on should have a index on the search
field.
Sorts don't use indexes, for the most part, only the search part does.
Someone correct me if I'm wrong on that, I think I recall reading it in
SQL for Smarties. The index is on the entire database, not on the
subset that you have selected. If you know that your query is going to
return most of
MySQL should have no problems running on your system, and if it runs better on
another box, that would indicate a configuration problem or background processes
clogging up the works. If you post your my.cnf file, someone here might be able
to rule out the former.
Edward Dudlik
Becoming Digital
Losing your mind, perhaps?
http://www.mysql.com/downloads/download.php?file=Downloads%2FMySQL-4.1%2Fmysql-4
.1.0-alpha.zipmirror=http%3A%2F%2Fmysql.secsup.org%2F
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
MySQL can use indexes to sort, but not when your WHERE clause contains a
column other than the one being sorted on.
I think the MySQL manual has a good section on what 'filesort' means and
when MySQL uses it. Basically it's selecting all the rows that meet your
WHERE clause, then running a
If PHP was built without MySQL support, you need to recompile it. It should be
in there, though, so check the php.ini file.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Subscriptions [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, 13 June,
What table type is this? If it's MyISAM select count(*) should be instantaneous. If
it's InnoDb and you've got a large dataset (say 1 million+) then select count(*) will
be slow b/c it doesn't store the # of records in the table, thus it has to count
records. MyISAM does store the count so it
table creation - arrays ?
how are rows as ARRAYS specified and created on a table ?
wbrgds
hans
_
Die aktuellsten Computer News gibts auf MSN! http://www.msn.at/computer
--
MySQL General Mailing List
For list archives:
Arrays are not currently supported in any production-release versions of MySQL.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Hans Nerdell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 09:25
Subject: table creation - arrays ?
I'm working on a system that will allow me to perform operations on a
table using a web form, and I would like to know if a table has a
foreign key, however I don't seem to see this information listed in any
of the show commands output (or describe). Any idea how I could identify
what colums
Subscriptions wrote:
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything that makes since to me.
Can someone point me in a direction as to where I can find this out?
The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and
Peter,
When you get everything working please let me know how you did it. I have been trying for days without any luck.
Regards,
Jay
---Original Message---
From: Peter Burden
Date: vrijdag 13 juni 2003 22:46:20
To: Subscriptions
Cc: [EMAIL PROTECTED]
Subject: Re: PHP, MySQL
Peter Burden wrote:
Subscriptions wrote:
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything that makes since
to me.
Can someone point me in a direction as to where I can find this out?
The problem I'm having is I have PHP
I'm having some trouble with linking mysql-4.0.13 into php-4.3.2. I am
getting following error:
//usr/lib/libresolv.so.1: fatal error: symbol `_res` multiply defined in two
shared objects /usr/lib/libsocket.so: size = 448; //usr/lib/libresolv.so.1:
size = 512
collect2: ld returned 1 exit status
On Fri, 13 Jun 2003, Grimes, Dean wrote:
I'm having some trouble with linking mysql-4.0.13 into php-4.3.2. I am
getting following error:
//usr/lib/libresolv.so.1: fatal error: symbol `_res` multiply defined in two
shared objects /usr/lib/libsocket.so: size = 448; //usr/lib/libresolv.so.1:
Hi guys,
I had updated a field for all the entries in a table
by mistake, I need to undo that step. I dont have the
database back up to an stisfactory level. Is there a
way in MySQL I can step one action back? or undo one
command that I just did??
Thanks a lot guys!?
Hi,
Does anyone know of a good tutorial on setting up a login page, and passing
the login primary key to other pages so that other tables will be able to
refernce the unique login
thanks
steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm querying a table of approximately 42 records based on 3 criteria. The results are
then displayed in a pop-up window. When the query is executed the first time - the
window opens and stalls for about 3 seconds before the results are displayed.
An example query would be : select * from
SHOW CREATE TABLE tblname;
Best regards
Nils Valentin
Tokyo/Japan
2003 6 14 05:22Michael Conlen :
I'm working on a system that will allow me to perform operations on a
table using a web form, and I would like to know if a table has a
foreign key, however I don't seem to see this
I have read that Arrays are not coming before 5.0.
have a look in the Documentation and the UC presentations.
Best regards
NIls Valentin
Tokyo/Japan
2003 6 10 22:25Hans Nerdell :
table creation - arrays ?
how are rows as ARRAYS specified and created on a table ?
wbrgds
hans
On Friday 13 June 2003 09:29 pm, Mark Stringham wrote:
I'm querying a table of approximately 42 records based on 3 criteria. The
results are then displayed in a pop-up window. When the query is executed
the first time - the window opens and stalls for about 3 seconds before
the results are
How do I set no password for root?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I want to put some of my users database under their
home directory, is it possible to do that. If so can
any one point me to the right source.
Regards
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing
Hello Suba,
I assume that yo are using any linux OS and MyISAM tables.
I think you have several options. The two most common are:
1) you use the datadir option
2) you create symbolic links (ls command) to the users home directory and copy
the data (shutdown mysql server before ;-)
I havent
At 0:10 -0400 6/14/03, John Chang wrote:
How do I set no password for root?
mysql -u root -p
Enter password: (your current root password here)
mysql SET PASSWORD = '';
mysql quit
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?
At 21:19 -0700 6/13/03, Suba Arunkumar wrote:
I want to put some of my users database under their
home directory, is it possible to do that. If so can
any one point me to the right source.
Don't do it.
There is no advantage to doing this. The database directories
must be owned by the server in
Paul is right (I should have metnioned it as well ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003 6 14 13:40Paul DuBois :
At 21:19 -0700 6/13/03, Suba Arunkumar wrote:
I want to put some of my users database under their
home directory, is it possible to do that. If so can
any one point me
I changes the password but it still doesn't work. This is the error I get
when I try to connect to MySQL using phpmyadmin using a browser. What do
I need to change? Thanks.
Error
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
At 11:37 PM 6/13/2003 -0500,
John Chang wrote:
I changes the password but it still doesn't work. This is the error I
get when I try to connect to MySQL using phpmyadmin using a browser.
What do I need to change? Thanks.
Error
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
At 11:37 PM
Try 'mysqladmin flush-privileges'
--cut--
flush-privileges
Reload grant tables (same as reload)
--end cut--
then login (been there... Stuck there too...)
chris
-Original Message-
From: John Chang [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 14, 2003 12:17 AM
To:
It worked!!. Thanks. Now how do I protect it so that not anyone who
points to it cannot get to it without putting in a username/password?
At 12:24 AM 6/14/2003 -0500, John Nichel wrote:
John Chang wrote:
I changes the password but it still doesn't work. This is the error I
get when I try to
84 matches
Mail list logo