Hi there, ive been tyring to find a native provider for .NET , as I had
followed the .NET example via an article on the mysql site which uses
the ODBC connector, however it states on the mysql .NET info page that
ODBC is slower than a native provider. My issue is the bytefx provider
has an old
http://dev.mysql.com/downloads/connector/net/1.0.html
Looks like it got implemented into an official provoider, does this
mean I dont need MyODBC ?
On 09/03/2006, at 3:34 PM, Dan Rossi wrote:
Hi there, ive been tyring to find a native provider for .NET , as I
had followed the .NET example
yet just another multi-national gupling up its competitors, i stumbled
across this blog
http://golgote.freeflux.net/blog/archive/2005/10/08/oracle-buys-
innodb.html and had no idea, its just as bad the the latest Eola patent
case against microsoft and others its getting out of hand. What
Hi there i am looking for an alternative gui app than navicat for osx.
Ive used CocoaMysql in the past and is limited in terms of
administration, however has more working features than navicat ever
does.
I assumed this product was pretty good, however after purchasing boy
was i wrong. I
am sure
there will be others on this list if you don't want to deal with me any
more. But please take my advice and take the simpler, more direct
approach.
Respectfully,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Dan Rossi [EMAIL PROTECTED] wrote on 12/28/2005 11:55:35
Hi, im having some issues with a sub query in mysql5 , i have a field
which is storing a static comma seperate list of primary keys ie
1,2,3,4 , i am then trying to use that to find entries in another table
of the same primary keys here is the sql
SELECT count(*) FROM feeds WHERE feedID IN
Ok i have simplified my query into sections i have discovered that
mysql5 doesnt like user variables in a select statement when creating a
view, i am required to setup user variables so i can send the current
row value primary key to a sub query, i really wished i could just send
the field to
.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Dan Rossi [EMAIL PROTECTED] wrote on 12/28/2005 01:10:32 AM:
I have an unfinished query, i am trying to test, basically im required
to get the value of the current field in a row and use it for a
subquery in that row :| Its
in
subqueries), you normally use the actual column name in the subquery.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Dan Rossi [EMAIL PROTECTED] wrote on 12/28/2005 01:10:32 AM:
I have an unfinished query, i am trying to test, basically im
required
to get the value
feedID FROM producers_join WHERE producerID IN (producerID))
something like that, so if functions will work instead of variables for
sub queries and views, im still needing to send the primary key of the
current row to them somehow.
On 29/12/2005, at 3:31 PM, Dan Rossi wrote:
Btwi dont want
Hi there i am trying to use usewr variables in a select statement to
add to a where clause in a sub query. Ie
select @id:=id,@month:=month, (select SUM(totals) from table where
[EMAIL PROTECTED] and [EMAIL PROTECTED]) as totals from table
its happened on other occasions ie with calculations
INNER JOIN customers c ON fu.customerID=c.customerID
INNER JOIN feeds f ON fu.feedID=f.feedID WHERE f.feedID IN (SELECT
feedID FROM producers_join WHERE producerID IN (3)) GROUP BY
fu.month,fu.customerID ORDER BY fu.month DESC
END
On 28/12/2005, at 4:47 PM, [EMAIL PROTECTED] wrote:
Dan Rossi
Hi there I am experiencing a wierd bug in mysql 4.1 which is working in
Mysql5 beta where i am trying to run calculations on user variables. I
use these to pass values to sub queries.
FORMAT((IF(c.bandwidth_limit=0,
((c.monthly_price/@count)*f.percentage_paid)[EMAIL PROTECTED],
((@[EMAIL
Hi there somehow my AS field alias of a sub query is adding a dot at
the start therefore I cant use it in my application.
(SELECT SUM(feed_usage.bandwidth) AS bandwidth FROM feed_usage WHERE
customerID IN (57) AND
DATE_FORMAT(feed_usage.stats_date,'%m%Y')=DATE_FORMAT(NOW(),'%m%Y') )
AS
On 18/06/2005, at 4:28 AM, David Griffiths wrote:
Anandtech has an interesting article
(http://www.anandtech.com/IT/showdoc.aspx?i=2447) on hardware for
Linux database servers.
Some very interesting conclusions:
1) Moving to 64-bit MySQL on a 64-bit Xeon actually decreases
performance by
On 10/06/2005, at 8:09 PM, Martijn Tonies wrote:
For those interested, this makes a good read.
http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-
Eval.pdf
The Institute for Applied Knowledge Processing (http://www.faw.at)
in cooperation with Fabalabs Software GmbH
Import via odbc ?
I used an app called sqlyog to import via odbc.
On 09/06/2005, at 9:45 AM, Kirk wrote:
Is anyone familiar with how to dump a database from Microsoft sequel
server
to mysql? I know nothing about Microsoft products and am looking for a
utility or similar to do the
Hi there, I am having issues with this funny error message. I am trying
to do a sub query and then a group by clause on a date. However i keep
getting this annoying message for some reason. Happens via terminal
aswell as my sql gui. Here is the query I am trying to do
select (select
Hi there i am going to be attempting an insert on duplicate key update.
I am collecting stats log data and inserting the records into the
database however i am using a unique compound key on a special id and
the date the stats were generated. I want the database to insert a new
record when the
Thanks for your lengthy responses everyone. I ended up using sequences
which are available with PEAR MDB2 and DB, so i get the currentID + 1
while inserting, but as you say another entry could have gone in during
the process, but this happens during the insert stage. I might have to
revert
Hi there, I was wondering how its possible to get the MAX of a primary
key of a table during an insert. I basically want to create a ticket
number, but use the primary key as part of the ticket number ie
FAULT-001 or FAULT-0002 . I tried during a sub query on an
insert but obviouslly
sorry i'm gonna learn java soon but i only develop in php right this minute
thats my level :| , but the OO in java is similir to php so i an pick it up
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 12:15 AM
To: Daniel Rossi; [EMAIL
i cant seem to access the server times out :|
http://www.research.att.com/sw/tools/graphviz/download.html
-Original Message-
From: Nicholas [mailto:[EMAIL PROTECTED] Behalf Of
Nicholas Spagnoletti
Sent: Friday, April 04, 2003 1:28 AM
To: [EMAIL PROTECTED]
Subject: Re: table structure
Create a compound index on either (time, source_ip) or (source_ip,
time). Mysql cannot use two indexes on one table.
woah what are you saying here , that it cant have multiple indexes within a
table ?
and what is a compound index ?
say i have a table
products:
productID
product
storeID -index
hi i was wondering what the differences between the 2 servers with search
engine capabilties, also how does the full text indexing actually work ? i
am planning on a footage archive database, it could be titles, but it also
could be content aswell, text in titles are short so should be ok but
thanks heaps that works abosultely fine
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 6:00 PM
To: Daniel Rossi
Cc: [EMAIL PROTECTED]
Subject: RE: get table name from select staement as output as field
On 30-Mar-2003 Daniel Rossi wrote:
hi
hi dude yeh u have to append the page query to the current query ,
here is an example of my db class
http://electroteque.dyndns.org:1023/benchmark/DB.phps
down the page is the pagination u want in particular the url function
-Original Message-
From: Stitchin' [mailto:[EMAIL PROTECTED]
hi guys , i have posted here a few times already and i have trawled the list
archives and tried every tutorial on the topic without any luk , i am still
getting this error, why cant it read the master log saying it isnt open ?
the user i have used has ALL permissions, if i set log-bin in the slave
030308 8:09:29 Error reading packet from server: Binary log is not open
(server_
errno=1236)
030308 8:09:29 Got fatal error 1236: 'Binary log is not open' from master
when r
eading data from binary log
030308 8:09:29 Slave I/O thread exiting, read up to log 'FIRST', position
4
030308
http://www.databasejournal.com/features/mysql/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
/var/lib/mysql/ i think that path needs to writable 777 so it can write the
socket to it
-Original Message-
From: Harish B M (RBIN/ECM2) * [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 7:51 PM
To: '[EMAIL PROTECTED]'
Cc: Pemmaiah B D (RBIN/ECM2) *
Subject: Error while starting
hi guys i am still haveing the same problem has anyone experienced this
before ?
030305 08:33:36 mysqld started
030305 8:33:37 InnoDB: Started
/usr/local/etc/mysqlslave/libexec/mysqld: ready for connections.
Version: '4.0.11a-gamma' socket: '/usr/local/etc/mysqlslave/tmp/mysql.sock'
port:
-host=localhost
report-port=3307
server-id=2
-Original Message-
From: Dan Rossi [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 7:55 PM
To: [EMAIL PROTECTED]
Subject: RE: permissions error for the slave server
hi there my sql slave server cannot replicate as its getting
i'd download the lastest gamma release 4.0.11 ??
do a configure like so
./configure --prefix=/usr/local/etc/mysql --sysconfdir=/usr/local/etc/mysql
--exec-prefix=/usr/local/etc/mysql --with-unix-socket-path=/usr/local/etc/my
sql/tmp/mysql.sock --with-mysqld-user=mysql --with-innodb
then make
from server: Binary log is not open
(server_
errno=1236)
030303 8:43:30 Got fatal error 1236: 'Binary log is not open' from master
when r
eading data from binary log
030303 8:43:30 Slave I/O thread exiting, read up to log 'FIRST', position
4
-Original Message-
From: Dan Rossi [mailto
MySQL only supports one master and many slaves. In 4.x, we will add a
voting algorithm to automatically change master if something goes wrong with
the current master. We will also introduce 'agent' processes to help do load
balancing by sending select queries to different slaves.
i dont want to
i finally got mysql to login to the master server by adding log-bin in
my.cnf for the slave server , i can do a show slave status; and show master
status; so it all seems to be working but the tables on the slae dont seem
to wanna sync :| what could be the prob ?
hi there my sql slave server cannot replicate as its getting permissions
errors dont know what happened but its not happy now
030302 7:09:24 Slave I/O thread killed while connecting to master
030302 7:09:24 Slave I/O thread exiting, read up to log 'FIRST', position
4
030302 7:09:29 Slave
bit of a problem i installed a master server then i installed a slave server
in its own path
i try to start it up and i get this error
030302 2:12:44 Fatal error: Can't open privilege tables: Can't find file:
'./mys
ql/host.frm' (errno: 13)
i have done the mysql_install_db script
sorry it was a file permissions error, got both running now have to
recompile php though :|
-Original Message-
From: Dan Rossi [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 2:59 PM
To: [EMAIL PROTECTED]
Subject: replication slave startup
bit of a problem i installed a master
hi there i have been doing some test cases between master/slave , i have it
replicating but how is the slave meant to be used as the backup when the
master fails or better still how do i get the slave to share some of the
master sql server load ? atm i stopped the master on purpose to hopefully
PROTECTED],
Dan Rossi [EMAIL PROTECTED] writes:
hi i was wondering which statement is quicker getting results when joining
tables ? i presume something like FROM foo f LEFT JOIN bar b ON f.id=b.id
is
quiker than WHERE f.id=b.id ?
Your question does not make sense. A LEFT JOIN returns different
hi there , is it possible to have both slave and master on the same machine
? how do i go about setting that up for testing purposes ? sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
AM
To: Dan Rossi; [EMAIL PROTECTED]
Subject: RE: replication
At 9:42 +1100 2/28/03, Dan Rossi wrote:
hi there , is it possible to have both slave and master on the same machine
Sure.
? how do i go about setting that up for testing purposes ? sql
Same way you'd set up multiple servers even
hi there i was wondering if there was a must get mysql book or paper
covering query optimisation ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
hi i was wondering which statement is quicker getting results when joining
tables ? i presume something like FROM foo f LEFT JOIN bar b ON f.id=b.id is
quiker than WHERE f.id=b.id ?
SQL !! (ignore this)
-
Before posting,
yes i am aware that sub selects are in 4.1, i'm pretty sure i have it
running @ home, there are some large traffic sites i would like to lighten
up and make a bit faster code wise with query caching and sub selects, but i
havent been told what gamma means ?
-Original Message-
From: Josh
this is exactly what i am asking , when u say new gamma development
release (use this for new development) what does it all mean , is it
stable for production use ? i would like to know to convince work to start
using it ?
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
hi there i was wondering if mysql 4 will become production quality soon ? i
would like to convince work to start using it, so i can start using the
transactions, sub selects and query cache
-
Before posting, please check:
i know this may be an impatient ask , when will mysql 5 maybe release ? , i
was hoping to check out the stored procedures features, php 5 is on dev and
has started to use OO handling which is good to start coding for the future
rollover.
where can i find the free Solaris for intel they only have a free sparc
version :|
-Original Message-
From: [EMAIL PROTECTED] [mailto:jpw;Qenesis.com]
Sent: Friday, November 15, 2002 3:16 PM
To: [EMAIL PROTECTED]
Subject: Solutions to Solaris 8 Intel compile problems
Description:
i hate rpm's source code gcc all the way !
-Original Message-
From: Roger Davis [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 16, 2002 10:17 AM
To: [EMAIL PROTECTED]
Subject: RE: redhat 8.0
Redhat 8.0 includes mysql. Although it is not a part of the default
install, you can
FROM table1 t1 LEFT JOIN table2 t2 ON t1.field=t2.field
-Original Message-
From: John Meyer [mailto:johnmeyer_1978;yahoo.com]
Sent: Wednesday, November 13, 2002 8:14 AM
To: MySQL Mailinglist
Subject: RE: How to link tables in MySQL
AFAIK, MySQL doesn't have any sort of referential
here is a function i added to my pear DB abstraction class
function lastinsertID(){
$id = mysql_insert_id($this-connection);
return $id;
}
-Original Message-
From: Mark Stringham [mailto:mstringham;edeasolutions.com]
Sent: Monday, November 11, 2002 8:54 PM
To: [EMAIL
damn , i read it was 4.1 i guess we have to wait a bit then, i wish i could
program some c ++ to hurry it along a bit, i dont really have access to DB's
like oracle to learn stored procedure stuff
-Original Message-
From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net]
Sent:
asp can do allot of client side possibly security risky stuff where php cant
-Original Message-
From: Alan McDonald [mailto:alan;meta.com.au]
Sent: Monday, November 11, 2002 7:49 AM
To: [EMAIL PROTECTED]; Paul DuBois
Cc: MySQL
Subject: RE: PHP bias (Way OT)
I agree mostly,... but why is
ever heard of chilliasp ? its been cross platform portable , its hooked in
via java
-Original Message-
From: [EMAIL PROTECTED] [mailto:vanboers;why.dedserius.com]On
Behalf Of Van
Sent: Monday, November 11, 2002 8:01 AM
To: MySQL
Subject: Re: PHP bias (Way OT)
Alan:
ASP only runs on
grant all ?
-Original Message-
From: Shon Stephens [mailto:sstephens;corp.goamerica.net]
Sent: Saturday, November 09, 2002 1:46 AM
To: '[EMAIL PROTECTED]'
Subject: mysql permissions
i need to create a user (besides root) that can show databases, show tables
from every database, lock all
mysqladmin -u root password setpassword ? and dont use root for normal
access
-Original Message-
From: [EMAIL PROTECTED] [mailto:CZachary;wiley.com]
Sent: Saturday, November 09, 2002 2:51 AM
To: [EMAIL PROTECTED]
Subject: Error connecting to Mysql via Apache/PHP - Access Denied
(Newbie)
i used this mysql_fix_privilege_tables hoping it would migrate about 100
user database privileges, but it doesnt seem to have done the job what else
do i need to do ? as i said before i dont particularly want to have to reset
and regrant everyones passwords.
-Original Message-
From: Dan
never mind it worked now , had to restart the server heh
-Original Message-
From: Dan Rossi [mailto:daniel;electroteque.org]
Sent: Saturday, November 09, 2002 3:25 AM
To: Dan Rossi; [EMAIL PROTECTED]
Subject: RE: privileges when moving from mysql 3.23 to 4.0
i used
` varchar(255) NOT NULL default '',
PRIMARY KEY (`int_activity_id`),
UNIQUE KEY `int_activity_id` (`int_activity_id`),
KEY `vch_uniqid` (`vch_uniqid`)
) TYPE=MyISAM;
wot could be the prob ?
-Original Message-
From: Dan Rossi [mailto:daniel;electroteque.org]
Sent: Thursday, November
how is there a way to retain the user privileges in the mysql table when
dumping from mysql 3.23 to 4.0 ? i dont want to have to reset these
individually , let me know thanks
-
Before posting, please check:
hi having some issues dumping from mysql 3.23 to 4.0 getting table error
messages trying to import back into 4.0 sometimes i've had to change the
cell names ie group to groups somehow having a cell name group was causing
error :| sql
errors
, its impossible to change them or it'll break their sites
-Original Message-
From: gerald_clark [mailto:gerald_clark;suppliersystems.com]
Sent: Thursday, November 07, 2002 7:19 AM
To: Dan Rossi
Cc: [EMAIL PROTECTED]
Subject: Re: problems dumping from mysql 3.23 to 4.0
Group
mysqldump: Got error: 1030: Got error 127 from table handler when retrieving
data
from server
for some reason i get this when i dump all databases
using mysqldump -p --all-databases --add-drop-table --quote-names
all_databases.sql
66 matches
Mail list logo