- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "xutian" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, December 19, 2001 12:27 PM
Subject: Re: Mysql query it too slow in big table
> In the last episode (Dec 19), xutian said:
> > ###COLL_DATA's index
> > my
I believe you could use CONCAT(firstname, ' ', lastname) LIKE
'%$searchname%'
if you leave the space out of the middle it probably won't work, and you
might want to trim firstname & lastname to make sure no leading or trailing
spaces exist.
Hope this helps,
P
-Original Message-
From: *H
How do I use the select feature in this situation.
I have a total of 5 fields that deal with names.. Three of the five are
completely separate, and use one field for both first and last name. the
last two fields are the first and last name of the person submitting the
information..
When I
My ISP, WebHosting, has been hosting one of my sites for about 5 years.
I use MySQL to support the site and build the pages. About a month ago,
I started getting the following message when I tried to use the command
line interface:
mysql> select * from Properties;
ERROR 1016: Can't open file: 'P
I'm running MS Access DB roughly 30K records with several users accessing it
at the same time (that's what worries me the most) so I'm looking into
moving to some SQL server.
I have tried exporting the tables and still using the access forms as a GUI
through ODBC.
I tested MSDE, MS SQL, mySQL whic
In the last episode (Dec 19), xutian said:
> ###COLL_DATA's index
> mysql> show index from COLL_DATA;
>
>+---+++--+-+---+-+--++-+
>
> | Table | Non_unique | Key_name | Seq_in_index | Column_
> ###query the last time where ip='172.017.011.253'
> mysql> select max(THE_TIME) from COLL_DATA where
IP_ADDR='172.017.011.253';
> +-+
> | max(THE_TIME) |
> +-+
> | 2001-11-26 14:35:18 |
> +-+
> 1 row in set (6.77 sec)
> It's too
###table struct of COLL_DATA
mysql> desc COLL_DATA;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-+---+
| TASK_ID | bigint(20) | YES | | NULL | |
| E_TYPE_ID | int(11) | YES
What are the chances that mysql in the future will allow
someone other then a user with process privileges to check
the status of the master and or slaves. I would like to
write a script to monitor this, but I dont want to put a
script out there with process privileges.
Thanks,
Mike
--
Hi,
I've changed the length of the field 'user' in the table 'user' in the mysql
DB, to varchar(128), because we need longer names to identify our users
based on their domain names. Something like: each user is identified by a
valid domain name. The same thing we are doing with the DB field.
Dave Greco wrote:
> Looking over the documentation for MySQL, there doesn't seem to be a
> consensus on the best way to perform backups of MySQL databases. So far, I
> have come up with the following ideas:
>
> 1. Just copy the files in the data directory to wherever I want them backed
> up. This
After sending my earlier email regarding compress_gz()/uncompress_gz() in
mysqld, I discovered user defined functions -- something I had never used
in mysqld until today.
So, I took a couple of hours and wrote a Mysql UDF to do what I requested:
# gcc -shared -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=
I tried to connect to mysql on another machine, but can't get through:
ERROR 2003: Can't conect to MySQL server on 'other host' (111)
I think this is because the two machines are in different domains, and
the packets are being blocked by a firewall.
Anybody know what I need to enable in the fir
Another suggestion I saw someone make that seems reasonable is to use a
break away mirror for backups. I think they lock the tables for a minute
break the mirror and unlock the tables. Then they backup the broken mirror
at their leisure.
Dave
On Tue, Dec 18, 2001 at 06:00:49PM -0500, Dave Greco w
Check the file ownership, and make sure that its the same as the mysql user.
Barry Gold wrote:
> I duplicated the mysql database from another machine by copying over the
> table files. But now I find myself unable to access the tables.
>
> I restarted the mysql server using the --skip-grant-tab
Am 18 Dec 2001 14:35:07 -0800 schrieb Jeremiah Jester:
> Well it seems as though i may have mistyped my root password for mysql since
> nothing seems be working. Anybody no how to set a new root password or how
> to reset the old password in mysql? Already tried uninstalling the RPM from
> in hope
Looking over the documentation for MySQL, there doesn't seem to be a
consensus on the best way to perform backups of MySQL databases. So far, I
have come up with the following ideas:
1. Just copy the files in the data directory to wherever I want them backed
up. This doesn't work too well beca
I duplicated the mysql database from another machine by copying over the
table files. But now I find myself unable to access the tables.
I restarted the mysql server using the --skip-grant-tables option. Then
I could access the tables, but the grant command wasn't recognized so I
couldn't just
Oops !! Sorry, wrong list.
Steve
- Original Message -
From: "Steve Osborne" <[EMAIL PROTECTED]>
To: "MySQL (E-mail)" <[EMAIL PROTECTED]>; "Mike Eheler"
<[EMAIL PROTECTED]>
Sent: Tuesday, December 18, 2001 3:49 PM
Subject: Re: [PHP] Working with designers...
> As a designer and a
As a designer and a coder, I have always found that it is easiest to have
the layout of the page done before adding the dynamic content. If the
layout is done correctly, it should not be necessary to put in sample data
that has to be removed after.
After joining the workforce, as a database prog
Well it seems as though i may have mistyped my root password for mysql since
nothing seems be working. Anybody no how to set a new root password or how
to reset the old password in mysql? Already tried uninstalling the RPM from
in hopes to redo the install but when i try it tells me the package ha
I was doing testing on a query today and it suddenly stopped returning any
results. Each time I would run the query it would return no records. I ran
it from the console utility and from a web page using ASP with the same
result. I also ran it from a GUI windows client (DBTools) with the same
resu
hi!
i have a table with alot duplicates in them. the tables has about 2
million rows
and i expect that there are ca. 20.000 duplicates which have to be removed..
what i basicly wanna do is:
delete rows from that table which have the same value on the column col1,
col2 and col3 of that table.
While I have your attention, let me take this opportunity to report that
I've run into quite a few obstacles building MySQL from source. (I
reported most of these at the end of October, but have received no
response.)
1) Back in August (8-8-2001, in thread "Build problems (+solution) on
HPUX10.
On Tue, Dec 18, 2001 at 11:19:06PM +0200, Heikki Tuuri wrote:
: Philip,
:
: I recommend using the MySQL STRAIGHT JOIN and USE INDEX clauses to manually
: force the best plan.
I'd love to, but I also have to maintain a spec of database
agnosticism (which I could do in code, of course, but I shoul
all of the information you people have given to me is great and useful,
however, I still have no comprehension as to how to make the conditional
"html" setup for the pages. my attempt is as thus:
#getdata.pl
globals:
$PageLimit = "0";
$PageNumber = "1";
open db:
$DSN = "DBI:my
Hi,
I installed MySQL-3.23.46-1.i386.rpm on my machine and it order me to set a
password for the rootuser using mysqladmin, but I don't have mysqladmin on
my machine, I can't find it..
what to do and how is this possible..
greets Piet
--
Philip,
I recommend using the MySQL STRAIGHT JOIN and USE INDEX clauses to manually
force the best plan.
You could also use innodb_table_monitor to check that the key value set
cardinality estimates are approximately right for the tables h, pt, and p.
But to put it the other way, how could the
>Description:
Mysql dies in signal 11
>How-To-Repeat:
Don't know. Seems to happen when machine runs for more than 24 hours.
>Fix:
Unknown.
We will be trying the latest version of Mysql (3.23.46).
>Submitter-Id: [EMAIL PROTECTED]
>Originator:Petro
>Organization:
Does anyone know why this isn't working?? What I am trying to do is display
photos from a database based on each month. This part works fine when I set
it to the current month of December (today) as that is when I uploaded the
photos.
However, when I manually set the date to a month that has n
Is there any way to detect the Operating System that a MySQL server is
running on
using SQL or DBI function calls only?
--
Regards,
Brent
interactivetools.com, inc.
Tel: (604)689-3347 - Fax: (604)689-3342 - Toll Free: 1(800)752-0455
Software for your Website - http://www.interactivetools.com/
"Deependra B. Tandukar" <[EMAIL PROTECTED]> writes:
> What is RedHat Database?
Postgresql.
>Is anybody using it? How is it? Better than MySQL?
It's postgresql w/support, so the answer would be the same as regular
postgresql vs. MySQL.
This means that it has things like foreign keys, stored p
Sommai Fongnamthip <[EMAIL PROTECTED]> writes:
> Hi,
> I was read recommendation from MySQL download page to upgrade
> Linux Kernel for latest MySQL version. I have problem because I must
> still with Linux Red Hat 6.2 (kernel 2.2.16-3)
Newer versions of the kernel has been released, and
> There is a lot of administrative command tools for
> MySQL available
> that allows one to monitor and work with MySQL.
Yes, I went looking for admin GUI's and found there to
be a lot of them. I found useable ones for MacOSX,
Linux and Windows.
The one I settled on is mySQLfront (from a German
> Im attempting to install mysql. The service started and
> everything seems to
> be going ok except for that I can't set the root password for the mysql
> server.
>
> To reset password i type:
>
> /usr/bin/mysqladmin -u root -p mypassword
>
> Then I get the following error:
>
> /usr/bin/mysq
Hy,
Am 18 Dec 2001 10:50:40 -0800 schrieb Jeremiah Jester:
> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
in the default installation at the first start there is no password set
for the mysql root user.
Not
try:
mysqladmin -u root password new_password_here
- Original Message -
From: "Jeremiah Jester" <[EMAIL PROTECTED]>
To: "'MySQL'" <[EMAIL PROTECTED]>
Sent: Tuesday, December 18, 2001 10:50 AM
Subject: mysql password
> Im attempting to install mysql. The service started and everything
If I install mysql (latest stable version) on Windows 2000, service pack 1, I can type
the command d:\mysql\bin mysqld-nt --standalone, and the server runs fine. I then
invoke the mysqlgui, and can do anything with table creation, reading, etc. But if I
do the same thing on Windows 2000, serv
To avoid duplicate questions, (and avoid anyone's mailbox to be blown up) I
would like to point out that you can search the mysql mailinglist @
http://groups.google.com/groups?hl=en&group=mailing.database.mysql
A lot of the questions I see lately have been posted in the past.
Regards,
Almar v
That is what the Bp flags from tar are for, and we did a su beforehand
M
-Original Message-
From: David M. Peak [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2001 18:34
To: [EMAIL PROTECTED]; 'MySQL'
Subject: Re: Changing the locations of the tables
Don't forget to ensure that the a
Im attempting to install mysql. The service started and everything seems to
be going ok except for that I can't set the root password for the mysql
server.
To reset password i type:
/usr/bin/mysqladmin -u root -p mypassword
Then I get the following error:
/usr/bin/mysqladmin: connect to server
Don't forget to ensure that the account that the mysqld is running under has
the proper permissions to the new directory. I ran into that one before..
- Original Message -
From: "Matthew Smith" <[EMAIL PROTECTED]>
To: "'MySQL'" <[EMAIL PROTECTED]>
Sent: Tuesday, December 18, 2001 10:24
Hi,
> -Original Message-
> From: Jens Collin [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 18, 2001 4:22 AM
> To: '[EMAIL PROTECTED]'
> Subject: MyODBC leaking handles...
>
>
> Hi all,
>
> This is my first post in this forum. I've tried to find something in the
> documentation but
> Here you go:-)
> [root@server src]# rpm -i MySQL-3.XX.XX-1.src.rpm
> [root@server src]# tar -xvzf ../../src/redhat/SOURCES/mysql-3.XX.XX.tar.gz
> [root@server src]# cd mysql-3.XX.XX
> [root@server mysql-3.XX.XX]# ./configure \
> --prefix=/usr/lib/mysql
> [root@server
I think the key was _without_ reinstalling.
I emailed this privately first, but should work with minimum downtime
and preserve data:
mysqladmin -u . shutdown
su
cd /var/lib
tar -cf - mysql | (cd /usr/lib ; tar xvBpf -)
rm -rf mysql
vi /etc/my.cnf
:%s/\/var\/lib\/mysql/\/usr\/lib\/mysql/g
:x
Forwarded message:
>Return-Path: <[EMAIL PROTECTED]>
>From: "Mehalick, Richard RE SITI-ITPSCA" <[EMAIL PROTECTED]>
>To: 'Heikki Tuuri' <[EMAIL PROTECTED]>
>Subject: RE: Innodb Win2000 error
>Date: Tue, 18 Dec 2001 11:41:45 -0600
>
>Thank you for responding. I was just going to post again that I s
Here you go:-)
[root@server src]# rpm -i MySQL-3.XX.XX-1.src.rpm
[root@server src]# tar -xvzf ../../src/redhat/SOURCES/mysql-3.XX.XX.tar.gz
[root@server src]# cd mysql-3.XX.XX
[root@server mysql-3.XX.XX]# ./configure \
--prefix=/usr/lib/mysql
[root@server mysql-3.XX.XX
Hi all,
I would like to propose that mysql have compress_*()/decompress_*()
functions added that would be similar to des_encrypt()/des_decrypt().
My idea would be to have functions available like:
compress_gz()/decompress_gz()
compress_bz()/decompress_bz()
...etc.
I have read of people doing t
Which keys should I have for a database query like :
SELECT qid, catid, point, flag_status, timestamp FROM questions WHERE
(flag_status = 1 OR flag_status = 2) ORDER BY qid DESC LIMIT 0, 10
-
Before posting, please check:
ht
Check the MySQL documentation, but I believe there are 2 ways.
1> In the startup of mysqld, set the datadir option, which tells the mysqld
where the tables are.
2> use UNIX links. Using UNIX links is a good way to split your table and
index I/O across disks. Note that you have to be careful abo
Is there a way without reinstalling MySQL to change the locations of the
database tables?
For example right now they are in
/var/lib/mysql
I want them
/usr/lib/mysql
Thanks in advance
--
Stephen Johnson
[EMAIL PROTECTED]
http://www.pets4u.com
Owner / Founder
-- your next
Did you try a google search - say
http://www.google.com/search?q=%22redhat+database%22
? The first link I saw (to RedHat itself) pretty much answers the question...
- steve
At 2:53 PM +0545 12/18/01, Deependra B. Tandukar wrote:
>Greetings !
>
>What is RedHat Database? Is anyb
At 10:02 AM -0800 12/18/01, Steve Osborne wrote:
>I would like to use an input form to add users to my database, however, if
>the name is already in use, I do not want to add a duplicate record. I also
>need this to be case insensitive (ie Santa Claus = santa Claus).
Make the (LastName, FirstNa
On Sun, 16 Dec 2001, Michael Widenius wrote:
> As this works on our HP-UX machine, it means that some library that we
> are using is not compatible with yours :(
>
> Michael> My workaround is to compile mysql from source, adding --disable-largefile
> Michael> to the options recommended in the
I would like to use an input form to add users to my database, however, if
the name is already in use, I do not want to add a duplicate record. I also
need this to be case insensitive (ie Santa Claus = santa Claus).
I've tried the following code, but it doesn't seem to be working
$chknamero
Hi Everyone,
I have just installed mysql 4 on a Linux server & I'm comparing it against
MS-SQL to see
it handles one of our DBs better. The DB has over 8 million records & MS-SQL
shokes with it.
I have a field defined to be UNIQUE and I need to append from another table
into it from MS-ACCESS 20
Tim Wuyts writes:
> All,
>
> I'm trying to use the UDF functionality, but I keep getting the same error
> when I issue the CREATE FUNCTION command.
> This is the error:
>
> mysql> CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "udf_example.so";
> ERROR 1126: Can't open shared library 'udf_exa
On Mon, Dec 17, 2001 at 10:03:58PM -0600, Philip Molter wrote:
: Is there any upcoming fix for this recurring problem? The table
: handler is just giving poor data to the optimizer and the optimizer
: is making bad decisions because of it. It appears to come and go,
: depending on data that is i
All,
I'm trying to use the UDF functionality, but I keep getting the same error
when I issue the CREATE FUNCTION command.
This is the error:
mysql> CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "udf_example.so";
ERROR 1126: Can't open shared library 'udf_example.so' (errno: 0 ld.so.1:
/usr/l
* Kemp Randy-W18971
> If I have mysql on server A and an identical version on server B,
> what is the easiest way to move data in Table C from server A to server B?
Asuming your databases are stored in /usr/local/mysql/var/ and the relevant
database is named "database":
>From Server A:
scp /usr
I am trying to use mysql-max-3.23.46a for Windows (Win2000) with innodb in
use.
After installing from the setup program, I copied "my-example" to c:\my.cnf"
and uncommented the innodb lines with the following:
innodb_data_file_path = ibdata1:20M
innodb_data_home_dir = c:\ibdata\
set-variable = i
If I have mysql on server A and an identical version on server B, what is the easiest
way to move data in Table C from server A to server B?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
* Henning Sprang
> Now I want to create a query to get all task_id's which one given User
> isn't already assigned to. I tried a lot of things, Joined in every
> direction and so but do not come to my result.
The problem in this situation is that you want to join with records that are
not there.
Hello,
I try to reference some value of previous row in a sql statement.
But today it's not possible due to the thread state of var, can t we do a
row state ?
thanks.
-
Before posting, please check:
http://www.mysql.com/man
And on the other hand, with mySQL you can talk with the real developers
that make it work while on other "closed source" DBs, with luck, you can
get sensible costumer support...
Cheers,
Luis Ferro
-Original Message-
From: Michael Widenius [mailto:[EMAIL PROTECTED]]
Sent: terca-feira, 18
Hy,
I have a question on how to build a query.
scenario:
I have three tables,
Users:
--
user_id INT(32),
username CHAR(64)
Tasks:
--
task_id(INT32),
task_name CHAR(64)
Authorization:
--
user_id INT(32),
task_id INT(32)
some details of database design are neclected here.
Hi all,
This is my first post in this forum. I've tried to find something in the
documentation but failed.
I cannot find out why the ODBC driver is leaking 1 handle for each request
that I do!
It doesn't matter if I close it or whatever I do.
Anyone that knows what to do?
Any hints or tips?
Wind
Hi!
> "Michael" == Michael Bacarella <[EMAIL PROTECTED]> writes:
Michael> Well, looks like I found the culprit.
Michael> Increasing thread_cache_size from 0 to 50 totally alleviated the stress
Michael> (both on the database and our clients). Recommended by the manual,
Michael> of course.
T
Hi!
I may be a little based, but here is some input regarding this.
>> Good morning.
>> Recently, we presented MySQL as a database option for a website that
>> we might be working on. We've used it as our database in the past and
>> we plan on using it in the future as possible.
>> With that s
A little bit of help from some one who is recovering from Xmas
parting...
I am having a few problems.
1.) I compiled and installed as root then changed the ownership to the "dba"
account.
Will this cause any problems down the line.
IF you do the normal mysql install you will have added a us
I have compiled and installed mysql on redhat 7.1
I am having a few problems.
1.) I compiled and installed as root then changed the ownership to the "dba"
account.
Will this cause any problems down the line.
2.) Is there s startup and shutdown script to put in /etc/rc.d/init.d or do
I have to w
Thanks... That's exactly what I was looking for. Simple and elegant.
Rob.
On Tue, 18 Dec 2001, Roger Baklund wrote:
> Asuming all dates are 20xx:
>
> mysql> select
> @d:='01-DEC-18',@d2:=concat('20',mid(@d,1,2),'-',field(mid(@d,4,3),
> 'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OC
* zxcv
> Our programming crew does not give us (Web Services) access to Oracle. We
> of course don't care kuz' mySQL suits us fine. But now we have run into a
> pickle. They are handing us text cdf files for import. One of the fields
> they are giving us is in the following condition:
>
> 02-SEP-0
I've installed MySQL on SuSe Linux. It's 3.23.43 version. Below should be
mirror of 'my.cnf'. Those error messages, which I wrote in my first mail,
are shown whatever I type. It doesn't matter whether I 'select', 'update' or
something else, always it prints "Ignoring query to other database".
Ro
What does df show?
-Original Message-
From: John Lepone [mailto:[EMAIL PROTECTED]]
Sent: 17 December 2001 20:41
To: '[EMAIL PROTECTED]'
Subject: Re: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
I don't think I'm out of room on the volume. Below is the directory
listing:
-r
Greetings !
What is RedHat Database? Is anybody using it? How is it? Better than MySQL?
Looking forward to hearing from you.
Regards,
DT
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
Our programming crew does not give us (Web Services) access to Oracle. We
of course don't care kuz' mySQL suits us fine. But now we have run into a
pickle. They are handing us text cdf files for import. One of the fields
they are giving us is in the following condition:
02-SEP-02
We need to do
77 matches
Mail list logo
