Simon Garner wrote:
On 2/05/2005 5:21 p.m., Mark Sargent wrote:
Hi All,
I did this below,
mysqlSET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka');
and then tried logging on,
[EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka
ERROR 1251: Client does not support
On 2/05/2005 6:05 p.m., Mark Sargent wrote:
Hi All,
master/client are the same machine. I installed via tar.gz, ver 4.1
following this page
http://dev.mysql.com/doc/mysql/en/installing-binary.html
for installation on FC3. Why would it say that the client doesn't
support it.? Cheers.
P.S. I now
Mark Sargent wrote:
Simon Garner wrote:
On 2/05/2005 5:21 p.m., Mark Sargent wrote:
Hi All,
I did this below,
mysqlSET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka');
and then tried logging on,
[EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka
ERROR 1251: Client
Hi:
I am using mysql 4.1.10 for a while now, and i was wondering how
painful it would be to tweak the mysqldump to support an additional
option, --insert-ignore , which instructs it to create the dump files
with
INSERT IGNORE blah blah
instead of just
INSERT blah blah
i have actually modified
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line
:= 'TRUE'
CREATE PROCEDURE cart_items_validate
(IN mcustid INT ,IN mprodid varchar(10),
OUT mvalidate varchar(10))
BEGIN
DECLARE rowexists
Simon Garner wrote:
On 2/05/2005 6:05 p.m., Mark Sargent wrote:
Hi All,
master/client are the same machine. I installed via tar.gz, ver 4.1
following this page
http://dev.mysql.com/doc/mysql/en/installing-binary.html
for installation on FC3. Why would it say that the client doesn't
support it.?
Shawn could you please contact me by e-mail?
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Geoffrey, Chris,
- Original Message -
From: Chris [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, May 01, 2005 5:26 AM
Subject: Re: Disappearing .frm files ?
Geoffrey R. Thompson wrote:
...
Things have been fine until recently, when the .frm files for these tables
Marcin,
- Original Message -
From: Marcin Lewandowski [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, May 01, 2005 7:25 PM
Subject: Synchronizing InnoDB tables
Hi,
I want to use InnoDB tables in my project, because I can use
transactions with them.
I would write a
Mark Sargent wrote:
Simon Garner wrote:
On 2/05/2005 6:05 p.m., Mark Sargent wrote:
Hi All,
master/client are the same machine. I installed via tar.gz, ver 4.1
following this page
http://dev.mysql.com/doc/mysql/en/installing-binary.html
for installation on FC3. Why would it say that the client
Mark Sargent wrote:
Mark Sargent wrote:
Simon Garner wrote:
On 2/05/2005 5:21 p.m., Mark Sargent wrote:
Hi All,
I did this below,
mysqlSET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka');
and then tried logging on,
[EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka
Hello,
http://dev.mysql.com/doc/mysql/en/crashing.html
I decided to create a bug report as this list is rather for resolving
common problems than discussing about the mysql development.
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Mathias/Everyone on the list
I am running the following query against the database:
SELECT demographic.demographic_no, demographic.first_name,
demographic.last_name, demographic.chart_no, demographic.sex,
demographic.year_of_birth, demographic.month_of_birth,
demographic.date_of_birth,
Hi All,
if this script is in scripts by default, why does it have the following
code,
test -z $ldata ldata=./data
if test -z $basedir
then
basedir=.
bindir=./bin
execdir=./bin
pkgdatadir=./support-files
else
bindir=$basedir/bin
if test -x $basedir/libexec/mysqld
then
You should never just upgrade your system. Always find where the
bottleneck is first. If it's RAM, then you just need to add more. If
it's I/O, you need to add/change your disks.
Those numbers don't seem that high for the hardware you have. You
should try changing some configuration variables
Scott Klarenbach [EMAIL PROTECTED] wrote on 04/29/2005 05:39:36
PM:
Thanks Shawn, that helps a lot. I like your general idea of handling
it at application level. I guess my main concern w/ web apps and
locking the record (even at app level) is orphaned locks, resulting
from browser closes
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote on 05/01/2005
07:14:57 PM:
I created a mysqldump with --quote-names option, but I get this
error:C:\xampp\xampp\mysql\bingt;mysql -uroot db2 lt; test5.
txtERROR 1005 at line 54: Can't create table '.\db2\shift.frm'
(errno:
madderla sreedhar [EMAIL PROTECTED] wrote on 05/02/2005 03:10:07 AM:
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line
:= 'TRUE'
CREATE PROCEDURE cart_items_validate
(IN mcustid INT
Madderla,
1. Var assignments need SET, ie SET mvariable = ...
2. Missing semicolon after 'TRUE'
PB
-
madderla sreedhar wrote:
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line
:= 'TRUE'
Schalk,
Your query looks ok except for an apparently missing '%' in LIKE 'TES',
but all the WHEREs are hard to read, aren't they? I find queries easier
to write, read maintain with joins in the JOIN clause and specific
row-selection criteria in the WHERE clause, eg
SELECT
Mark Sargent wrote:
[EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka
ERROR 1251: Client does not support authentication protocol requested
by server; consider upgrading MySQL client
What is this..? Why is it asking me to upgrade the client.? Cheers.
master/client are
Shawn, Madderla,
Don't you need to DECLARE the variable "mvalidate" before you can
use it?
It's declared as OUT mvalidate varchar(10).
PB
-
[EMAIL PROTECTED] wrote:
madderla sreedhar [EMAIL PROTECTED] wrote on 05/02/2005 03:10:07 AM:
Can u please execute the following
Schalk Neethling wrote:
Mathias/Everyone on the list
I am running the following query against the database:
SELECT demographic.demographic_no, demographic.first_name,
demographic.last_name, demographic.chart_no, demographic.sex,
demographic.year_of_birth, demographic.month_of_birth,
Dana Sun, 1 May 2005 11:11:40 -0700, Jeremiah Gowdy rece:
Where could I find speciffication of how MySQL client and server
communicate?
/...
Look at the source code of libmysql?
So, document regarding this protocol doesn't exist?
Hm, and, where could I find the source code of libmysql? I
Hassan Schroeder wrote:
Mark Sargent wrote:
[EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka
ERROR 1251: Client does not support authentication protocol
requested by server; consider upgrading MySQL client
What is this..? Why is it asking me to upgrade the client.?
Where could I find speciffication of how MySQL client and server
communicate?
/...
Look at the source code of libmysql?
So, document regarding this protocol doesn't exist?
I didn't say that. I don't know of such a document, but I have never heard
of it. However, since the protocol can change
Thanks for your help, that's going to work great!
sk
On 5/2/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott Klarenbach [EMAIL PROTECTED] wrote on 04/29/2005 05:39:36
PM:
Thanks Shawn, that helps a lot. I like your general idea of handling
it at application level. I guess my
hi,all.
i can't start mysqld anymore , it's log reports below:
050503 00:09:58 mysqld started
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This
Mark Sargent wrote:
h, that is annoying, as I did a yum remove mysql b4 installing 4.1.
Shouldn't the yum remove, remove it fully..?
Sorry, can't help there, don't know anything about 'yum'.
[EMAIL PROTECTED] ~]# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
We're running an application that creates table names in a numeric
sequence. For example:
jst998_foo
jst998_bar
jst999_foo
jst999_bar
jst0001000_foo
jst0001000_bar
jst0001001_foo
jst0001001_bar
I need to write a maintenance app that first needs to determine the
numeric range of
I don't remember what commands are available in 3.21 but try these
show tables like 'table_name';
then check mysql_num_rows on the result.
describe table;
check mysql_num_rows
show tables;
then pick out the table name;
3.21 is old as alabama (forrest gump) it's time for an upgrade :)
Jim McAtee
Hey, thanks.
show tables like 'jst%_foo'
looks like it would work just fine. Two questions:
What is the column name returned and can I do an ORDER BY? If so, then I
can just check the first and last rows in the results to determine the
numeric range.
My bad - server version is 3.23.x.
The column name is Tables_in_mysql. show syntax doesn't support order
by. Information_schema tables in 5.0 do because they use the normal
select syntax.
-Eric
Jim McAtee wrote:
Hey, thanks.
show tables like 'jst%_foo'
looks like it would work just fine. Two questions:
What is the column name
Hi everyone,
Is anyone aware of any differences on how joins work for:
Ver 14.7 Distrib 4.1.10a, for sun-solaris2.9 (sparc) vs. Ver 11.13
Distrib 3.23.36, for sun-solaris2.7 (sparc)
Regards,
Mikhail Berman
[snip]
Is anyone aware of any differences on how joins work for:
Ver 14.7 Distrib 4.1.10a, for sun-solaris2.9 (sparc) vs. Ver 11.13
Distrib 3.23.36, for sun-solaris2.7 (sparc)
[/snip]
Have you found an issue? JOINs should pretty much be the same.
--
MySQL General Mailing List
For list
We are having some problems with movement of data from v3.23 to v.4.1.
What was working in lower version does not working in higher.
Mikhail
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Monday, May 02, 2005 2:06 PM
To: Berman, Mikhail; mysql@lists.mysql.com
- Original Message -
From: Eric Jensen [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Sent: Monday, May 02, 2005 11:19 AM
Subject: Re: Sum of a Count
Rhino wrote:
I'm not entirely sure I know what you're asking when you say that you
want
to group a field together with COUNT().
If
Hi,
We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux for
our data
warehouse. I have a group of tables (9/2004 through 2/2005) that average
about 95 million rows (215 byte rows). Using PERL and piping to mysql
LOAD DATA is the way we've been loading. That all worked as
[snip]
We are having some problems with movement of data from v3.23 to v.4.1.
What was working in lower version does not working in higher.
[/snip]
Can you give an example of the query that you are running?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
which sytem table is checked when 'show tables'
command is executed in MYSQL ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives:
[EMAIL PROTECTED] wrote:
Hi,
We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux for our data
warehouse. I have a group of tables (9/2004 through 2/2005) that average
about 95 million rows (215 byte rows). Using PERL and piping to mysql
LOAD DATA is the way we've been loading.
V. Agarwal [EMAIL PROTECTED] wrote on 05/02/2005 02:26:28 PM:
which sytem table is checked when 'show tables'
command is executed in MYSQL ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
which sytem table is checked when 'show tables'
command is executed in MYSQL ?
Before 5.03 it's just an internal MySQL command. Since 5.03 it's a View
defined in the information_schema virtual database. In neither case is
it a physical table.
PB
-
V. Agarwal wrote:
which sytem table is
Thank you everyone for help.
We have figure out differences in our scripts. They were NOT related to
JOINs.
Regards,
Mikhail Berman
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Monday, May 02, 2005 2:12 PM
To: Berman, Mikhail; mysql@lists.mysql.com
Subject:
Hi List,
I was checking the list of collations for a character set latin that I
have in my MySQL version 4.1.10-standard running on Mac OS X 10.4.
Below is the that I have and does not include latin1_general_cs. What
will happen if I force to use it when I create a database, tables and
fields?
At 15:28 -0400 5/2/05, Andre Matos wrote:
Hi List,
I was checking the list of collations for a character set latin that I
have in my MySQL version 4.1.10-standard running on Mac OS X 10.4.
Below is the that I have and does not include latin1_general_cs. What
will happen if I force to use it when I
Hi Paul,
It does appear in the list, but there is no Yes in the column Compiled
and that's why my concern. I am using the Collation latin1_general_cs
since I moved from version 3.x to 4.1.10. Is it really working without
compiled?
Andre
On 5/2/05 4:04 PM, Paul DuBois [EMAIL PROTECTED] wrote:
Hi
I now how to use delete together with a WHERE statement. But e.g. after
some warnings revealed me certain rows being inconsisent, and I want to
delete them- how can I do this? I just know that I want to delete e.g
row 1433 (I have no special id)
thanks for a hint
cheers
christoph
--
MySQL
At 16:15 -0400 5/2/05, Andre Matos wrote:
Hi Paul,
It does appear in the list, but there is no Yes in the column Compiled
and that's why my concern. I am using the Collation latin1_general_cs
since I moved from version 3.x to 4.1.10. Is it really working without
compiled?
Yes. Some character set
Ok Paul.
Do you have any idea why phpMyAdmin removed the latin1_general_cs from the
collation pop-up list?
I have the same problem like this one (except that I am using Mac OS X):
http://forums.mysql.com/read.php?11,21462,21462
I looked at the release notes for the version 2.6.2 (it was
- Original Message -
From: V. Agarwal [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, May 02, 2005 2:26 PM
Subject: table that keeps info on tables in a DB
which sytem table is checked when 'show tables'
command is executed in MYSQL ?
If you want to get information about
- Original Message -
From: Christoph Lehmann [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, May 02, 2005 5:41 PM
Subject: newbie: delete row xy
Hi
I now how to use delete together with a WHERE statement. But e.g. after
some warnings revealed me certain rows being
At 17:01 -0400 5/2/05, Andre Matos wrote:
Ok Paul.
Do you have any idea why phpMyAdmin removed the latin1_general_cs from the
collation pop-up list?
No.
I have the same problem like this one (except that I am using Mac OS X):
http://forums.mysql.com/read.php?11,21462,21462
I looked at the release
I want to delete e.g row 1433
There is NO row 1433!
1433 would depend upon which column(s) specified in ORDER BY clause.
A table is a collection and a collection has NO inherent order.
On 5/2/05, Christoph Lehmann [EMAIL PROTECTED] wrote:
Hi
I now how to use delete together with a WHERE
Hello,
Sorry for the slightly OT question :)
Hoping we have some expert MySQL Function to perl function people on the list.
Is there an equivelant function in perl for converting IP's, the same as MySQL
functions: INET_ATON('IP_ADDRESS_STR') and INET_NTOA('STR')
TIA,
--
Mike(mickalo)Blezien
Number of processes running now: 0
050502 20:31:26 mysqld restarted
050502 20:31:27 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 301734057
InnoDB: Doing recovery: scanned up
At 11:48 +1000 5/3/05, Daniel Kasak wrote:
Number of processes running now: 0
050502 20:31:26 mysqld restarted
050502 20:31:27 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0
I am current working with mysql 3.23 on Red Hat 9.0
in the process of moving to slackware 10.0 on same
machine, different partition. The version on the Slackwae
partition is 4.0.2*.
Question:
Will I be able to simply mysqldump my mysql database on
the RH 9.0 partion and then load the mysql DB on
58 matches
Mail list logo