Hello all,
While trying to build MySQL-4.0.18-0.src.rpm downloaded from mysql.com
on a RedHat 8 I get these:
/usr/lib/gcc-lib/i386-redhat-linux/3.2/../../../libncurses.a(lib_termcap.o):
In function `skip_zero':
lib_termcap.o(.text+0xcc): undefined reference to `__ctype_b'
/usr/lib/gcc-lib/i386-
On Tuesday 30 March 2004 09:35 pm, Jonas Lindén said something like:
> I dont think that transactions are supported (yet?) by the PERL DBI.
to "Mike Blezien" <[EMAIL PROTECTED]>. My response follows.
Yes they are...at least I have used them in a project before using Perl::DBI.
[EMAIL PROTECTED
I dont think that transactions are supported (yet?) by the PERL DBI.
/Jonas
- Original Message -
From: "Mike Blezien" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 30, 2004 9:42 PM
Subject: Transaction Not supported
> Hello,
>
> I keep getting this erro
Hello,
i have a sql file that i use to build a table. It works on my Debian
testing box with mysql 4.0.16 but not on my woody box using mysql 3.23.
The error when i try to use the source command with my sql file
and version 3.23 of mysql is...
ERROR 1064: You have an error in your SQL syntax nea
Richard Davey wrote:
Hello Shane,
Wednesday, March 31, 2004, 5:43:10 AM, you wrote:
SA> using MATCH(description) AGAINST('+db2' IN BOOLEAN MODE) returns no results.
SA> Is this expected behaviour? If so, is there a way to circumvent it?
By default, the full text indexing engine doesn't include w
David McBride writes:
>I need to load data from a log file. The file is a space seperated
>file. I can already ignore the first 7 lines (that are commnet lines),
>but what I can not seem to do is:
>1. get load data to use the space seperated format.
>2. only load certain columns.
>
>I tried: my
Hi all,
Sorry to be so persistent, but I am bringing this up again since noone
from the MySQL development team commented on my previous post, and the
issue seems very serious, to the point I may start looking to switching
away from MySQL, so - please, please, shed some light on this issue!!!
T
Hello Shane,
Wednesday, March 31, 2004, 5:43:10 AM, you wrote:
SA> using MATCH(description) AGAINST('+db2' IN BOOLEAN MODE) returns no results.
SA> Is this expected behaviour? If so, is there a way to circumvent it?
By default, the full text indexing engine doesn't include words with
less than 4
I have a table with the following:
CREATE TABLE foo (
...
description text,
...
FULLTEXT INDEX (description),
...
);
select count(*) from foo where description like '%db2%';
returns 61 rows. Checking them confirms that the "word" db2 exists as a
standalone word separated either by punctuation or
HI!
I wrote a mysql UDF that works well in older versions
of mysql (3.23.*) but the same is not working for new
versions like (4.0*) . The server restarts every time
i invoke my function .
I also compiled and linked with libmysqlclient.so.11,
but still the problem persists.
how to solve the p
I have a table of data...
A1 B1 C1
A2 B2 C2
And I¹d like to make a query where I ³lag² a value, grabbing a value from
the next row of the table. Most stat packages have a lag function, but I
can¹t find this in MySQL. The end result would look like:
A1 B1 C1 D1 (where ³D1² would equal A2 from ab
I need to load data from a log file. The file is a space seperated file. I can
already ignore the first 7 lines (that are commnet lines), but what I can not seem to
do is:
1. get load data to use the space seperated format.
2. only load certain columns.
I tried: mysql> LOAD DATA INFILE 'pers
I already specified the version, 4.1.1. My problem query is this,
SELECT Item
FROM StoredProc
GROUP BY Item
HAVING (First(User)="Gus");
my StoredProc query is a simple one,
SELECT Item, Op, User
FROM tblSource
ORDER BY Item, Op;
Any Thoughts?
Thanks
>>> "Nitin Mehta" <[EMAIL PROTECTED]
Hi all,
Suppose I have a user who has been granted select and create_tmp_table,
but no other privileges, on a given database. When I attempt to insert
into any temporary table, permission is denied, presumably due to the
user not having insert on the database, and no entries in
mysql.tables_priv
I prefer SQLyog. www.webyog.com
Ditto that. I used to use MySQL-Front, but switched when development
stopped. I don't miss it really. The structure synchronization and db
job agent features are maturing rapidly and work quite well. Saves a ton
of time for me. Not sure about v5.0 support yet, bu
Did you change the mysql root password by running:
mysqladmin -u root password 'newpassword'?
If so, try:
mysql -u root -p
It will then prompt you to enter a password.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
Hi.
When i run mysql,mysqlshow,mysqladmin or .,I
receive following error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)
Please guide me..
Yours,Mohsen.
=
-DIGITAL SIGNATURE---
///Mohsen Pahlevanzadeh
Network administ
Just make a symbolic link... Probably it's in /tmp
So as root,
"ln -vs /tmp/mysql.sock /var/lib/mysql/mysql.sock"
This is always an annoyance with mysql and redhat it seems. *sigh*
> -Original Message-
> From: Sami Maisniemi [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 3
Matt Chatterley wrote:
One option would be to 'union' the two queries (assuming the columns are the
same type and length), allowing you to run one query string:
Select serial from blacklist where serial = x
Union
Select serial from seriallist where serial = x
Would return 1 or 2 rows, depending on
I intend to build up a web server that is based on Fedora Core 1.
Installation and configuration of Apache and PHP4 was pretty simple, but
there are some problems in configuration of MySQL. I installed the MySQL
server RPM included in the distribution.
Even in the MySQL pages it is mentioned th
Sami,
I run Fedora core 1 and haven't had any problems.
This is all you do if you want MySQL 4.1.1.
wget
http://www.mysql.com/get/Downloads/MySQL-4.1/MySQL-server-4.1.1-1.i386.rpm/f
rom/http://mysql.mirrors.pair.com/
wget
http://www.mysql.com/get/Downloads/MySQL-4.1/MySQL-client-4.1.1-0.i386.rpm/
I intend to build up a web server that is based on Fedora Core 1.
Installation and configuration of Apache and PHP4 was pretty simple, but
there are some problems in configuration of MySQL. I installed the MySQL
server RPM included in the distribution.
Even in the MySQL pages it is mentioned th
John, you are my father!
I've taken your script and tweaked it a bit more:
SNIP -
#!/bin/sh
DBLIST="mydb1 mydb2 mytest mytestdb"
USER="uzer"
PASSWORD="passwerd"
clear
for DB in $DBLIST
do
echo "Removing all indexes (not primary) in
I have a few hundred thousand records to import to a database, there are
already a few hundred thousand records in the database now.
What is the best way to append these new records to the old database?
I can not seem to use load data infile unless I want to preformat the data
to have the exact s
Does anyone have a list of the files that need to be backed up for a
cold backup of an innodb database:
Obviously all the MyISAM files and the innodb database files. But what
about the log and archive log files?
Evelyn
What I ment is this :-)
Table1 consists out of the following fields and data
+--++
| softid | nameofcd |
+--++
| 1 | test cd 1 |
| 2 | software cd 2 |
| 3 | software cd 3 |
| 4 | test cd 2 |
+
Timon, is this ...
SELECT cds.softid,nameofcd,nameofsoftware
FROM cds INNER JOIN software USING (softid)
WHERE nameofcd LIKE '%test%' OR nameofsoftware LIKE '%test%';
++++
| softid | nameofcd | nameofsoftware |
++++
| 1
Thanks so much for the info Gerald.
I know I'm still using 2.5 (the one from the old author).
and it did irk me that the "new" developer (cough) is trying
to make a quick buck off it.
I haven't tried it yet, and thanks for the info, doesn't look
like I'm going to either.
too bad, it was really a
I would not recommend MySQL-Front ... the version they are selling is not
from the same developer that did MySQL-Front 2.5 (and earlier).
I bought a license (took a month to get a license key), complained about
missing features (OPTIMIZE and REPAIR MyISAM tables) and was basically told
I could sho
And the answer to this is, YES, the whole ALTER query FAILS and NONE of the
indicies are dropped. *sigh*
mysql> ALTER TABLE poop DROP INDEX name_2, DROP INDEX name_3, DROP INDEX
name_4;
ERROR 1091: Can't DROP 'name_4'. Check that column/key exists
> -Original Message-
> From: Daevid Vince
I've been using comand line piping through awk to handle
mass tables modifications and listings. E.g. in your case
something like the following would hit every index, except
the primary keys, in table tablename in the test database.
echo "show index from tablename" |
| mysql -uuser -ppswd test
| aw
In a bit of a quandary here...
I have a user table and a registered serials table
Table data at end of email...
I have been given a large set of new data, but it is flat file, basically,
it looks just like the user table, with the addition of one field called
serial.
Somehow, I need to take the
Hi,
is that possible to use a result of a calculation as a field? for example:
SELECT num1 + num2 AS var1, IF(var1 > 100, 'Good', 'Bad') FROM table1;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have just installed MySQL server v3.23.49-8.5 (downloaded from Debian
Packages Site) into my Debian v3.0r2 box! After finished installing, i had
followed the instruction here to change root's password but right after
this action, i can't login to mysql any more! I had also try to change
owners
Hi there,
Sorry for being a little bit confusing, but de criterias has to be AND.
So it has to be like this:
- all cds that matches the string 'test'
AND
- all pieces of software that matches the string 'test'
Kind regards,
Timon Berkowitz
The Netherlands
""Peter Brawley"" <[EMAIL PROTECTE
I have just installed MySQL server v3.23.49-8.5 (downloaded from Debian Packages Site)
into my Debian v3.0r2 box! After finished installing, i had followed the instruction
here to change root's password but right after this action, i can't login to mysql any
more! I had also try to change owners
Thanks for the reply, however looking at all those options and none seems to
do what I need.
> -Original Message-
> From: PeterWR [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 11:55 AM
> To: Daevid Vincent; [EMAIL PROTECTED]
> Subject: Re: Drop all keys / indexes on a table?
>
Wouldn't some variation on a MERGE table help with this?
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 2:45 PM
To: Michael J. Pawlowsky
Cc: [EMAIL PROTECTED]
Subject: Re: How to get around lack of views?
On Mon, Mar 29, 2004 at 03:58:29PM
Timon,
What is unclear to me is whether you wish to AND or OR your two criteria ...
>- all cds that matches the string 'test'
>- all pieces of software that matches the string 'test'
so if your table2 had (6, 2, 'test'), where table1.nameofcd for softid=2
does not contain 'test', do you want it
> Agreed that the replication section could be written more clearly, but is
> not the information you are looking for in section 6.3 Replication
> Implementation Details, section 6.6 features & problems, 6.7 startup options
> and 6.8 FAQ?
You must be reading a different manual than me
(http://www.
Hi,
Take at look at CHECK TABEL - as far as I remember, the CHECK TABLE EXTENDED
will do a re-index (check index), otherwise some of the other OPTIMIZE, etc.
can help on this.
Take a look in the exellent manual.
Best regards
Peter
- Original Message -
From: "Daevid Vincent" <[EMAIL PR
On Mon, Mar 29, 2004 at 03:58:29PM -0500, Michael J. Pawlowsky wrote:
>
> How would I do this?
>
>
> Let say I have an employee table with
>
> Name varchar(64)
> Dept int(11);
> Salary int(11);
>
> I want to grant select on Salary to a mysql user but only where dept = 1 let's say.
>
> Norma
Ugh. I was afraid you were going to say that...
Seriously, there's no way to just 'wildcard' ALL indexes, someone should add
that as a feature request. We're using 4.0.17 BTW.
What happens if I list out all the indexes that there _could_ be in one
ALTER line like that, and one of the indexes doe
Hello,
I keep getting this error when attempting to utilize a database that has Innodb
tables, and using transactions. This is from a Perl/DBI script too:
Error:
Transactions not supported by database at module. bla..bla
I realize this maybe a DBI question, but I thought I'd check here first
Chris,
Agreed that the replication section could be written more clearly, but is
not the information you are looking for in section 6.3 Replication
Implementation Details, section 6.6 features & problems, 6.7 startup options
and 6.8 FAQ?
PB
- Original Message -
From: Chris Petersen
> You can restrict logging only on the database level with
> binlog-do-db/binlog-ignore-db options:
> http://www.mysql.com/doc/en/Binary_log.html
I don't want to restrict logging, only replication.
I think I figured it out, though, despite the fact that the
documentation is completely inad
Tim Cutts wrote:
On 30 Mar 2004, at 09:05, Tim Cutts wrote:
SATA RAID devices aren't that bad, you know, and they are a lot
cheaper than equivalent amounts of SCSI storage. We've used NexSan
ATABoy devices, which are relatively cheap, and get you a lot of
storage in very little space (10GB in
On Tuesday 30 March 2004 10:53 am, Matt Chatterley wrote:
> Hi all,
hello.
> In-between lamenting the lack of views, one of the things I most miss from
> SQL Server, and which I need, is the Job System. For those unfamiliar with
> the concept from SQL Server, it is a way to set up one-shot or sc
The only idea which presents itself (be warned, this is ugly) is to maintain
a set of tables which hold the same data, partitioned out by privilege, and
to grant access on those tables to appropriate users.
These tables could be maintained (or recreated) from the source data at
regular intervals.
Hi all,
I hope I've chosen a suitable list for this post. If not, please feel free
to redirect me! :)
By day, I am a SQL Server (and .NET) programmer. By night, my current
project (a space-based trading/strategy game to be delivered on the web,
should anyone be interested in contacting me off-lis
On Tue, Mar 30, 2004 at 10:30:03AM -0800, Dathan Vance Pattishall wrote:
> Tips on managing very large tables for myISAM:
>
> 1) Ensure that the table type is not DYNAMIC but Fixed.
> => Issue the show table status command.
> => Look at Row Format
> => if Row Format != Dynamic the your ok
On 30 Mar 2004 at 10:30, Dathan Vance Pattishall wrote:
> 1) Ensure that the table type is not DYNAMIC but Fixed.
> => Issue the show table status command.
> => Look at Row Format
> => if Row Format != Dynamic the your ok else get rid of varchar type
> columns
> => Reason:
> Your myISA
> -Original Message-
> From: joe collins [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 1:26 AM
> To: MySQL
> Subject: ibdata1 size
>
> HI,
>
> the ibdata1file in mysql\data has reached a size of 10Mb in just over a
> week, the database I have set up is quite limited, only 7
Hi there,
I have tried that query it works, but not good enough
When you add in Table2 another row with softid 1 and without the string 'test' in it
like this :
softid| nameofcd
1test cd 1
2utils cd 1
3test cd 2
4bac
One option would be to 'union' the two queries (assuming the columns are the
same type and length), allowing you to run one query string:
Select serial from blacklist where serial = x
Union
Select serial from seriallist where serial = x
Would return 1 or 2 rows, depending on whether rows are foun
Tips on managing very large tables for myISAM:
1) Ensure that the table type is not DYNAMIC but Fixed.
=> Issue the show table status command.
=> Look at Row Format
=> if Row Format != Dynamic the your ok else get rid of varchar type
columns
=> Reason:
Your myISAM table c
Hello,
i try to store some files into a blob-fields of a myisam-table at mysql 4.1.
If the file includes bytes with hex-value 00, mysql will only store the bytes before
this ' 0-byte ' .
How can i store a file including bytes with value 00?
Thanks,
Michael Scholz
I did some tests with 20GB tables and several millions of rows a few months
back, and what helped improve the performance the most was to separate the
(small) columns used for searching from the (large) columns containing data.
My test table was from a messaging system, and I redesigned it so that
Hello,
I prefer SQLyog. www.webyog.com
Karam
--- Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hi Mike,
>
>
>
> > I've downloaded and installed 5.0, it seems to be
> working fine. However, I
> > need a graphical user interface to create tables
> and such (when I say I
> > need, trust me, I need
hi!
Chad Attermann wrote:
Hello,
I am trying to determine the best way to manage very large (MyISAM) tables, ensuring that they can be queried in reasonable amounts of time.
--8<
Why insisting in using myIsam, and not use some table format that can
assure you some degree of crash recovery a
Hi Mike,
> I've downloaded and installed 5.0, it seems to be working fine. However, I
> need a graphical user interface to create tables and such (when I say I
> need, trust me, I need). I'm running on XP (that explains a lot I know)
>
> So:
>
> Is Control Center for 5.0 available?
> Is MyODBC 5
Hello,
I am trying to determine the best way to manage very large (MyISAM) tables, ensuring
that they can be queried in reasonable amounts of time. One table in particular has
over 18 million records (8GB data) and is growing by more than 150K records per day,
and that rate is increasing. Bes
On 30 Mar 2004, at 09:05, Tim Cutts wrote:
SATA RAID devices aren't that bad, you know, and they are a lot
cheaper than equivalent amounts of SCSI storage. We've used NexSan
ATABoy devices, which are relatively cheap, and get you a lot of
storage in very little space (10GB in a 3U box).
I did
First off, thanks so far for the valuable input.
I have a few tables that are relatively large (approx. 18 mil records and
8GB of data in one) and growing so I will be looking more toward higher end
hardware. However without infintely deep pockets, I'm wondering where the
best place is to focus
Seena Blace <[EMAIL PROTECTED]> wrote:Hello,
I want to show outpur like this?
Group hostname details
aa abababa
aa abababababab
aa anannanananna
bb llololololool
bb ssjjsjsjsjjsjsj
Select group,hostname,details from table1 order by group;
I want the
Another option is DB Designer 4, http://fabforce.net/dbdesigner4/ never
quite used it because I live by phpmyadmin, but I know a few people who use
it.
Donny
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 10:26 AM
> To: [EMAIL PR
You mention Windows XP.
Check out Mysql-Front (now commercial), version 3 may fit the bill.
not sure. but it was the best windows interface for mysql ever made,
notice, I said best for windows... ;)
mysqlCC rocks, but not sure about 5.0 support.
perhaps you could test it and report, and if its no
I've downloaded and installed 5.0, it seems to be working fine. However, I
need a graphical user interface to create tables and such (when I say I
need, trust me, I need). I'm running on XP (that explains a lot I know)
So:
Is Control Center for 5.0 available?
Is MyODBC 5.0 available?
I'm having
I'm having some problems with this function. I have a "conn.inc" file that
each of my web pages accesses to create the connection to my database, and
I'm trying to use the mysql_init() function but am getting a "Call to
undefined function: mysql_init()" error. Can someone help me with this?
Ben W
I am having problems with the number of simultaneous connections in the
MySQL. I configured 5000 connections but when arriving in 4096 it
presents the errors below.
MySQL Connection Failed: Can't create a new thread (errno 11). If you
are not out of available memory, you can consult the manual fo
"Massimo Petrini" <[EMAIL PROTECTED]> wrote:
> Somebody can help me ? If you run the above code in a new db named prova,
> the last line create then error
> Can't create table '.\prova\#sql-654_2e.frm' (errno: 121)
>
> If you run the code on 4.0.17 all it is ok.
>
Thank you for report! Entered
In a bit of a quandary here...
I have a user table and a registered serials table
Table data at end of email...
I have been given a large set of new data, but it is flat file, basically,
it looks just like the user table, with the addition of one field called
serial.
Somehow, I need to take the
Take a look at
http://lists.mysql.com/mysql/158737
for an interesting 'trick' to optimze index creation.
Basically it amounts to:
* Create the data without indexes
* Move (rename) the table.MYD file to a backup
* Create an empy MYD file using TRUNCATE TABLE
* Add indexes
* Move the backed up MYD
MySQL users,
I have one table in a database which will not allow me to edit
it in phpMyAdmin. Every time I try to select the row for editing, I get
an error which says "tbl_row_delete.php: Missing sql_query".
I have 42 other tables in this database, all of which work fine.
I have at
HI,
the ibdata1file in mysql\data has reached a size of 10Mb in just over a
week, the database I have set up is quite limited, only 7 tables with no
more than 12 records in any one table (only evaluating database models on
MySQL at the moment). I have done 4 MySQL dumps and some inserts / updates
Chris Petersen <[EMAIL PROTECTED]> wrote:
> I'm trying to set up two-way replication between our colo and our office
> (slow DSL line), so our web customers can get the fast speeds of our
> colo, and the people in the office can also get the fast speeds of our
> internal network.
>
> Since our col
"Daevid Vincent" <[EMAIL PROTECTED]> wrote:
> It has come to my attention that we have maxed out our keys due to a stupid
> update script bug. It seemst that we've not been explicitly naming our keys
> and therefore mysql tried to be helpful and adds a new key each time!
> *sigh*.
>
> Is there a S
Hi,
My MySQL server is running on a 2-cpu machine with SMP RedHat 9.0. Currently I'm
executing a lot of small INSERT-queries on it. My client program is single-threaded
using the basic mysql-API functions and causes 20% load. The client closes the
connection to the server upon completion of its
hi,
msvcr70.dll is part of the Microsoft(r) C Runtime Library v7.
You can download this file free of charge from:
http://www.dll-files.com/cgi-bin/cgiwrap/dll-files/topdown/download.pl?file=msvcr70.zip==
(Copy and paste the above URI into your browsers address bar)
Carl
- Original Message
On 29 Mar 2004, at 23:55, Donny Simonton wrote:
SCSI, 15,000 RPM drives and a decent amount of memory 2-16 gigs. Dual
procs
definitely do help; we have tried it with dual procs with
hyperthreading and
without and with hyperthreading seems to be much faster.
Besides that, you can run it on any
Scott Haneda <[EMAIL PROTECTED]> wrote:
> I currently run this, which is 2 hits to the database.
>
> Select serial from blacklist where serial = '23'
> Select serial from seriallist where serial = '23'
>
> I only desire to know if either of the 2 has at least one row, I am only
> testing for exi
d r wrote:
I am a personal user who just downloaded the version
4.0 and
mysql
administrator. The first time I clicked on the
"Administrator" icon
on my desktop I get an error that says "failed
to start because
msvcr70.dll was not found. Try to reinstall. I
did remove th
82 matches
Mail list logo
