> In my network there are one master 4.0.13 and 3 slaves with 4.0.15.
>
> STarting the slaves's update to 4.0.15 from 4.0.13 during the night when on
> the master there are not update I read on slaves's logs as follow:
>
> 30918 3:41:06 Error reading packet from server: Lost connection to MyS
Dear Ladies and Sirs,
I tried
SELECT * FROM WHERE LIKE '%ü%';
to find out if german umlauts (öäü) are imported.
In the resultset where some ds with 'ü' and some with 'y'.
So the charset itself seems to be OK but why did I get 'y'.
They sound sometimes the same, but they are not the same.
How c
I wonder if my user can follow section 1.7.4.1 in mysql.com for what he wants to
do without me upgrading the MySQL from 4.0.x to 4.1 alpha
This is what my user wants
[snip]
I believe I will need sub-selects for the following type of query. Subqueries
are not supported until MySQL 4.1.
I will n
In my network there are one master 4.0.13 and 3 slaves with 4.0.15.
STarting the slaves's update to 4.0.15 from 4.0.13 during the night when on
the master there are not update I read on slaves's logs as follow:
30918 3:41:06 Error reading packet from server: Lost connection to MySQL
server duri
On Wed, Aug 27, 2003 at 11:17:36AM -0400, Asif Iqbal wrote:
>
> Hi Jeremy Zawodny (and all)
>
> I am using your mytop and this is what I am seeing
>
> MySQL on localhost (4.0.13-standard-log)
> up 0+10:48:22 [11:14:37]
> Queries: 85.6k qps:2 Slow: 207.0 Se/In/Up/De(%):86/05/0
Hi there i have a couple of projects which required fulltext searching so
was unable to setup innodb on these. I was wondering if lock tables is a
secure way to make the transaction on these tables and does this prevent
being read upon aswell?
--
MySQL General Mailing List
For list archives: ht
On Tue, Sep 02, 2003 at 05:34:12PM -0500, Lewis Watson wrote:
> I currently have three mysql machines replication from A-B-C-A type
> fashion. I need to replace A. I am thinking that I could add D and have it
> pull from C. Then once A is removed restart D as A. Is this a good way to
> do this or i
On Wed, Sep 03, 2003 at 01:21:24PM -0700, David Griffiths wrote:
> Looks like an interesting benchmarking tool.
>
> BTW, I thought http://highperformancemysql.com/ looked interesting; when's
> it due to be published?
As soon as it's done. :-)
But it's rather behind now. However, it *is* progres
On Mon, Sep 08, 2003 at 05:50:15PM +0200, Bertil Wergelius wrote:
> I have an application, where I use the following select-query:
>
> select h.huvud_id,datum, start_tid, stopp_tid,l.lokal_beteckning,
> namn,adress,rubrik,amne,grupp,kursnamn,lr.signatur
> from huvud_schema as h,lokaler as l,huvud_
On Wed, Sep 17, 2003 at 03:07:41PM -0700, Scot Campbell wrote:
> These will be random atomic Inserts originating from a Web page.
>
> I'm not sure I catch your drift. The inserts are not in a batch.
>
> I need to notify the user on the page which field was in error. I'd like to
> refer to the
On Wed, Sep 17, 2003 at 08:18:32PM -0700, Mike Klein wrote:
> Don't applications have to be "kerberized" first?
>
> I don't believe mysql is...kerberos libs don't show up when using ldd.
Correct. MySQL is not kerberized(sp?).
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
On Wed, Sep 17, 2003 at 09:58:16PM -0400, Bruce Feist wrote:
> Bob Hall wrote:
>
> >Bruce Feist has initiated a discussion with me off the list,
>
> Off the list by accident, by the way. I sometimes forget that in this
> list I need to do a REPLY ALL. I generally don't go private unless I
> w
At 10:33 AM +1000 9/18/03, Daniel Kasak wrote:
Paul DuBois wrote:
If you have problems reloading the table due to the order
in which the InnoDB tables appear in the dump files, add
SET FOREIGN_KEY_CHECKS = 0;
to the beginning of the file before reloading it.
Our backups are quick large - over 50
Don't applications have to be "kerberized" first?
I don't believe mysql is...kerberos libs don't show up when using ldd.
mike
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 6:24 PM
To: Tomasz Korycki
Cc: [EMAIL PROTECTED]
Subject: Re
At 3:25 PM -0700 9/17/03, Hsiu-Hui Tseng wrote:
After specify the variablies for innodb in my.cnf file, I started mysql
server. Why I did not see the creating output? But I can see it in err file.
If there is an error file, that's where you'll see the output.
If you mean you want to see it on the
MySQL 3.23.36 (yeah, I know it's getting old...):
What permission do I need to run the following query:
REVOKE ALL
ON mydb.* FROM 'sdaf'@'%';
I get an error 1044:
"Access denied for user: 'Admin@' to database 'mydb'"
My user has GRANT permission on mydb (database) and GRANT permission on all
Bob Hall wrote:
Bruce Feist has initiated a discussion with me off the list,
Off the list by accident, by the way. I sometimes forget that in this
list I need to do a REPLY ALL. I generally don't go private unless I
want to avoid embarassing someone or need to discuss something genuinely
of n
Hi there is there any possible modular way to simulate a resitrict delete on myisam
tables ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This is a repost of sorts...
I have a simple stored procedure in MySQL-5.0 from the bk tree:
create procedure sp_BillingByID(input_BillID int)
select * from Billing where BillID=input_ID
When I use the mysql console, and type:
call sp_BillingByBillID(4000)
I get the rows I expect - those with B
yes
Kerberos is the ticket
use stashticket to cache your unix credentials
http://www.cs.wisc.edu/csl/doc/info/kerberos/
then put the runauth script in ~/public/.forward check the link for details
-Martin
- Original Message -
From: "Tomasz Korycki" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTE
you just need to restart mysql now as long as you put the file into
/etc/my.cnf
shutdown mysql: mysqladmin -u root -p shutdown
start: safe_mysqld &
The file never installed from me from the RPM either, i had to manually copy
it in, yet the server will work without it.
Hope that helps.
Jamie
At 20:12 2003-09-17, Mike Klein wrote:
Question: how is this done?
I am getting tired of entering my existing unix login information (same
login/pwd) every time I want to login to mysql.
I would like to propagate my existing unix credentials (/etc/pwd) or
possibly use pam/sasl/etc.
Note... this is
Question: how is this done?
I am getting tired of entering my existing unix login information (same
login/pwd) every time I want to login to mysql.
I would like to propagate my existing unix credentials (/etc/pwd) or
possibly use pam/sasl/etc.
Note... this isn't the same as mysql/pam interface.
Paul DuBois wrote:
If you have problems reloading the table due to the order
in which the InnoDB tables appear in the dump files, add
SET FOREIGN_KEY_CHECKS = 0;
to the beginning of the file before reloading it.
Our backups are quick large - over 500 MB. Opening the file and adding
the above li
Question: how is this done?
I am getting tired of entering my existing unix login information (same
login/pwd) every time I want to login to mysql.
I would like to propagate my existing unix credentials (/etc/pwd) or
possibly use pam/sasl/etc.
Note... this isn't the same as mysql/pam interface.
At 6:33 PM -0400 9/17/03, Tore Bostrup wrote:
How does one go about revoking a user's GLOBAL privileges with a
REVOKE statement?
TIA,
Tore
REVOKE priv_name ON *.* FROM ...
*.* means "global"
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL ce
How does one go about revoking a user's GLOBAL privileges with a REVOKE statement?
TIA,
Tore
After specify the variablies for innodb in my.cnf file, I started mysql
server. Why I did not see the creating output? But I can see it in err file.
thanks
Hsiu-Hi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
At 03:09 PM 9/17/2003, you wrote:
Anything that anyone can suggest that might point me in some direction would
be very helpful. I'm just at a complete lose right now ...
James,
See the Google Group search:
http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&safe=off&q=mysql+%22Access+denied
We are currently using an access database going through an odbc connection in vb.net
for our application (which is still in development). The plan was to use MySQL in the
end and we are needing to cross that bridge.
I was wondering the Performance differences between running MySQL on a Linux bo
On Wed, Sep 17, 2003 at 03:01:35PM -0700, Dathan Vance Pattishall wrote:
> Yup :). I just don't know if activating noatime (for instance) will mess
> with mysql's ability to check tables at startup in the event of bad
> tables.. etc.
Using noatime should be fine. It provides a minimal performance
These will be random atomic Inserts originating from a Web page.
I'm not sure I catch your drift. The inserts are not in a batch.
I need to notify the user on the page which field was in error. I'd like to
refer to the index name in the schema and relate it to the field that
contains the non-
Yup :). I just don't know if activating noatime (for instance) will mess
with mysql's ability to check tables at startup in the event of bad
tables.. etc.
So, I should rephrase the question, what are some good options that work
with mysql and not degrade or inhibit its service.
- Dathan Vance P
Look in /usr/share/doc/packages/MySQL-server/ for some example my.cnf and
find the one that works for you and copy it the /etc
Jamie
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 4:17 PM
To: [EMAIL PROTECTED]
Subject: /etc/my.cnf
Dear list:
I`ve just to install the binary RPM MySQL-serverv 4.0.15 into my Linux
RH7.3 box. The installation was successfull however when I tried to edit
the /etc/my.cnf file to configure error and query path logs, my Linux
system says :
/etc/cnf: No such file or directory
However when I ru
LinuxThreads look like processes in a process list. There is only one
mysqld instance and 11 connections to it.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Jason Linden [mailto:[E
On Sat, Aug 30, 2003 at 03:35:44AM +1000, Chris Nolan wrote:
> Hi all,
>
> Now that technologies such as Reiser4 are emerging that offer atomic
> filesystem operations, is it expected that MySQL
> will take advantage of them?
When word of ReiserFS 4.x first emerged a year or two ago(?), the MySQ
On Wed, Sep 17, 2003 at 08:01:07AM -0700, Scot Campbell wrote:
> Let me rephrase. I insert a row and recieve a 1062 error (Key violation).
> How do I determine, at run-time, which of the 3 possible columns has the
> error. I guess I could parse the mysql_error message string. But, that
> see
On Thu, Aug 14, 2003 at 10:50:55AM -0700, Dathan Vance Pattishall wrote:
> I want to get the most out of my Dedicated Red-Hat Linux 6 drive (3
> RAID-1 / 3 RAID-10 ) mysql servers using Reiser-fs.
>
> Currently I have this in my fstab
> /dev/sda6 /var/lib/mysql reiserfsdefa
Anything that anyone can suggest that might point me in some direction would
be very helpful. I'm just at a complete lose right now ...
-Original Message-
From: James M Kupernik [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 3:58 PM
To: [EMAIL PROTECTED]
Subject: random acces
Hi Everyone;
I have been experimenting with a new add-on for my VB/MySQL forums, and as a
result I now have a new mirror for the general list. The mirror is available at
http://www.vbmysql.com/forums/viewforum.php?f=17 but only took effect today, so
there is not too much to search through yet.
Bruce Feist has initiated a discussion with me off the list, and
has forced me to refine the way I express my position somewhat.
The combination of on-list and off-list discussion has been interesting,
but it's getting overwhelming, and reminds me that I have a tendency to
overindulge in contro
> > The WHERE-clause for these searches sometimes is a combination
> > of different columns in the table, and I have noticed some
> > very sub-optimal index-usage
>
> Adding correct estimations for MATCH is in todo.
> Until it's done you can use USE_INDEX/IGNORE_INDEX as a simple
> workaround.
Tried it... didn't do anything. Also, there are 11 different instances
of mysql running. Any ideas why? Or is that just how it works?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 9:37 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED
On Wednesday 17 September 2003 09:16 am, Randy Chrismon wrote:
> form is too restrictive for me. Will this work?
>
> grant ... to randy@'%.host.name'
yup... sure will, this is exactly what we do, works like a charm.
gabe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Checking and repairing a table is faster using myisamchk when the mysqld
process is down. This fact is due to more of the resource of a system is
dedicated to myisamchk and the system is not trying to process locked
queries, this is the main motivation (for me) to have a db down to do a
repair.
+--++--+
+
| Table| Op | Msg_type | Msg_text
|
+--++--+
+
| xx.users | repair | info | Found wrong stored recor
- Original Message -
From: "Gary Huntress" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 17, 2003 12:14 PM
Subject: Multiple Self Joins and Left Joins ?
>
> I'm stumped by this query that I think will involve multiple self joins
and
> left joins.
>
> My data look
Hi there,
A mysqlhotcopy issue has stumped no less than three of us here today at
work, ensuring that the solution is glaringly obvious. We're trying to
use mysqlhotcopy to copy a few databases. We want to make a local copy,
nothing exotic, just want to move the database backups to the directory
/
I was wondering if anyone can give a direction on this sub-query issue. Do I
must upgrade it to MySQL 4.1 alpha or is there an alternative on MySQL 4.0.13 as
a workaround to sub-query
Thanks
--
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.
At 12:16 PM -0400 9/17/03, Randy Chrismon wrote:
I have several machines and wander from office to office as part of
the job. As I read the MySQL docs, I have two choices for granting
privileges:
grant ... to randy@'%'
or
grant ... to [EMAIL PROTECTED]
The first form is too vulnerable for the folks
I have several machines and wander from office to office as part of
the job. As I read the MySQL docs, I have two choices for granting
privileges:
grant ... to randy@'%'
or
grant ... to [EMAIL PROTECTED]
The first form is too vulnerable for the folks around here. The
second
form is too restricti
I'm stumped by this query that I think will involve multiple self joins and
left joins.
My data looks like:
+--+--++
| id | Category | description |
+--+--++
|1 | color| red|
|2 | color| blue |
|3 | color| ye
Egor Egorof said:
> If I've got you right, you get "Lost connection" error when foreign
key constraints is turn on?
> Could you provide your table structure and some data for testing?
Well, I designed the table with a foreign key constraint, then I
disabled keys, tried to LOAD and got the lost con
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matt W wrote:
> Yep, verified here with .15-nt on Win2k. :-/
>
> I'm sending this to the Bugs and General lists because I'm assuming it
> affects all platforms; or is it only Windows?
>
>
> Matt
>
I was able to repeat this behavior, and have filed a
Let me rephrase. I insert a row and recieve a 1062 error (Key violation).
How do I determine, at run-time, which of the 3 possible columns has the
error. I guess I could parse the mysql_error message string. But, that
seems likely to change in the future. Or, I can test each column for
uni
Figged it would be easy enuf. Thanks
-- Keith
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 9:38 AM
To: Keith Hamilton; MySQL
Subject: Re: JOIN Statement on 2 Database Tables?
> Is it possible to Join 2 tables in 2 different database
> Is it possible to Join 2 tables in 2 different databases? Can someone
> give a quick example?
select database1.table1.* from
database1.table1, database2.table2 where
database1.table1.common_field = database2.table2.common_field.
Chris
-mysql,query,blah
--
MySQL General Mailing List
For lis
Is it possible to Join 2 tables in 2 different databases? Can someone give
a quick example?
-- Keith
Keith Hamilton
Information Technology
[847] 451-0451 x121
[EMAIL PROTECTED]
I think the most difficult ( if not impossible with just using mysql
query) is the part where you apply your logic as to the "most relevant"
keyword.
You need to be able to have a mechanism of telling the query which
keyword is the most relevant, ie, human logic says, the one that matches
the searc
Dear Ladies and Sirs,
I tried
SELECT * FROM WHERE LIKE '%ü%';
to find out if german umlauts (öäü) are imported.
In the resultset where some ds with 'ü' and some with 'y'.
So the charset itself seems to be OK but why did I get 'y'.
They sound sometimes the same, but they are not the same.
How c
Hmmm, have you tried putting is a folling mysqladmin flush-threads command?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am fairly new to both linux and mysql. I have a cron job that runs
every minute to move data from one mysql table to another (both tables
are in the same database), see below:
Cron job is:
mysql -u *** --password=*** syslog < /var/scripts/updsysklog2
Script is:
INSERT INTO sysklog2 (machi
Not sure I understand what you need?
Can you create a dummy output table of what you would like your result
to look like?
At first glance, from reading your question, it sounds like you simply
want this:
select * from ppc_keywords where keywords like "%job%" [group by
keywords] order by bid;
whe
Hi all,
My company(situated in Poland) produce cross platform software based on
Borland Delphi/Kylix. We also use mysql server to store all our date.Server
is configured with latin2 character set. Nowadays several users work on
Linux boxes(Debian + XFree 4.3.1 + KDE 3.1.3 + iso 8859-2 with LC_ALL
Can anybody help me sort my results in the correct way.
My Table description is:
+--+---+--+-+-++
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-++
| id
Carl Anthony-uzoeto <[EMAIL PROTECTED]> wrote:
>
> I need to periodically load a dumpfile from another DB into
> mysql. Now, since this is a cronjob, and for which I would
> need to avoid interactivity, I DO NEED to run this as a
> non-root user.
>
> I have setup such a user, and have granted th
Bogdan TARU <[EMAIL PROTECTED]> wrote:
>
> So, back to the problems with auto_increment columns and replication
> problems. I have noticed this problem always occures when using INSERT
> SELECT syntax with an auto_increment key
>
> simple example:
>
> CREATE TABLE test1 (value INT);
> INSERT INT
Daniel Baughman <[EMAIL PROTECTED]> wrote:
> I have a mysql server running on a dual processor pentium 233 (a real power
> house :) ). And I have serveral php web sites that access it locally. One
> of about 15 reads results in the following error being generated:
>
>
> Error
>
> MySQL said:
Wakan wrote:
I bag your pardon if I post this question again,
but I can't find a clear answer.
I've Mysql version 3.23.41 and 4.0.12, and the manual says
that for version > 3.23 the - sign and the decimal point, there's an
extra space reserved.
I've a decimal column : DECIMAL(5,2), and my problem
I bag your pardon if I post this question again,
but I can't find a clear answer.
I've Mysql version 3.23.41 and 4.0.12, and the manual says
that for version > 3.23 the - sign and the decimal point, there's an extra
space reserved.
I've a decimal column : DECIMAL(5,2), and my problem (maybe manual
"Kim G. Pedersen" <[EMAIL PROTECTED]> wrote:
>> "Kim G. Pedersen" <[EMAIL PROTECTED]> wrote:
>>>
>>> I once red that using "truncate table xx" instead of "delete from xx"
>>> should reset autoincrement , but it seem not to happend.
>>>
>>> but when I try to insert data with "insert" or "load data
I bag your pardon if I post this question again,
but I can't find a clear answer.
I've Mysql version 3.23.41 and 4.0.12, and the manual says
that for version > 3.23 the - sign and the decimal point, there's an extra
space reserved.
I've a decimal column : DECIMAL(5,2), and my problem (maybe manual
The original problem is because MySql dosen't support "deferrable
constraint".
I "solve" this problem with this workaround:
UPDATE Prova SET Prog=Prog*-1 WHERE Gruppo=16 AND Prog>=1;
UPDATE Prova SET Prog=ABS(Prog)+1 WHERE Gruppo=16 AND ABS(Prog)>=1;
> Use ORDER BY clause in UPDATE statement:
> h
I bag your pardon if I post this question again,
but I can't find a clear answer.
I've Mysql version 3.23.41 and 4.0.12, and the manual says
that for version > 3.23 the - sign and the decimal point, there's an extra
space reserved.
I've a decimal column : DECIMAL(5,2), and my problem (maybe manual
"Andrea" <[EMAIL PROTECTED]> wrote:
>
> In MySql I create this table:
>
> CREATE TABLE `prova` (
> `Gruppo` int(11) NOT NULL default '0',
> `Prog` int(11) NOT NULL default '0',
> `Descrizione` varchar(100) default '',
> PRIMARY KEY (`Gruppo`, `Prog`)
> ) TYPE=MyISAM;
>
> Running this:
> UPD
Hi
Install MyODBC
Set it up for your mysql database
then from Paradox "copy table" to the mysql datasource.
You should get a correctly structured table. Depending on the fieldtypes you
may have to do a little manual tweaking.
You may also not be able to do memo fields.
MyODBC can be used as
David,
> 030916 17:30:21 InnoDB: Error: page 120855 log sequence number 11
2122008369
> InnoDB: is in the future! Current system log sequence number 0 100503279.
> InnoDB: Your database may be corrupt.
I assume that you have some 18 GB of data in the database? Then the log
sequence number cannot
"Randy Chrismon" <[EMAIL PROTECTED]> wrote:
> I read the MysQL documentation re the Server Gone Away error but
> nothing there applied to my situation. On a whim, I re-created the
> table I was trying to import into but without the foreign key
> constraint (I had only disabled the foreign key const
Irwin,
DROP FOREIGN KEY was implemented after 4.1.0.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
- Origi
I have not used paradox but in most database you can do: (A mysql example)
show create table tblName
and it will generate the create table sql for a table.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 12:41 AM
To: [EMAIL P
Hi.
In MySql I create this table:
CREATE TABLE `prova` (
`Gruppo` int(11) NOT NULL default '0',
`Prog` int(11) NOT NULL default '0',
`Descrizione` varchar(100) default '',
PRIMARY KEY (`Gruppo`, `Prog`)
) TYPE=MyISAM;
Running this:
UPDATE Prog SET Prog=Prog+1 WHERE Gruppo=16 AND Prog>=1
I dont know if I am the only one who has ever asked this. But I dont seem
to be able to find any information about it. Here is what I want to do.
Create table Company
Id int auto_increment primary key,
Name varchar(20);
Create table Employee
Id int auto_inc
Is there a relatively painless way to import data and database structure from Paradox
to MySQL.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
84 matches
Mail list logo
