My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
being too old but how muc trouble is it to upgrade.the LIB
V. 3.23.40 is running but with 12 failed tests including bigint is
this an install I want to develop with.
Please advise
MYSQLBUG
SEND-PR: -*- send-pr -*-
Calvin Chin writes:
Can anyone out there provide GUI-Based table creation tools for mySQL?
(something like Access)
http://www.mysql.com/downloads/index.html
I use phpMyAdmin which is a neat web tool that works with most
browsers (requires frames and tables). You might be more
interested in
Hello
I was wondering if it is possible (in a search result) to first get those
results where the search string matches exactly (whole word) and then those
who include the search string.
Example :
Searchstring : car
Exact match : car
then
Including the serachstring : incarnation
Lorang
Dear sir,
Please help and drop me a email.([EMAIL PROTECTED])
I have Apache 1.3.17, MySQL 3.23.30 install on a Sparc Solaris 8 and Apache
1.3.20, MySQL 3.23.40 installed on a Interl RedHat Linux 7.1, I got
mod_auth_mysql-2.20 and following below instruction to compile and failed on
both
Hi,
I am facing some problem using MYSQL..When I am listing the records I am
getting the following error..
Microsoft Cursor Engine error '80004005'
The data provider or other service returned an E_FAIL status.
/keyknowledgev1.2/content/admin/productlist.asp, line 87
Line 87 Highlighted below
Hi,
I have the following queries:
SELECT account FROM user where username = 'george';
then using the result from this query,
i pass it onto the next:
SELECT * FROM record WHERE account = 'result from above';
I am new to 'JOIN' and dont know the correct join syntax.
THANKS,
jaime
select record.* from record left join account on
account.username=record.account where account.username='george'
SELECT account FROM user where username = 'george';
then using the result from this query,
i pass it onto the next:
SELECT * FROM record WHERE account = 'result from above';
I am
Hi all,
I am working on Redhatversion 6.2. I used Mysql version 3.22.xx
before . I took the back up of all datas. I formatted my machine 2 weeks
back. I installed mysql version 3.23.33 using rpm file. Now i copied the
backedup datas to /var /lib/mysql directory.I can start the mysql daemon
Hello everyone,
I have been running mysql for a little while now and my filesystem seems to
get a little tight. I decided to setup a file server that would provide one
of its disk to act as the mysql data drive.
Anyhow, the operation seemed to be quite simple:
1. Mount the new partition
Hi,
Thanks for the advice. Looked on mysql.com for advice on REGEXP. Seems
promising but I can't seem to find the right regexp (I hate them :-()
I might just have to screen the words before I search like james suggested,
does anyone know where I can get a list of commonly usd words! ;-)
Hello,
I'm trying to do a mysql select statement like this:
SELECT * FROM news WHERE newstype = '1' AND global = '1' OR depart =
'center' ORDER BY SortNumber ASC
But I would like the ORDER BY to list all records where depart = 'center'
first and then all the rest of the depart records in
l Hello,
l I'm trying to do a mysql select statement like this:
l SELECT * FROM news WHERE newstype = '1' AND global = '1' OR depart =
l 'center' ORDER BY SortNumber ASC
l But I would like the ORDER BY to list all records where depart = 'center'
l first and then all the rest of the depart
On Thursday 20 September 2001 20:37, R Talbot wrote:
My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
being too old but how muc trouble is it to upgrade.the LIB
V. 3.23.40 is running but with 12 failed tests including bigint is
this an install I want to develop with.
You _might_ also be able to do something like:
SELECT *
FROM news
WHERE newstype='1' AND global='1'
ORDER BY concat(if(depart='center', 'A', 'B'), SortNumber) ASC
I don't have quite enough info here, but I'm going to assume that you
want the records with depart='center' sorted
Hi!
On Sep 21, Jordan Elver wrote:
Hi,
Thanks for the advice. Looked on mysql.com for advice on REGEXP. Seems
promising but I can't seem to find the right regexp (I hate them :-()
I might just have to screen the words before I search like james suggested,
does anyone know where I can
You coppied it as root, and mysql does not own it.
chown -R mysql /var/lib/mysql
Nandakumar wrote:
Hi all,
I am working on Redhatversion 6.2. I used Mysql version 3.22.xx
before . I took the back up of all datas. I formatted my machine 2 weeks
back. I installed mysql version 3.23.33
You must also be sure the mysql user has read, write, and execute
permissions in the nfs mounted directories.
Patrick Drouin wrote:
Hello everyone,
I have been running mysql for a little while now and my filesystem seems to
get a little tight. I decided to setup a file server that would
Hi, I'm the author of the JDBC driver. I'm not sure what the problem is, but
I am going to try and talk you out of storing multi-megabytes as blobs.
Here's whyIn most cases it is more overhead than it is worth. If you're
going to be serving the data from these blobs from some other type of
We've had problems for a few months with corruption of a MyISAM table,
when deleting many rows. The same setup/code didn't have problems under
3.22.x but started when we switched to 3.23.x - we're now running 3.23.40.
The table is used by a mod_perl application serving webpages running on
Hello,
I need to create a user ('x', for instance) that only has permission to
access (Select, insert, update, delete) only 2 tables in a database
('test').
Assuming that 'x' does not exist, I execute the folowing statments ('a' and
'b' are the tables whose access I want to grant to 'x'),
Hello
I was wondering if it is possible (in a search result) to first get those
results where the search string matches exactly (whole word) and then those
who include the search string.
Example :
Searchstring : car
Exact match : car
then
Including the serachstring : incarnation
Lorang
Hello Tommy!
We suspect that the problem is related to the fact that we delete ~7000
rows and inserts the same shortly thereafter. The mysql-manual mentions
that you should run an optimize table after deleting many rows from a
table, but doesn't list it as an requirement.
If you're having
Hi,
We have MySQL 3.23.27 stalled and running on a Solaris 2.7 machine. We are
planning to move our server to AFS school system (OS version is Solaris 2.7
(Sparc)). The AFS version is 3.5 or 3.46.
Is anybody know whether MySQL 3.23.27 is compatible with AFS 3.5 3.46?
Have a nice
Preface #1: Hi MySQL Admin!
There's an oddity at http://www.mysql.com/doc/. Entering my.cnf returns no
hits. Entering cnf returns all relevant hits.
Preface #2: Hi All!
Folks, this is the *best* online documentation I have ever ever seen. You
can save youself lotsa time waiting for replies
Can anyone please guide me in uninstalling MySQL...
P.S: i did a rpm -e but there was no mysql rpm package...
tia,
sandeep
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Have a look at urSQL -- http://www.urbanresearch.com/ursql
On Fri, 21 Sep 2001, Calvin Chin wrote:
Can anyone out there provide GUI-Based table creation tools for mySQL?
(something like Access)
Thank you.
Regards,
Calvin Chin
[EMAIL PROTECTED]
Ipmuda Berhad - Building materials for
Hi,
I have mysql installed on a Linux server, I am trying to connect to the
server using mysql client for windows, I get the following error
Host '192.121.2.115' is not allowed to connect to this MySQL server,
any idea what permissions I need to change to be able to connect?
Thanks
Hi
I have a large genome database running on MySQL (Ver. 3.23) . I
would like to mirror it on a IBM DB2 (Ver 7.2) Server. Could someone
tell me if this could be done?
Regards,
Radhakrishnan Sundaresan.
Radhakrishnan Sundaresan
Graduate Research Assistant
Cluster I/O Labs, Ohio State
JSaur,
Hello Igbar,
thank you for your script.
Bud I need to change just word with. Woman with hammer was just example.
There is text about 1000 words in one fied, and I need to change just a
short string.
I show you another example.
CREATE TABLE my_table(c1 int NOT NULL PRIMARY KEY, c2 blob);
Hi Kishore!
I have mysql installed on a Linux server, I am trying to connect to the
server using mysql client for windows, I get the following error
Host '192.121.2.115' is not allowed to connect to this MySQL server,
any idea what permissions I need to change to be able to connect?
Dear friends,
My name is Jimi. I am working on a project that
involves to store my data through c++ in mysql.
when i tried to run my program that just tries to
connect to mysql server, following error arrived :
/usr/lib/mysql/libmysqlclient.so : undefined
reference
to '[EMAIL
Howabout
select record.* from record left join user on
user.account=record.account where user.username='george';
Since there is no table name account
select record.* from record left join account on
account.username=record.account where account.username='george'
SELECT account FROM user
Dear friends,
I have downloaded following packages from mysql.com
MySQL-3.23.41-1.i386.rpm
when i tried to double click on it, it showed me
following error :
Application gnomrpm-auth (process 2624) has crashed
due to fatal error(Segmentation fault)
when i tried to install it from
Glad to hear this. I was already going that way with my site because I
didn't want to have to either drop and reload the database or take ther
mysql server down to run the cleanup utility. W/o blobs/text you can use
fixed length fields which means the database doesn't become fragmented.
On
Can anyone out there provide GUI-Based table creation tools for mySQL?
(something like Access)
Here is an ERD based tool with full support for MySQL. Versions for various platforms
including Linux and Windows
http://www.thekompany.com/products/dataarchitect/index.php3?dhtml_ok=1
Peter
Need to change locations of where mysql is storing all its database info.
When the system starts it initiates safe_mysqld and starts with the base
dir of /usr/var/local
I dont have a my.cnf but now need to relocate the database on the system,
where does mysql get the environtment var's it uses
Keith Woodworth writes:
I dont have a my.cnf but now need to relocate the database on the system,
where does mysql get the environtment var's it uses to start by default?
It doesn't get them from env vars AFAIK, but you can change them at
compile time. Also, there are command-line
Does anyone know of any applications that insert email into mysql databases?
I can use either Windows or Linux as the client; however, I want mysql
server on the linux box (for stability). I don't like having all of my
email in MSOutlook's proprietary format because in 5 years when I need to
From: jweage
To: [EMAIL PROTECTED]
Subject: compile fails under HP-UX 11.00 missing
CBREAK
Description:
I've configured mysql with ./configure
--prefix=/usr/arch/mysql
--disable shared. Typing make produces the following
error:
rltty.c: In function `prepare_terminal_settings':
Hi!
I had a similar problem using gcc-3.0 on HP-UX-11.0.
...
configure:4198: gcc -E -D__STDC_EXT__ conftest.c /dev/null 2conftest.out
command line: warning: __STDC_EXT__ redefined
command line: warning: this is the location of the previous definition
configure: failed program was:
#line 4193
I'm a little fuzzy on this, but I seem to recall that a .forward file can
call a program (perl script?) of your choosing for each mail message. Or,
perhaps procmail can do this task?
Regards,
Rich
At 01:05 PM 9/21/01, Christopher Bergeron wrote:
Does anyone know of any applications that
Setup :
MySQL 3.23.42
Perl 5.6.0
DBI 10.32
I’m trying to do a few different queries where the table name needs to be
dynamic. I’ve tried the following :
$dbquery = $dbhandler-prepare_cached(“SELECT id, target FROM ? where
somedata=?”);
$dbquery-execute($tablename,$somedata);
But I keep
Rich,
I do recall that there was a mail program that was written in Perl that
utilized mySQL as the backend for storing the message. It was reviewed in
Linux Journal. I still have the CD on my desk but haven't had a chance to
install yet so I cannot give you a personal review, but the write ups
Just installed mssql and in the end of the installation I receive the
message taht now is the time to change root password for the db using
mysqladmin using the following synthax:
/usr/bin/mysqladmin -u root -p password 'new password'
So issued the following command:
/usr/bin/mysqladmin -u root
Try this :
/usr/bin/mysqladmin -u root -p password '22'
The first instance of 'password' is a command.. It doesn't mean you need to
replace it with the password..
---
Jason H. Frisvold
Senior ATM Engineer
Engineering Dept.
Penteledata
CCNA Certified - CSCO10151622
Hi all..
Can anybody tell me how or where doc of tutor complete about WinMySqladmin and
MySqlManager?I have only activated WinMySqladmin and MySqlManager but nothing more
because i only had little information about these things. I used WinMySqladmin Versi
1.2 which distribution by Miguel A.
Can anyone explain why I'm getting a Mail account is disabled message from
[EMAIL PROTECTED] regarding anything I post to the mysql list?
The body of the message says :
The mail account ([EMAIL PROTECTED]) is currently disabled, and is not
receiving mail at this time.
Thanks,
Jason Frisvold writes:
Can anyone explain why I'm getting a Mail account is disabled message from
[EMAIL PROTECTED] regarding anything I post to the mysql list?
Yep, that server uses some sort of broken software which
mistakes the sender for the receiver or does something
similarly
As near as I can figure there are a few people out there that have yet
to setup their MTA's correctly, so they think they're receiving messages
for any addresses in the headers of the email.
Jason Frisvold wrote:
Can anyone explain why I'm getting a Mail account is disabled message from
Okay, I know this is an RTFM question, but I tried, and I couldn't find
it in the online manual.
I was looking at the /var/lib/mysql directory today, where all my
databases are, and I noticed a bunch of machine-bin files. What /are/
those, and are they something I need to be concerned about?
--
Also,
a simple fix for you sendmail guru's
HFrom: tab $check_from
Scheck_from
[EMAIL PROTECTED] tab $#error $@ 5.5.5 $: Broken MTA, Message
ignored
Cheers.
Colin Faber wrote:
As near as I can figure there are a few people out there that have yet
to setup their MTA's correctly, so they
That would explain it... I appreciate the prompt replies :)
Thanks!
sql
---
Jason H. Frisvold
Senior ATM Engineer
Engineering Dept.
Penteledata
CCNA Certified - CSCO10151622
[EMAIL PROTECTED]
---
Only two things are infinite, the universe and
Don't feel badly, I wondered the same thing!
In a nutshell, they are logs, and you can delete them. You can also turn
them off (I did).
- Original Message -
From: Matthew Walker [EMAIL PROTECTED]
To: MySQL Mailling List [EMAIL PROTECTED]
Sent: Friday, September 21, 2001 2:36 PM
How would I go about turning them off? Yes, I know. Another RTFM
question, but some of these things are a little hard to find in the
online manual.
-Original Message-
From: Matthew Simpson [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 1:47 PM
To: Matthew Walker
Cc: [EMAIL
Okay, I know this is an RTFM question, but I tried, and I couldn't find
it in the online manual.
Try loading the manual, then do your browsers equivalent of
find in page, and search for -bin 3 or 4 searches on
next occurence, and you're there
I was looking at the /var/lib/mysql directory
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 9:48 PM
To: 'Matthew Simpson'
Cc: [EMAIL PROTECTED]
Subject: RE: Dumb Question...
How would I go about turning them off? Yes, I know. Another RTFM
question, but some of these
Currently I'm checking to see if a value exists in the database before
deciding whether to update it or insert it. Would this be quicker to do if
I merely used REPLACE? Is that the purpose of the REPLACE command? If it
exists, just update it, and if it doesn't exist, insert it?
Thanks,
Sasha Pachev wrote:
On Thursday 20 September 2001 20:37, R Talbot wrote:
My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
being too old but how muc trouble is it to upgrade.the LIB
V. 3.23.40 is running but with 12 failed tests including bigint is
this an install I
If I want to filter out records when SELECTing from a database, how do I do
it with an
and/or type of statement. Like this:
SELECT * FROM websites WHERE keywords LIKE '%akeyword%' AND/OR description
LIKE '%description%'
I want it to show most relevant (AND) then 2nd to most (OR). Please help.
Hi,
I need some help in installing MySQL.I did the following things
1) Downloaded the mysql version 3.23.36-pc-linux-gnu-i686.tar.gz
2) tar -zxvf mysql-version
3) ln -s /usr/local/mysql-version mysql
4) adduser mysql
5) passwd mysql
6) chown -R mysql mysql-vesion mysql
7) chgrp -R root
I'm having a difficult time synchronizing my Master and Slave Servers.
I've been doing this using MySQL Binary Logs, where the Master rotates the
logs at 1 hour times, and the slave downloads it and imports it.
What happens why I try to pipe the binlog into mysql is that it reports and
error
I'be been using phpMyAdmin and like it very much. Are there advantages to
using mysqlgui? Am interested in hearing from people who have tried both.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
At 4:27 PM -0400 9/21/01, Jason Frisvold wrote:
Currently I'm checking to see if a value exists in the database before
deciding whether to update it or insert it. Would this be quicker to do if
I merely used REPLACE? Is that the purpose of the REPLACE command? If it
exists, just update it, and
We are encountering two issues when using MySQL with large tables (by large,
we're talking 1 million rows). Our application is written in Java and we
are using the mm.mysql JDBC driver. We run our applications using both
Oracle and MySQL. Below are issues that we have experienced.
1. The
Hi.
I was wondering if there was a way to find out when the last time the
database was modified? (like a last modified function for a webpage?).
Thanks for the help.
Regards,
Camilo Rostoker
--
+=+
Camilo Rostoker
[EMAIL PROTECTED]
Sasha Pachev wrote:
On Thursday 20 September 2001 20:37, R Talbot
wrote:
My problem is probably my lib-2.1.2.so and
GNU Make v. 3.78.1
being too old but how muc trouble is it
to upgrade.the LIB
V. 3.23.40 is running but with 12 failed
tests including bigint is
this an install
Hi!
R == R Talbot [EMAIL PROTECTED] writes:
R Sasha Pachev wrote:
On Thursday 20 September 2001 20:37, R Talbot wrote:
My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
being too old but how muc trouble is it to upgrade.the LIB
V. 3.23.40 is running but with 12
database,sql,query,table
What version of Caldera are you running? I may be able to help next week.
tt,
--
Boyd Gerber [EMAIL PROTECTED]
ZENEZ 3748 Valley Forge Road, Magna Utah 84044
Office 801-250-0795 FAX 801-250-7975
R Talbot wrote:
Michael Widenius wrote:
Hi!
R == R Talbot [EMAIL PROTECTED] writes:
R Sasha Pachev wrote:
On Thursday 20 September 2001 20:37, R Talbot wrote:
My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
being too old but how muc trouble is it to
R Talbot wrote:
Boyd Lynn Gerber wrote:
What version of Caldera are you running? I may be able to help next week.
tt,
--
Boyd Gerber [EMAIL PROTECTED]
ZENEZ 3748 Valley Forge Road, Magna Utah 84044
Office 801-250-0795 FAX 801-250-7975
Hi...
I am a Caldera user since
Monty,
Took your advice and downloaded
mysql-3.23.42-pc-linux-gnu-i686.tar.gz
Placed it in /usr/local
Renamed /usr/local/mysql to /usr/local/mysql-old
unpacked with
tar -zxvf mysql-3.23.42-pc-linux-gnu-i686.tar.gz
which made /usr/local/mysql-3.23.42-pc-linux-gnu-i686
I checked out the dir
71 matches
Mail list logo