Virus Database: 267.13.0/167 - Release Date: 11/11/2005
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
-
nks
Horst
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 269-1555 Baltimore,
Hello.
so why does 'explain select * from files where
(pathref,version)=(129286,0);' scan the whole table?
It is documented that this syntax can't be optimized yet. See:
http://dev.mysql.com/doc/mysql/en/row-subqueries.html
Jason Pyeron <[EMAIL PROTECTED]> wrote:
On
On Tue, 6 Sep 2005, Dan Nelson wrote:
In the last episode (Sep 06), Jason Pyeron said:
there is an unique key index 'pathref_2 (pathref,version)' on this
table.
so why does 'explain select * from files where
(pathref,version)=(129286,0);' scan the whole table?
I have t
+-+--+---+
1 row in set (0.00 sec)
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100
:24 PM, Jason Pyeron wrote:
mysqladmin is truncating the output, how can i disable this?
or is there a better way to examine what the serer is executing at that
moment in time?
[EMAIL PROTECTED] root]# mysqladmin p
|
+-+---++---+-+--+--+--+
[EMAIL PROTECTED] root]#
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron
primary key field...
Once you do that, you can rename the field, and then reinitiate it as a
primary keyfield.
M i l e s.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron
Is there a way to rename an index without droping it?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager
i<10; ++i)
{
for (int ii=0; ii<10; ++ii)
{
String val=cnumbers[i]+cnumbers[ii];
stmt.setString(1,val);
stmt.setString(2,val);
stmt.executeUpdate();
}
}
System.err.println("Now fail on 100");
String val=cnumbers[1]+cnumbers[0]+cnumbers[0];
stmt.setStri
l 4.x
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryl
ents is interpreted as
number of characters. Take this into account when specifying a prefix
length for a column that uses a multi-byte character set.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason
all the parent dirs +x ?
what is the ouput is the show databases?
On Sat, 3 Sep 2005, Brian Dunning wrote:
On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote:
it could be that the permissions are wrong, too.
The permissions for all the files in there are -rwxrwxr-x ...I don't know if
t
could be that the permissions are wrong, too.
On Sat, 3 Sep 2005, Jason Pyeron wrote:
are there backups of this machine?
do you have administrator access?
does kessler/products.frm still exist? [likely:
/var/lib/mysql/kessler/products.frm]
On Sat, 3 Sep 2005, Brian Dunning wrote:
My web site
Can someone please
suggest a next step?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-03
athtypes (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
-
subIndex_gb.template;
};
};
};
|---
---
---
---
---
--+
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-
rkarounds?
Any ideas? TIA
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381
g 2005, Chris wrote:
Because you're asking how many rows are in those tables and it has a reply?
Jason Pyeron wrote:
mysql> select count(*) paths;
+---+
| paths |
+---+
| 0 |
+---+
1 row in set (0.00 sec)
mysql> select count(*) files;
+---+
| files |
+---+
|
00 sec)
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Mary
resize later without taking the
system down.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24
TECTED] AS `count`, `value` FROM `table`;
I can't execute more select in my system. (Delphi software) :(
Only 1 select allowed! Because it is the reporting system...
1 output is 1 select!
Best Regards!
Zoli
- Original Message ----- From: "Jason Pyeron" <[EMAIL PROTECTED]>
able, pick any reason.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381
?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 2
depending on your db config you might be able to do this outside of sql by
parsing the binary log. It is a history of updates to the database, in
chronological order.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-
you start the daily process.
http://dev.mysql.com/doc/mysql/en/backup.html
you can rsync the bin logs.
our server flushes 4 times a day for the backup script.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-
e may have to make up some for MySQL 5.x
-Jason Pyeron
On Tue, 23 Aug 2005, Bing Du wrote:
Hi,
When I run a Perl script that uses DBI and DBD::mysql on a RHEL 3 machine,
I got this error:
==
Can't load
'/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mys
f the
necessary libraries and includes? I have never ventured into the rpm realm so
I am not sure if they give me the same flexibility that compiling does.
Jason Pyeron wrote:
Just curious, why not use the rpm to install?
We use RHEL3 and RHEL4 here, every thing is done by rpm.
Is something mi
Just curious, why not use the rpm to install?
We use RHEL3 and RHEL4 here, every thing is done by rpm.
Is something missing? If so could you let us know, I would like to get the
rpms patched.
-Jason Pyeron
st Regards,
Rafal
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1
t
something to think about.
Using Innodb, for transactions.
-jason
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Mana
ed something vital to
the question? It's been one of those days for me.
Jason Pyeron <[EMAIL PROTECTED]> wrote on 08/16/2005 02:15:34 PM:
http://www.cs.purdue.edu/homes/trinkle/RCS/
RCS does not use MySQL or any other SQL engine.
I am looking to use a SQL backend for RCS.
RCS is a
sorry,
RCS= Revision Control Sytems
it is what backends things like cvs.
and yes user defined functions
http://www.cs.purdue.edu/homes/trinkle/RCS/
On Tue, 16 Aug 2005 [EMAIL PROTECTED] wrote:
Jason Pyeron <[EMAIL PROTECTED]> wrote on 08/16/2005 01:01:03 PM:
Anyone out there hear
Anyone out there heard of a rcs udf (or similar) for MySQL?
Google is not being nice to me, too much noise in the results.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron
ideas how to change this?
Which version of the Conenctor J are you using?, is it the latest?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us
How would you handle such a task?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #
On Fri, 12 Aug 2005, Jay Blanchard wrote:
Yes. Linux will consistently outperform Windows in many areas.
Except Dilbert's boss's approval queue.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-
r even better: have this information sent to syslog?
(using mysql 4.1)
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Stree
lso explain why so slow?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1
o other mention, and I can't recall seeing anything on the
list about it. Can anyone perform a quick test or verify one way or the
other? I'd be much obliged.
Thanks!
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-
OS before for production ? Success story?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th St
why does this list not have the reply to header set?
-jason pyeron
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Man
e,
http://dev.mysql.com/doc/mysql/en/blob.html
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443)
not images - so I am hoping
that MySQL can indeed deal with BLOBs ok ?
Andy
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner &
is no need to pass the -h
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
kets altogether
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381
date,level) ?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore,
an storing it in an option file?
Storing in an option file didn't work, so I use this option.
Could you please explain storing in an option file did not work?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-
I have make going right now, but does anyone have any suggestions?
google was not much help for 4.1.x
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http
t a function for this situation?)
Tnx!
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th St
you can find what you need here:
http://public.pdinc.us/rpms/mysql
please email the list with questions and comments
-Jason Pyeron
On Tue, 26 Jul 2005, Jeff wrote:
I've got a brand new dell server with RedHat ES3 on it.
As usuall it came pre-installed with mysql 3.23.
Trying to up
isfield`.`bvolset` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
mysql>
but the FK is not enforced, another day to tacle that.
Jason Pyeron <[EMAIL PROTECTED]> wrote:
any ideas on this? google has not helped.
can temp tables be innodb? can they have fk?
mysq
rences bvolset(id)
-> ) engine=innodb;
ERROR 1005: Can't create table
'c:\docume~1\admini~1\locals~1\temp\#sql640_41_1.frm' (errno: 150)
mysql> create temporary table bvolsetparents
-> (id int);
Query OK, 0 rows affected (0.48 sec)
--
-=-=-=-=-=-=-=-=-=-=-=-=-=
<><
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, M
les.ibd' (errno: 1)
|
+-++--+-+
files.ibd does not exist on the system.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
I am willing to give up on my data recovery efforts if I can just get the
schema from the dead tables, any suggestions?
Sincerely,
Jason Pyeron
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason
07:04 10,485,760 ibdata1
07/05/2005 07:04 18,874,368 ib_logfile0
07/05/2005 06:54 18,874,368 ib_logfile1
any ideas?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason P
e of MySQL.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore,
No the user is still the same, there are just no innodb files. ?anymore?
On Mon, 4 Jul 2005, Gleb Paharenko wrote:
Hello.
[EMAIL PROTECTED] gleb]$ perror 1
OS error code 1: Operation not permitted
Do you run new MySQL service under different user account?
Jason Pyeron <[EMAIL PROTEC
ata location. DOH!!!
TIA
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381
rpm -i MySQL-Max.rpm
solved it
On Sun, 23 Nov 2003, Jason Pyeron wrote:
> Our old lcs.MYSQL.so from MySQL 3.23 give the same garbage out.
> This has worked on many RedHat 7.3 / MySQL 3.23.xx boxes.
>
> On Sun, 23 Nov 2003, Jason Pyeron wrote:
>
> >
> > I have never
Our old lcs.MYSQL.so from MySQL 3.23 give the same garbage out.
This has worked on many RedHat 7.3 / MySQL 3.23.xx boxes.
On Sun, 23 Nov 2003, Jason Pyeron wrote:
>
> I have never seen an error like this one, are the RPMs setup for dynamic
> libraries?
>
> ERROR 1126: Ca
I have never seen an error like this one, are the RPMs setup for dynamic
libraries?
ERROR 1126: Can't open shared library 'diff.so' (errno: 0
/lib/tls/libc.so.6: unexpected reloc type 0x0$ôç¿_½)
Sincerely
63 matches
Mail list logo