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 the
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 existence
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
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
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
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 SQL
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 colo
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 /
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
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
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
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 to the
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
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
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
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
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
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
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
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.
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.0
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
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). I'm
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 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
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 can
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
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
4
-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 tables
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 myISAM table
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 else get
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
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.
On Tuesday 30 March 2004 10:53 am, Matt Chatterley wrote:
Hi all,
hello.
snip
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
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
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
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
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
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
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.
Normally I would
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
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
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
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
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?
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
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 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
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]
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
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
| awk
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 Vincent
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
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
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 |
++++
|
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 |
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
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
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 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
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
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
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
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:11
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
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:
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,
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 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]
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
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
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
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
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
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!!!
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: mysql
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
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
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 error when
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]
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'
81 matches
Mail list logo