Yes Ryan,
Shawn is wright... this is dark art... and few are experimenting it !
I did some dark art because of my need to get into *latin2
(latin2_general_ci)*.
Even though is adark art I do still there are people who know to answer
you... but i believe you were to vague...
Please be *more*
Hi
where can I download mysql workbench ? The links on the mysql forum dont
work ... and i cant seem to find another download ... probably not see the
wood for the treats ..
Thanks
--
Gregory Machin
[EMAIL PROTECTED]
[EMAIL PROTECTED]
www.linuxpro.co.za
www.exponent.co.za
Web Hosting Solutions
It's not on the mysql site yet Greg.
From [EMAIL PROTECTED] Sat Mar 4 23:00:04 2006
To: [EMAIL PROTECTED]
From: Alfredo Kengi Kojima [EMAIL PROTECTED]
Subject: ANNC: MySQL Workbench 1.0.5 beta released
MySQL Workbench 1.0.5 beta has been released.
MySQL Workbench is a database design tool
Hi,
How to check for the database owner for a particular database ? The way
show procedure status command lists the definer column, Is there a
command that shows the database owner. Similarly, what is the command to
see the owner of a table in a database ?
Thanks in advance,
Abdul.
Hm... It seems to me In MySQL there's no such thing as database owner.
Or am I missing something?
Mohammed Abdul Azeem пишет:
Hi,
How to check for the database owner for a particular database ? The way
show procedure status command lists the definer column, Is there a
command that shows the
Hi,
I don't understand how GRANTS are replicated in Mysql 4.0.26 (I can't
upgrade to a newer version).
The servers were all cleanly installed from scratch (not upgraded) using
Mysql's 4.0.26 official rpm.
According to the manual GRANT statements should be replicated and after
executing
'flush
Josh wrote:
I posted this same item on the mysql forum but the
only place that looked remotely appropriate was under
the Newbie section... I'm not sure if it will be
answer there so I thought I might toss it out here to
see if there were any takers.
I'm baffled as to why this stored procedure
Good morning all,
We have 12 customer lists: CA01, CA02,
.,CA12.
Table: customerList
+---+--+
| list_name | id |
+---+--+
|CA10 | 20BE |
|CA07 | 20BE |
|CA11 | 20BE |
|CA03 | 20BE |
|CA10 | NQCR |
|CA04 | NQCR |
|CA02
Peter, nice catch. Changing the parameter names did
the trick. Thanks.
--- Peter Brawley [EMAIL PROTECTED] wrote:
Josh wrote:
I posted this same item on the mysql forum but the
only place that looked remotely appropriate was
under
the Newbie section... I'm not sure if it will be
[EMAIL PROTECTED] wrote on 03/10/2006 04:02:11 AM:
It's not on the mysql site yet Greg.
From [EMAIL PROTECTED] Sat Mar 4 23:00:04 2006
To: [EMAIL PROTECTED]
From: Alfredo Kengi Kojima [EMAIL PROTECTED]
Subject: ANNC: MySQL Workbench 1.0.5 beta released
MySQL Workbench 1.0.5 beta
Hi Dan,
Noted with thanks.
As such, is there a workaround to log problematic sql queries ran against
the mysqld server ? Do I need to write separate script to do this ?
Regards,
Ryan.
On 3/10/06, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Mar 08), ryan lwf said:
I
Косов Евгений [EMAIL PROTECTED] wrote on 03/10/2006 07:53:37 AM:
Hm... It seems to me In MySQL there's no such thing as database owner.
Or am I missing something?
Mohammed Abdul Azeem пишет:
Hi,
How to check for the database owner for a particular database ? The
way
show
Here's one method:
SELECT cl1.list_name, count(*) as count
FROM customerList cl1
WHERE cl1.id IN (SELECT cl2.id FROM customerList cl2
WHERE cl2.list_name='CA10')
and cl1.list_name != 'CA10'
GROUP BY cl1.list_name
--- Yesmin Patwary [EMAIL PROTECTED] wrote:
Good morning all,
We
as you know mysql gives you an error to check your sql syntax when it
doesn't understand a query but does not log it , but you can have your
application (php, perl, etc ) accessing mysql to log any bad/malformed
queries...
Kishore Jalleda
On 3/10/06, ryan lwf [EMAIL PROTECTED] wrote:
Hi Dan,
In PHP, you can see the error message as follows:
$result = mysql_query($sSQL) or die (br.mysql_error()
.brbr.$sSQL);
Just change it to write that mysql_error() to a file instead and that'll do
it. So, something like:
$result = mysql_query($sSQL) or die ( log_error(mysql_error()) );
I have just installed MySQL 5.0, and I am unable to connect to it from my
own (remote) machine. It all works fine when I open mysqladmin from the
server itself, so I know the installation is OK. I am working on a small
LAN of about 15 PCs. When I try to telnet to the default port (3306), I get
Sara Woglom wrote:
I have just installed MySQL 5.0, and I am unable to connect to it from my
own (remote) machine. It all works fine when I open mysqladmin from the
server itself, so I know the installation is OK. I am working on a small
LAN of about 15 PCs. When I try to telnet to the
There are some scripts that help us to save logs,
For example: log4php
You write your app and when you're testing it you define a level to save the
errors into a file and display them in your app but in production the client
doesn't have to see the errors, only the developers, so, in your
Hello,
I have been given a file to import into the mysql 5.0 database.
This is how it is formatted:
I created a database called app which is brand new.
Right off, the bat, I noticed there is a field called numeric. So I
changed that to int.
But when I try and import it, it is
Thanks Shawn!!
Here is some more pertinent information:
* The server is running on Windows 2003 Server SP-1
* There is no switch between me and the server
* I don't know the firewall program, and don't really know how to find out;
I checked Program Files and running processes but nothing
Scott Purcell [EMAIL PROTECTED] wrote on 03/10/2006 12:28:21 PM:
Hello,
I have been given a file to import into the mysql 5.0 database.
This is how it is formatted:
I created a database called app which is brand new.
Right off, the bat, I noticed there is a field called numeric. So I
On 3/7/06, C.R.Vegelin [EMAIL PROTECTED] wrote:
Hi Ariel,
Maybe this example helps you to create CSV output from MySQL.
The first SELECT generates the headerline; the second the data.
( SELECT 'FieldA','FieldB','FieldC', ... )
UNION
( SELECT `FieldA`, `FieldB`, `FieldC`, ...
INTO OUTFILE
In my reading of mysql tutorials I see many examples of mysql access
with out first doing a connect. Comments say something about reusing
open connections for faster processing and less resources usage
overhead. What are they talking about what code do I need to make
this happen?
--
MySQL
fbsd_user [EMAIL PROTECTED] wrote on 03/10/2006 02:18:49 PM:
In my reading of mysql tutorials I see many examples of mysql access
with out first doing a connect. Comments say something about reusing
open connections for faster processing and less resources usage
overhead. What are they
once a client connects to the server, mysql opens a (TCP/IP or Socket)
connection for the client, but after it has serviced the client , mysql
still keeps the connection open (thread is in sleep state) for some time
depending on the variable wait_timeout value anticipating more requests
from the
I am getting this error and I do not know why?
Could not connect: Client does not support authentication protocol
requested by server; consider upgrading MySQL client
I can access mysql from the command line and I can access it from
mysql Administrator. When I run a php program I get an error.
I
Hi!
Server system SBS (Novell Small Business suite) 6.5 sp 1 with MySQL
ver. 4.0.15a, PHP 4.2.3, all of them on same machine.
I just finished create a new DB called TIULIM (InnoDB) with 3 tables
(Sites, Tracks Pathes).
Now, using MySQL Query Browser ver. 1.1.15, I'm trying to build FOREIGN
Nestor [EMAIL PROTECTED] wrote on 03/10/2006 02:33:50 PM:
I am getting this error and I do not know why?
Could not connect: Client does not support authentication protocol
requested by server; consider upgrading MySQL client
I can access mysql from the command line and I can access it from
Nanu Kalmanovitz [EMAIL PROTECTED] wrote on 03/10/2006 02:35:08
PM:
Hi!
Server system SBS (Novell Small Business suite) 6.5 sp 1 with MySQL
ver. 4.0.15a, PHP 4.2.3, all of them on same machine.
I just finished create a new DB called TIULIM (InnoDB) with 3 tables
(Sites, Tracks Pathes).
I´ve found this on internet:
If you re-create a table which was dropped, it has to have a definition
which conforms to the foreign key constraints referencing it. It must have
the right column names and types, and it must have indexes on the referenced
keys, as stated above. If these are not
I need help, I'm somewhat new to indexing, I am joining two tables and
need to optimize the speed of the query. I'm running the NDB storage
engine so the foreign key stuff is disabled. With that in mind, here's
the query and additional comments below:
SELECT COUNT(*) Count FROM
Cory at SkyVantage wrote:
I need help, I'm somewhat new to indexing, I am joining two tables and
need to optimize the speed of the query. I'm running the NDB storage
engine so the foreign key stuff is disabled. With that in mind,
here's the query and additional comments below:
SELECT
gerald_clark wrote:
Cory at SkyVantage wrote:
*** 1. row ***
id: 1
select_type: SIMPLE
table: status
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
rows: 100
Extra:
Cory at SkyVantage [EMAIL PROTECTED] wrote on 03/10/2006 03:52:56 PM:
I need help, I'm somewhat new to indexing, I am joining two tables and
need to optimize the speed of the query. I'm running the NDB storage
engine so the foreign key stuff is disabled. With that in mind, here's
the
I have a process that has been running for more than 7080 seconds and
have sent a kill signal to the process more than 30 minutes ago.
kill query id#.
Is there something I'm missing?
Show full processlist:
3294878 usergpiexp01sea 7207 Killed UPDATE
parts SET prtStocked
Cory at SkyVantage wrote:
gerald_clark wrote:
Cory at SkyVantage wrote:
*** 1. row ***
id: 1
select_type: SIMPLE
table: status
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
Hi,
MySQL 5.0.19, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at http://dev.mysql.com/downloads/ and mirror sites.
Note that not all
[EMAIL PROTECTED] wrote:
Can you post the results of SHOW CREATE TABLE pnr_segments, please
pnr_segments | CREATE TABLE `pnr_segments` (
`ID` bigint(20) NOT NULL auto_increment,
`ID_pnr` bigint(20) NOT NULL,
`ID_pnr_fares` bigint(20) NOT NULL,
`flight_number` int(10) unsigned NOT NULL,
gerald_clark wrote:
How many possible values may res_status have? What percentage for
each value? It may not be possible to use an index on this field.
The res_status field may have up to 10 different values from 0-9. and
there will be a huge amounts of '0' and thousands of records with 1-9
Cory at SkyVantage wrote:
gerald_clark wrote:
How many possible values may res_status have? What percentage for
each value? It may not be possible to use an index on this field.
The res_status field may have up to 10 different values from 0-9. and
there will be a huge amounts of '0' and
Cory at SkyVantage [EMAIL PROTECTED] wrote on 03/10/2006 04:25:00 PM:
[EMAIL PROTECTED] wrote:
Can you post the results of SHOW CREATE TABLE pnr_segments, please
pnr_segments | CREATE TABLE `pnr_segments` (
`ID` bigint(20) NOT NULL auto_increment,
`ID_pnr` bigint(20) NOT NULL,
Just curious, what cron jobs do you schedule for automatically
checking/repairing/analyzing/optimizing MyISAM tables?
I have been doing this periodically, manually for a while, but I
figured cron is the way to go.
Also, what parameters are you using? I am thinking of running the
If you use the 5.1 tree, you should be able to use the new EVENT stuff
to accomplish this:
http://dev.mysql.com/doc/refman/5.1/en/events.html
CREATE EVENT check_table ON SCHEDULE AT '2006-03-10 19:00:00' EVERY
WEEK DO your_check_table_procedure_here();
Or something like that..
On 3/10/06, René
In the last episode (Mar 10), Ren Fournier said:
Just curious, what cron jobs do you schedule for automatically
checking/repairing/analyzing/optimizing MyISAM tables?
I have been doing this periodically, manually for a while, but I
figured cron is the way to go.
Also, what parameters are
44 matches
Mail list logo
